Install Hands on Maxscale and Mariadb Galera Cluster

brijendrasial · Dec 20, 2019

MariaDB MaxScale is a database proxy that extends the high availability, scalability, and security of MariaDB Server while at the same time simplifying application development by decoupling it from underlying database infrastructure.

First Create 4 Nodes of Centminmod Installation

Node1:192.168.1.1 (CMM Installed) (MariaDB Cluster 1)
Node2:192.168.1.2 (CMM Installed) (MariaDB Cluster 2)
Node3:192.168.1.3 (CMM Installed) (MariaDB Cluster 3)
Node4:192.168.1.4 (CMM Installed) (Maxscale)

Open These ports 4567,4568,4444,3306 under TCP in your firewall (CSF or IPTABLES) on All MariaDB Cluster nodes.

On 192.168.1.1 (CMM Installed) (MariaDB Cluster 1)

Edit my.cnf file and at the end add lines below

Must change
Replace wsrep_node_address=”192.168.1.1″ with your node1 IP address.
Replace wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3 with your node1,node2,node3 IP respectively.

Alternatively you can also
Replace wsrep_cluster_name=”bullten” as you want but do remember it should be same on all nodes.
Replace wsrep_node_name=”node1″ to any name you want.
Code:
vi /etc/my.cnf
[galera]
# Mandatory settings
wsrep_on=ON
wsrep_cluster_name="bullten"
wsrep_node_name="node1"
wsrep_node_address="192.168.1.1"
#wsrep_provider_options='pc.recovery=ON'
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3
binlog_format=row
innodb_autoinc_lock_mode=2
Click to expand...

Stop MariaDB
Code:
systemctl stop mariadb
Start Galera Cluster
Code:
galera_new_cluster
Change the permission
Code:
chown -R mysql:mysql /var/lib/mysql
On 192.168.1.2 (CMM Installed) (MariaDB Cluster 2)

Edit my.cnf file and at the end add lines below

Must change
Replace wsrep_node_address=”192.168.1.2″ with your node2 IP address.
Replace wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3 with your node1,node2,node3 IP respectively.

Alternatively you can also
Replace wsrep_node_name=”node2″ to any name you want.
Code:
vi /etc/my.cnf
[galera]
# Mandatory settings
wsrep_on=ON
wsrep_cluster_name="bullten"
wsrep_node_name="node2"
wsrep_node_address="192.168.1.2"
#wsrep_provider_options='pc.recovery=ON'
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3
binlog_format=row
innodb_autoinc_lock_mode=2
Click to expand...

Change the permission
Code:
chown -R mysql:mysql /var/lib/mysql
Stop MariaDB
Code:
systemctl stop mariadb
Start MariaDB
Code:
systemctl start mariadb
On 192.168.1.3 (CMM Installed) (MariaDB Cluster 3)

Edit my.cnf file and at the end add lines below

Must change
Replace wsrep_node_address=”192.168.1.3″ with your node3 IP address.
Replace wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3 with your node1,node2,node3 IP respectively.

Alternatively you can also
Replace wsrep_node_name=”node3″ to any name you want.
Code:
vi /etc/my.cnf
[galera]
# Mandatory settings
wsrep_on=ON
wsrep_cluster_name="bullten"
wsrep_node_name="node3"
wsrep_node_address="192.168.1.3"
#wsrep_provider_options='pc.recovery=ON'
wsrep_provider=/usr/lib64/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://192.168.1.1,192.168.1.2,192.168.1.3
binlog_format=row
innodb_autoinc_lock_mode=2
Click to expand...

Change the permission
Code:
chown -R mysql:mysql /var/lib/mysql
Stop MariaDB
Code:
systemctl stop mariadb
Start MariaDB
Code:
systemctl start mariadb
Now your Node is connected to check cluster size run the below command on any MariaDB node
Code:
SHOW GLOBAL STATUS LIKE 'wsrep_cluster_size';
wsrep_cluster_size = 3 shows three nodes are inter connected.

On 192.168.1.4 (CMM Installed) Install (Maxscale)

Install Maxscale
Code:
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -- --mariadb-server-version=mariadb-10.3
sed -i 's|mariadb-main|mariadb|' /etc/yum.repos.d/mariadb.repo
yum -y install maxscale
On one of the MariaDB node run the below commands. Replace 192.168.1.4 with your maxscale node IP.
Code:
create user 'maxscale_user'@'192.168.1.4' identified by 'maxscale_password';

grant select on mysql.user to 'maxscale_user'@'192.168.1.4';

grant select on mysql.roles_mapping to 'maxscale_user'@'192.168.1.4';

grant select on mysql.db to 'maxscale_user'@'192.168.1.4';

grant select on mysql.tables_priv to 'maxscale_user'@'192.168.1.4';

grant show databases on *.* to 'maxscale_user'@'192.168.1.4';
Generate and save the encrypted password
Code:
maxkeys
maxpasswd maxscale_password
Save Original configuration file of Maxscale
Code:
mv /etc/maxscale.cnf /etc/maxscale.cnf.old
Create new maxscale.cnf file and add below entries.

password=9D797E4DAB257039C167186BC2527463DB5878F85E543A3A418EDA8ED447344B is the encrypted password we created above i.e maxscale_password.
module=galeramon describes galera cluster monitoring
port=5492 Port at which remotely we will connect.
Code:
vi /etc/maxscale.cnf
#Globals
[maxscale]
threads=1

#Servers
[server1]
type=server
address=192.168.1.1
port=3306
protocol=MariaDBBackend
priority=0

[server2]
type=server
address=192.168.1.2
port=3306
protocol=MariaDBBackend
priority=1

[server3]
type=server
address=192.168.1.3
port=3306
protocol=MariaDBBackend
priority=2

#Monitoring for the servers
[Galera-Monitor]
type=monitor
module=galeramon
servers=server1,server2,server3
user=maxscale_user
password=9D797E4DAB257039C167186BC2527463DB5878F85E543A3A418EDA8ED447344B
monitor_interval=1000

#Galera router service
[Galera-Service]
type=service
router=readwritesplit
servers=server1,server2,server3
user=maxscale_user
password=9D797E4DAB257039C167186BC2527463DB5878F85E543A3A418EDA8ED447344B

#Galera cluster listener
[Galera-Listener]
type=listener
service=Galera-Service
protocol=MariaDBClient
address=0.0.0.0
port=5492
Click to expand...

verify configuration file
Code:
maxscale -c -U maxscale
2019-12-20 02:37:01 notice : Configuration file: /etc/maxscale.cnf
2019-12-20 02:37:01 notice : Log directory: /var/log/maxscale
2019-12-20 02:37:01 notice : Data directory: /var/lib/maxscale
2019-12-20 02:37:01 notice : Module directory: /usr/lib64/maxscale
2019-12-20 02:37:01 notice : Service cache: /var/cache/maxscale
2019-12-20 02:37:01 notice : Worker message queue size: 1.00MiB
2019-12-20 02:37:01 notice : No query classifier specified, using default 'qc_sqlite'.
2019-12-20 02:37:01 notice : Loaded module qc_sqlite: V1.0.0 from /usr/lib64/maxscale/libqc_sqlite.so
2019-12-20 02:37:01 notice : Query classification results are cached and reused. Memory used per thread: 275.67MiB
2019-12-20 02:37:01 notice : Loading /etc/maxscale.cnf.
2019-12-20 02:37:01 notice : /etc/maxscale.cnf.d does not exist, not reading.
2019-12-20 02:37:01 notice : Loaded module MariaDBClient: V1.1.0 from /usr/lib64/maxscale/libmariadbclient.so
2019-12-20 02:37:01 notice : [readwritesplit] Initializing statement-based read/write split router module.
2019-12-20 02:37:01 notice : Loaded module readwritesplit: V1.1.0 from /usr/lib64/maxscale/libreadwritesplit.so
2019-12-20 02:37:01 notice : [galeramon] Initialise the MySQL Galera Monitor module.
2019-12-20 02:37:01 notice : Loaded module galeramon: V2.0.0 from /usr/lib64/maxscale/libgaleramon.so
2019-12-20 02:37:01 notice : Loaded module MariaDBBackend: V2.0.0 from /usr/lib64/maxscale/libmariadbbackend.so
2019-12-20 02:37:01 notice : Loaded module mariadbbackendauth: V1.0.0 from /usr/lib64/maxscale/libmariadbbackendauth.so
2019-12-20 02:37:01 notice : Loaded module mariadbauth: V1.1.0 from /usr/lib64/maxscale/libmariadbauth.so
2019-12-20 02:37:01 notice : Configuration was successfully verified.
Click to expand...

Start and enable Maxscale service
Code:
systemctl start maxscale.service
systemctl enable maxscale.service
On Maxscale node enter into mysql and check cluster. After running the below command stop any node of MariaDB and check if hostname values changes then.
Code:
mysql -h 192.68.1.4 -P 5492 -u maxscale_user -pmaxscale_password
show variables like 'hostname';
Now lets try some Maxscale commands using maxctrl
Code:
maxctrl list servers
Code:
maxctrl show servers
Code:
maxctrl list modules
Code:
maxctrl list services
Code:
maxctrl list threads
Take Server Out for Maintenance.
Code:
maxctrl set server server1 maintenance
Set server back online after maintenance
Code:
maxctrl clear server server1 maintenance
Code:
maxctrl show threads --tsv
Id 0
Accepts 3
Reads 61
Writes 54
Hangups 2
Errors 0
Avg event queue length 1
Max event queue length 2
Max exec time 0
Max queue time 0
Current FDs 3
Total FDs 14
Load (1s) 0
Load (1m) 0
Load (1h) 0
QC cache size 53
QC cache inserts 2
QC cache hits 8
QC cache misses 2
QC cache evictions 0
Click to expand...

Source: Hands on Maxscale and Galera Cluster Centos7 – LinuxGlobe

eva2000 · Dec 21, 2019

Thanks for sharing ! (y)

Regarding maxscale install

Code (Text):

curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
yum -y install maxscale

be careful that installs 3 repos including one that Centmin Mod already setup for MariaDB and it defaults to MariaDB 10.4 instead of Centmin Mod 123.09beta01's MariaDB 10.3 ! So if you did a yum update you would accidently update Centmin Mod MariaDB 10.3 to 10.4 which you don't want to do right now. Centmin Mod has it's own way of updating to MariaDB 10.4 which automatically takes into account /etc/my.cnf settings changes required for MariaDB 10.4 https://community.centminmod.com/threads/mariadb-10-1-upgrades-to-mariadb-10-2-10-3-and-10-4.17793/

So instead make sure you specify MariaDB 10.3 as server version repo you want

Code (Text):

mkdir -p /root/tools
cd /root/tools
wget -4 https://downloads.mariadb.com/MariaDB/mariadb_repo_setup
chmod +x mariadb_repo_setup
./mariadb_repo_setup --mariadb-server-version=mariadb-10.3
yum -y install maxscale

example of repo setup run

Code (Text):

./mariadb_repo_setup --mariadb-server-version=mariadb-10.3
[warning] Found existing file at /etc/yum.repos.d/mariadb.repo. Moving to /etc/yum.repos.d/mariadb.repo.old_1.
[info] Repository file successfully written to /etc/yum.repos.d/mariadb.repo.
[info] Adding trusted package signing keys...
[info] Successfully added trusted package signing keys.

sdiff side by side diff compare of differences between old Centmin Mod setup mariadb.repo (left) vs mariadb_repo_setup script's setup mariadb.repo (right). Looks like even the baseurl differs using yum.mariadb.org/10.3/centos7-amd64 vs downloads.mariadb.com/MariaDB/mariadb-10.3/

Code (Text):

sdiff -w200 -s /etc/yum.repos.d/mariadb.repo.old_1 /etc/yum.repos.d/mariadb.repo
name = MariaDB                                                                                     |    name = MariaDB Server
baseurl = http://yum.mariadb.org/10.3/centos7-amd64                                                |    baseurl = https://downloads.mariadb.com/MariaDB/mariadb-10.3/yum/rhel/$releasever/$basearch
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB                                                 |    gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
gpgcheck=1                                                                                         |    gpgcheck = 1
exclude=MariaDB-Galera-server                                                                      |    enabled = 1
                                                                                                   >
                                                                                                   >    [mariadb-maxscale]
                                                                                                   >    # To use the latest stable release of MaxScale, use "latest" as the version
                                                                                                   >    # To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the v
                                                                                                   >    name = MariaDB MaxScale
                                                                                                   >    baseurl = https://downloads.mariadb.com/MaxScale/2.4/centos/$releasever/$basearch
                                                                                                   >    gpgkey = file:///etc/pki/rpm-gpg/MariaDB-MaxScale-GPG-KEY
                                                                                                   >    gpgcheck = 1
                                                                                                   >    enabled = 1
                                                                                                   >
                                                                                                   >    [mariadb-tools]
                                                                                                   >    name = MariaDB Tools
                                                                                                   >    baseurl = https://downloads.mariadb.com/Tools/rhel/$releasever/$basearch
                                                                                                   >    gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Enterprise-GPG-KEY
                                                                                                   >    gpgcheck = 1
                                                                                                   >    enabled = 1

or via diff

Code (Text):

diff -u /etc/yum.repos.d/mariadb.repo.old_1 /etc/yum.repos.d/mariadb.repo
--- /etc/yum.repos.d/mariadb.repo.old_1 2019-09-25 13:23:04.412553694 +0000
+++ /etc/yum.repos.d/mariadb.repo       2019-12-20 16:26:25.483536220 +0000
@@ -1,6 +1,22 @@
-[mariadb]
-name = MariaDB
-baseurl = http://yum.mariadb.org/10.3/centos7-amd64
-gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
-gpgcheck=1
-exclude=MariaDB-Galera-server
+[mariadb-main]
+name = MariaDB Server
+baseurl = https://downloads.mariadb.com/MariaDB/mariadb-10.3/yum/rhel/$releasever/$basearch
+gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
+gpgcheck = 1
+enabled = 1
+
+[mariadb-maxscale]
+# To use the latest stable release of MaxScale, use "latest" as the version
+# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
+name = MariaDB MaxScale
+baseurl = https://downloads.mariadb.com/MaxScale/2.4/centos/$releasever/$basearch
+gpgkey = file:///etc/pki/rpm-gpg/MariaDB-MaxScale-GPG-KEY
+gpgcheck = 1
+enabled = 1
+
+[mariadb-tools]
+name = MariaDB Tools
+baseurl = https://downloads.mariadb.com/Tools/rhel/$releasever/$basearch
+gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Enterprise-GPG-KEY
+gpgcheck = 1
+enabled = 1

also the main mariadb repo name changes form mariadb to mariadb-main so any Centmin Mod features which look for mariadb repo name will be broken now

example listing available mariadb repo yum packages referencing mariadb will be broken

Code (Text):

yum list available --disablerepo=* --enablerepo=mariadb
Loaded plugins: fastestmirror, priorities, versionlock
Error getting repository data for mariadb, repository not found

while referencing the new renamed mariadb-main will work

Code (Text):

yum list available --disablerepo=* --enablerepo=mariadb-main
Loaded plugins: fastestmirror, priorities, versionlock
Loading mirror speeds from cached hostfile
Available Packages
MariaDB-backup.x86_64                                                                                                                10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-backup-debuginfo.x86_64                                                                                                      10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-cassandra-engine.x86_64                                                                                                      10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-cassandra-engine-debuginfo.x86_64                                                                                            10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-client-debuginfo.x86_64                                                                                                      10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-common-debuginfo.x86_64                                                                                                      10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-connect-engine.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-connect-engine-debuginfo.x86_64                                                                                              10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-cracklib-password-check.x86_64                                                                                               10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-cracklib-password-check-debuginfo.x86_64                                                                                     10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-devel-debuginfo.x86_64                                                                                                       10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-gssapi-server.x86_64                                                                                                         10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-gssapi-server-debuginfo.x86_64                                                                                               10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-oqgraph-engine.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-oqgraph-engine-debuginfo.x86_64                                                                                              10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-rocksdb-engine.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-rocksdb-engine-debuginfo.x86_64                                                                                              10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-server-debuginfo.x86_64                                                                                                      10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-shared-debuginfo.x86_64                                                                                                      10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-test.x86_64                                                                                                                  10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-test-debuginfo.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-tokudb-engine.x86_64                                                                                                         10.3.21-1.el7.centos                                                                                     mariadb-main
MariaDB-tokudb-engine-debuginfo.x86_64                                                                                               10.3.21-1.el7.centos                                                                                     mariadb-main
libzstd.x86_64                                                                                                                       1.3.4-1.el7                                                                                              mariadb-main

of course easy to fix, just edit mariadb.repo and change name of mariadb-main repo back to mariadb via sed replacement

Code (Text):

sed -i 's|mariadb-main|mariadb|' /etc/yum.repos.d/mariadb.repo

contents of edited /etc/yum.repos.d/mariadb.repo

Code (Text):

[mariadb]
name = MariaDB Server
baseurl = https://downloads.mariadb.com/MariaDB/mariadb-10.3/yum/rhel/$releasever/$basearch
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Server-GPG-KEY
gpgcheck = 1
enabled = 1

[mariadb-maxscale]
# To use the latest stable release of MaxScale, use "latest" as the version
# To use the latest beta (or stable if no current beta) release of MaxScale, use "beta" as the version
name = MariaDB MaxScale
baseurl = https://downloads.mariadb.com/MaxScale/2.4/centos/$releasever/$basearch
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-MaxScale-GPG-KEY
gpgcheck = 1
enabled = 1

[mariadb-tools]
name = MariaDB Tools
baseurl = https://downloads.mariadb.com/Tools/rhel/$releasever/$basearch
gpgkey = file:///etc/pki/rpm-gpg/MariaDB-Enterprise-GPG-KEY
gpgcheck = 1
enabled = 1

verify referencing MariaDB main yup repo via = mariadb name

Code (Text):

yum list available --disablerepo=* --enablerepo=mariadb
Loaded plugins: fastestmirror, priorities, versionlock
Loading mirror speeds from cached hostfile
mariadb                                                                                                                                                                                                                            | 2.9 kB  00:00:00  
mariadb/7/x86_64/primary_db                                                                                                                                                                                                        |  53 kB  00:00:02  
Available Packages
MariaDB-backup.x86_64                                                                                                                  10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-backup-debuginfo.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-cassandra-engine.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-cassandra-engine-debuginfo.x86_64                                                                                              10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-client-debuginfo.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-common-debuginfo.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-connect-engine.x86_64                                                                                                          10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-connect-engine-debuginfo.x86_64                                                                                                10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-cracklib-password-check.x86_64                                                                                                 10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-cracklib-password-check-debuginfo.x86_64                                                                                       10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-devel-debuginfo.x86_64                                                                                                         10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-gssapi-server.x86_64                                                                                                           10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-gssapi-server-debuginfo.x86_64                                                                                                 10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-oqgraph-engine.x86_64                                                                                                          10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-oqgraph-engine-debuginfo.x86_64                                                                                                10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-rocksdb-engine.x86_64                                                                                                          10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-rocksdb-engine-debuginfo.x86_64                                                                                                10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-server-debuginfo.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-shared-debuginfo.x86_64                                                                                                        10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-test.x86_64                                                                                                                    10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-test-debuginfo.x86_64                                                                                                          10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-tokudb-engine.x86_64                                                                                                           10.3.21-1.el7.centos                                                                                        mariadb
MariaDB-tokudb-engine-debuginfo.x86_64                                                                                                 10.3.21-1.el7.centos                                                                                        mariadb
libzstd.x86_64                                                                                                                         1.3.4-1.el7                                                                                                 mariadb

brijendrasial · Dec 21, 2019

Always I keep my proxy node without centminmod so didnt notice that issue. Thanks for update

eva2000 · Dec 21, 2019

Yeah some folks might try this on their Centmin Mod servers so good to highlight this

I believe you can just change
Code (Text):
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
yum -y install maxscale
to
Code (Text):
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -- --mariadb-server-version=mariadb-10.3
sed -i 's|mariadb-main|mariadb|' /etc/yum.repos.d/mariadb.repo
yum -y install maxscale

brijendrasial · Dec 21, 2019

eva2000 said: ↑
Yeah some folks might try this on their Centmin Mod servers so good to highlight this

I believe you can just change
Code (Text):
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash
yum -y install maxscale
to
Code (Text):
curl -sS https://downloads.mariadb.com/MariaDB/mariadb_repo_setup | sudo bash -- --mariadb-server-version=mariadb-10.3
sed -i 's|mariadb-main|mariadb|' /etc/yum.repos.d/mariadb.repo
yum -y install maxscale
Click to expand...
Perfect done..

pamamolf · Dec 21, 2019

4567 port may need udp also?

4567 For Galera Cluster replication traffic. Multicast replication uses both UDP transport and TCP on this port.

Log in / Register

Forums

Get the most out of your Centmin Mod LEMP stack

Install Hands on Maxscale and Mariadb Galera Cluster

brijendrasial Active Member

eva2000 Administrator Staff Member

brijendrasial Active Member

eva2000 Administrator Staff Member

brijendrasial Active Member

pamamolf Premium Member Premium Member

.

Log in / Register

Useful Searches

Get the most out of your Centmin Mod LEMP stack

Install Hands on Maxscale and Mariadb Galera Cluster

brijendrasial Active Member

eva2000 Administrator Staff Member

brijendrasial Active Member

eva2000 Administrator Staff Member

brijendrasial Active Member

pamamolf Premium Member Premium Member

.