MaxScale

Documento di installazione:

https://mariadb.com/resources/blog/getting-started-mariadb-galera-and-mariadb-maxscale-centos

https://mariadb.com/kb/en/mariadb-enterprise/mariadb-maxscale-14/maxscale-readwrite-splitting-with-galera-cluster/

mkdir -p /opt/mysql/maxscale
cd /opt/mysql/maxscale
tar -xvzf maxscale-2.3.0.centos.7.tar.gz
rm maxscale-2.3.0.centos.7.tar.gz

ln -s maxscale-2.3.0.centos.7/bin bin
ln -s maxscale-2.3.0.centos.7/etc etc
ln -s maxscale-2.3.0.centos.7/lib64 lib64
ln -s maxscale-2.3.0.centos.7/share share
ln -s maxscale-2.3.0.centos.7/var var

mkdir -p /opt/mysql/maxscale/cache
mkdir -p /opt/mysql/maxscale/data
mkdir -p /opt/mysql/maxscale/log
mkdir -p /opt/mysql/maxscale/pid
mkdir -p /opt/mysql/maxscale/run
mkdir -p /opt/mysql/maxscale/scripts

mysql -u root

create user 'maxscale'@'%' identified by 'orione';
grant select on mysql.user to 'maxscale'@'%'; 
grant select on mysql.db to 'maxscale'@'%';
grant select on mysql.tables_priv to 'maxscale'@'%';
grant show databases on *.* to 'maxscale'@'%';

Example CNF

RPM prereq: gnutls-3.3.26-9.el7.i686.rpm

Attenzione abilitare da root:

./maxadmin enable account mysql

maxadmin -h 127.0.0.1 -P 6603 -u admin 
--- default password mariadb

Example Start MaxScale