Date: Mon, 30 Mar 2015 15:16:40 +0300 From: Pavel Timofeev <timp87@gmail.com> To: ports-list freebsd <freebsd-ports@freebsd.org>, horia@racoviceanu.com Subject: Galera ports Message-ID: <CAAoTqfsfyptmpAeptrzD%2BEpvz6vUOBtHpaHkLpyTCxkPvQcU=A@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
Hi! I'm a bit surprised that we don't have ports for galera cluster. I want to discuss about them a little bit. In short about galera and how it works (how I understand it): it's a kind of cluster of MySQL-based DBs. They support MySQL, Percona and MariaDB right now. Web site http://galeracluster.com/. ~Components: 1. A special version of MySQL-based DB daemon, patched to work with wsrep API. It can be MySQL Galera Cluster, Percona XtraDB Cluster or MariaDB Galera CLuster. 2. A common "plugin" for them all, which is plugged in through my.cnf. It's called "Galera 3 wsrep provider library" usually. 3. Arbitrator - a DB daemon without data to prevent split-brain and etc. Cluster version of MySQL-based DB daemons are usually(always?) synced with non-cluster regular versions. We have a port only for #2 now - databases/galera (which is useless in such case, no?). There is no port for #3 at all. There are a couple of PRs to add #1 to ports tree, which were created about a year ago. No progress since then. https://bugs.freebsd.org/bugzilla/buglist.cgi?quicksearch=galera. However, I'd like to discuss about something. It's just my thoughts. 1. As you can see those PRs are trying to add *-server and *-client ports for each of clustered MySQL-based DBs (I know, not for Percona). Is there any need to add another yet version of client? What's a reason to make *-client ports? Because nothing depends on *-server ports. IMO we should use regular ports for clients and add only a server part, as Linuxes does. For example, databases/mysql56-client for MySQL Galera Cluster. In such case a lot of work to add a dependency for new *-client is not needed. 2. How *-server ports should be named? At first glance the obvious names are: databases/mysql5[56]-galera-cluster databases/percona5[56]-xtradb-cluster databases/mariadb(55|100)-galera-cluster Not bad, but what about the same names, but without (galera|xtradb) word? Or without "cluster" word. Like databases/mysql56-cluster next to databases/mysql56-server and databases/mysql56-client. How do you think?
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAAoTqfsfyptmpAeptrzD%2BEpvz6vUOBtHpaHkLpyTCxkPvQcU=A>