{"id":5377,"date":"2015-10-21T10:27:44","date_gmt":"2015-10-21T02:27:44","guid":{"rendered":"http:\/\/rmohan.com\/?p=5377"},"modified":"2015-10-21T10:27:44","modified_gmt":"2015-10-21T02:27:44","slug":"yum-to-configure-multiple-master-cluster-mariadb-galera","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=5377","title":{"rendered":"Yum to configure multiple master cluster MariaDB Galera"},"content":{"rendered":"
\nYum to configure multiple master cluster MariaDB Galera<\/div>\n
<\/div>\n
Hereinafter, if the command is not preceded by PS1 is to represent the three nodes are required to perform the same action, if it means the implementation of the action on the specified node<\/p>\n

cluster1.rmohan.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Centos6.7\u00a0\u00a0 192.168.1.60\u00a0\u00a0\u00a0 MariaDB
\ncluster2.rmohan.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Centos6.7\u00a0\u00a0 192.168.1.62\u00a0\u00a0\u00a0 MariaDB
\ncluster3.rmohan.com\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Centos6.7\u00a0\u00a0 192.168.1.63\u00a0\u00a0\u00a0 MariaDB<\/p><\/div>\n

<\/div>\n
Hereinafter, if the command is not preceded by PS1 is to represent the three nodes are required to perform the same action, if it means the implementation of the action on the specified node<\/div>\n
<\/div>\n
1, install ntpdate to set timing on node cluster1 cluster2 cluster3 each other synchronization and ssh<\/div>\n
<\/div>\n
yum install -y ntpdate\u00a0 openssh-askpass openssh-client* wget<\/div>\n
<\/div>\n
\necho “*\/5 * * * * \/usr\/sbin\/ntpdate pool.ntp.org >\/dev\/null 2>&1” >> \/var\/spool\/cron\/root<\/div>\n
<\/div>\n
\/usr\/sbin\/ntpdate pool.ntp.org<\/div>\n
<\/div>\n
cat >> \/etc\/hosts << EOF
\n192.168.1.60\u00a0 cluster1.rmohan.com\u00a0 cluster1
\n192.168.1.62\u00a0 cluster2.rmohan.com\u00a0 cluster2
\n192.168.1.63\u00a0 cluster3.rmohan.com\u00a0 cluster3
\nEOF<\/div>\n
<\/div>\n
Here is the production of a key ###<\/div>\n
<\/div>\n
ssh-keygen\u00a0 -t rsa -f ~\/.ssh\/id_rsa\u00a0 -P ”
\n### The following are performed on each node, so that the public key of the machine onto the other nodes
\nawk ‘{if ($0!~\/'”$(hostname)”‘|localhost\/)print $NF}’ \/etc\/hosts |xargs -i ssh-copy-id -i ~\/.ssh\/id_rsa.pub root@{}<\/div>\n
<\/div>\n
\n2, installed base build environment<\/div>\n
<\/div>\n
Add EPEL Repository which is provided from Fedora project.
\nyum -y install epel-release
\n# set [priority=5]<\/div>\n
<\/div>\n
sed -i -e \u201cs\/\\]$\/\\]\\npriority=5\/g\u201d \/etc\/yum.repos.d\/epel.repo
\n# for another way, change to [enabled=0] and use it only when needed
\nsed -i -e \u201cs\/enabled=1\/enabled=0\/g\u201d \/etc\/yum.repos.d\/epel.repo
\n# if [enabled=0], input a command to use the repository
\nyum \u2013enablerepo=epel install [Package]<\/div>\n
<\/div>\n
Add RPMforge Repository which provides many useful packages.<\/div>\n
<\/div>\n
yum -y install http:\/\/pkgs.repoforge.org\/rpmforge-release\/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
\n# set [priority=10]
\nsed -i -e \u201cs\/\\]$\/\\]\\npriority=10\/g\u201d \/etc\/yum.repos.d\/rpmforge.repo
\n# for another way, change to [enabled=0] and use it only when needed
\nsed -i -e \u201cs\/enabled = 1\/enabled = 0\/g\u201d \/etc\/yum.repos.d\/rpmforge.repo
\n# if [enabled=0], input a command to use the repository
\nyum \u2013enablerepo=rpmforge install [Package]<\/div>\n
<\/div>\n
rpm -ivh http:\/\/mirrors.aliyun.com\/epel\/epel-release-latest-6.noarch.rpm
\nrpm \u2013import http:\/\/mirrors.dwhd.org\/epel\/RPM-GPG-KEY-EPEL-6
\nrpm -ivh http:\/\/pkgs.repoforge.org\/rpmforge-release\/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
\nrpm \u2013import http:\/\/mirrors.dwhd.org\/repoforge\/RPM-GPG-KEY.dag.txt<\/div>\n
<\/div>\n
yum clean all && yum makecache
\nyum groupinstall \u201cDevelopment tools\u201d \u201cServer Platform Development\u201d -y
\nyum install libxml2-devel lz4 lz4-devel libpcap nmap lsof socat -y<\/div>\n
<\/div>\n
\n[mariadb]
\nname = MariaDB
\nbaseurl = http:\/\/yum.mariadb.org\/5.5.46\/centos6-amd64
\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\ngpgcheck=1<\/p>\n

[root@cluster1 ~]# cat \/etc\/yum.repos.d\/mariadb.repo
\n[mariadb]
\nname = MariaDB
\nbaseurl = http:\/\/yum.mariadb.org\/10.0\/centos6-amd64
\ngpgkey=https:\/\/yum.mariadb.org\/RPM-GPG-KEY-MariaDB
\ngpgcheck=1
\n[root@cluster1 ~]# scp \/etc\/yum.repos.d\/mariadb.repo root@cluster2:\/etc\/yum.repos.d\/
\nmariadb.repo\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 100%\u00a0 138\u00a0\u00a0\u00a0\u00a0 0.1KB\/s\u00a0\u00a0 00:00
\n[root@cluster1 ~]# scp \/etc\/yum.repos.d\/mariadb.repo root@cluster3:\/etc\/yum.repos.d\/
\nmariadb.repo\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 100%\u00a0 138\u00a0\u00a0\u00a0\u00a0 0.1KB\/s\u00a0\u00a0 00:00<\/p><\/div>\n

<\/div>\n
[root@cluster1 ~]# yum install MariaDB-Galera-server MariaDB-client galera -y
\n[root@cluster2 ~]# yum install MariaDB-Galera-server MariaDB-client galera -y
\n[root@cluster3 ~]# yum install MariaDB-Galera-server MariaDB-client galera -y<\/p>\n

[root@cluster1 ~]# service mysql restart
\nERROR! MySQL server PID file could not be found!
\nStarting MySQL….. SUCCESS!<\/p><\/div>\n

<\/div>\n
\/usr\/bin\/mysqladmin -u root password ‘test123’<\/div>\n
<\/div>\n
\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
\nSERVERS IN PRODUCTION USE!\u00a0 PLEASE READ EACH STEP CAREFULLY!<\/div>\n
<\/div>\n
In order to log into MariaDB to secure it, we’ll need the current
\npassword for the root user.\u00a0 If you’ve just installed MariaDB, and
\nyou haven’t set the root password yet, the password will be blank,
\nso you should just press enter here.<\/div>\n
<\/div>\n
Enter current password for root (enter for none):
\nOK, successfully used password, moving on…<\/div>\n
<\/div>\n
Setting the root password ensures that nobody can log into the MariaDB
\nroot user without the proper authorisation.<\/div>\n
<\/div>\n
You already have a root password set, so you can safely answer ‘n’.<\/div>\n
<\/div>\n
Change the root password? [Y\/n] n
\n… skipping.<\/div>\n
<\/div>\n
By default, a MariaDB installation has an anonymous user, allowing anyone
\nto log into MariaDB without having to have a user account created for
\nthem.\u00a0 This is intended only for testing, and to make the installation
\ngo a bit smoother.\u00a0 You should remove them before moving into a
\nproduction environment.<\/div>\n
<\/div>\n
Remove anonymous users? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
Normally, root should only be allowed to connect from ‘localhost’.\u00a0 This
\nensures that someone cannot guess at the root password from the network.<\/div>\n
<\/div>\n
Disallow root login remotely? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
By default, MariaDB comes with a database named ‘test’ that anyone can
\naccess.\u00a0 This is also intended only for testing, and should be removed
\nbefore moving into a production environment.<\/div>\n
<\/div>\n
Remove test database and access to it? [Y\/n] Y
\n– Dropping test database…
\n… Success!
\n– Removing privileges on test database…
\n… Success!<\/div>\n
<\/div>\n
Reloading the privilege tables will ensure that all changes made so far
\nwill take effect immediately.<\/div>\n
<\/div>\n
Reload privilege tables now? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
Cleaning up…<\/div>\n
<\/div>\n
All done!\u00a0 If you’ve completed all of the above steps, your MariaDB
\ninstallation should now be secure.<\/div>\n
<\/div>\n
Thanks for using MariaDB!<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\n[root@cluster2 ~]# service mysql restart
\nERROR! MySQL server PID file could not be found!
\nStarting MySQL….. SUCCESS!<\/div>\n
<\/div>\n
\/usr\/bin\/mysqladmin -u root password ‘test123’<\/div>\n
<\/div>\n
\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
\nSERVERS IN PRODUCTION USE!\u00a0 PLEASE READ EACH STEP CAREFULLY!<\/div>\n
<\/div>\n
In order to log into MariaDB to secure it, we’ll need the current
\npassword for the root user.\u00a0 If you’ve just installed MariaDB, and
\nyou haven’t set the root password yet, the password will be blank,
\nso you should just press enter here.<\/div>\n
<\/div>\n
Enter current password for root (enter for none):
\nOK, successfully used password, moving on…<\/div>\n
<\/div>\n
Setting the root password ensures that nobody can log into the MariaDB
\nroot user without the proper authorisation.<\/div>\n
<\/div>\n
You already have a root password set, so you can safely answer ‘n’.<\/div>\n
<\/div>\n
Change the root password? [Y\/n] n
\n… skipping.<\/div>\n
<\/div>\n
By default, a MariaDB installation has an anonymous user, allowing anyone
\nto log into MariaDB without having to have a user account created for
\nthem.\u00a0 This is intended only for testing, and to make the installation
\ngo a bit smoother.\u00a0 You should remove them before moving into a
\nproduction environment.<\/div>\n
<\/div>\n
Remove anonymous users? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
Normally, root should only be allowed to connect from ‘localhost’.\u00a0 This
\nensures that someone cannot guess at the root password from the network.<\/div>\n
<\/div>\n
Disallow root login remotely? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
By default, MariaDB comes with a database named ‘test’ that anyone can
\naccess.\u00a0 This is also intended only for testing, and should be removed
\nbefore moving into a production environment.<\/div>\n
<\/div>\n
Remove test database and access to it? [Y\/n] Y
\n– Dropping test database…
\n… Success!
\n– Removing privileges on test database…
\n… Success!<\/div>\n
<\/div>\n
Reloading the privilege tables will ensure that all changes made so far
\nwill take effect immediately.<\/div>\n
<\/div>\n
Reload privilege tables now? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
Cleaning up…<\/div>\n
<\/div>\n
All done!\u00a0 If you’ve completed all of the above steps, your MariaDB
\ninstallation should now be secure.<\/div>\n
<\/div>\n
Thanks for using MariaDB!<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
[root@cluster3 ~]# service mysql restart
\nERROR! MySQL server PID file could not be found!
\nStarting MySQL….. SUCCESS!<\/div>\n
<\/div>\n
\/usr\/bin\/mysqladmin -u root password ‘test123’<\/div>\n
<\/div>\n
\nNOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
\nSERVERS IN PRODUCTION USE!\u00a0 PLEASE READ EACH STEP CAREFULLY!<\/div>\n
<\/div>\n
In order to log into MariaDB to secure it, we’ll need the current
\npassword for the root user.\u00a0 If you’ve just installed MariaDB, and
\nyou haven’t set the root password yet, the password will be blank,
\nso you should just press enter here.<\/div>\n
<\/div>\n
Enter current password for root (enter for none):
\nOK, successfully used password, moving on…<\/div>\n
<\/div>\n
Setting the root password ensures that nobody can log into the MariaDB
\nroot user without the proper authorisation.<\/div>\n
<\/div>\n
You already have a root password set, so you can safely answer ‘n’.<\/div>\n
<\/div>\n
Change the root password? [Y\/n] n
\n… skipping.<\/div>\n
<\/div>\n
By default, a MariaDB installation has an anonymous user, allowing anyone
\nto log into MariaDB without having to have a user account created for
\nthem.\u00a0 This is intended only for testing, and to make the installation
\ngo a bit smoother.\u00a0 You should remove them before moving into a
\nproduction environment.<\/div>\n
<\/div>\n
Remove anonymous users? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
Normally, root should only be allowed to connect from ‘localhost’.\u00a0 This
\nensures that someone cannot guess at the root password from the network.<\/div>\n
<\/div>\n
Disallow root login remotely? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
By default, MariaDB comes with a database named ‘test’ that anyone can
\naccess.\u00a0 This is also intended only for testing, and should be removed
\nbefore moving into a production environment.<\/div>\n
<\/div>\n
Remove test database and access to it? [Y\/n] Y
\n– Dropping test database…
\n… Success!
\n– Removing privileges on test database…
\n… Success!<\/div>\n
<\/div>\n
Reloading the privilege tables will ensure that all changes made so far
\nwill take effect immediately.<\/div>\n
<\/div>\n
Reload privilege tables now? [Y\/n] Y
\n… Success!<\/div>\n
<\/div>\n
Cleaning up…<\/div>\n
<\/div>\n
All done!\u00a0 If you’ve completed all of the above steps, your MariaDB
\ninstallation should now be secure.<\/div>\n
<\/div>\n
Thanks for using MariaDB!<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
CLUSTER1<\/div>\n
<\/div>\n
mysql -u root -ptest123 <<< “USE mysql;
\nGRANT ALL PRIVILEGES ON *.* TO ‘cluster’@’%’ IDENTIFIED BY ‘test123’ WITH GRANT OPTION;
\nFLUSH PRIVILEGES;”<\/div>\n
<\/div>\n
mysql -u root -ptest123 <<< “USE mysql;
\nSELECT USER,PASSWORD,HOST FROM user;”<\/div>\n
<\/div>\n
\nCLUSTER2<\/div>\n
<\/div>\n
mysql -u root -ptest123 <<< “USE mysql;
\nGRANT ALL PRIVILEGES ON *.* TO ‘cluster’@’%’ IDENTIFIED BY ‘test123’ WITH GRANT OPTION;
\nFLUSH PRIVILEGES;”<\/div>\n
<\/div>\n
mysql -u root -ptest123 <<< “USE mysql;
\nSELECT USER,PASSWORD,HOST FROM user;”<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
CLUSTER3<\/div>\n
<\/div>\n
mysql -u root -ptest123 <<< “USE mysql;
\nGRANT ALL PRIVILEGES ON *.* TO ‘cluster’@’%’ IDENTIFIED BY ‘test123’ WITH GRANT OPTION;
\nFLUSH PRIVILEGES;”<\/div>\n
<\/div>\n
mysql -u root -ptest123 <<< “USE mysql;
\nSELECT USER,PASSWORD,HOST FROM user;”<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\u00a0modify the configuration of three nodes<\/div>\n
<\/div>\n
####cluster1####
\n[root@cluster1 ~]# sed -ne ‘\/\\[mariadb-10.0\\]\/,\/\/p’ \/etc\/my.cnf.d\/server.cnf
\n[mariadb-10.0]
\nquery_cache_size=0
\nbinlog_format=ROW
\ndefault_storage_engine=innodb
\ninnodb_autoinc_lock_mode=2
\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address=gcomm:\/\/192.168.1.62,192.168.1.63
\nwsrep_cluster_name=’cluster1′
\nwsrep_node_address=’192.168.1.60′
\nwsrep_node_name=’cluster1′
\nwsrep_sst_method=rsync
\nwsrep_sst_auth=root:password
\n[root@cluster1 my.cnf.d]# ls
\nmysql-clients.cnf\u00a0 server.cnf\u00a0 tokudb.cnf
\n[root@cluster1 my.cnf.d]# cat^C
\n[root@cluster1 my.cnf.d]# \/etc\/init.d\/mysql bootstrap
\nBootstrapping the cluster.. Starting MySQL…. SUCCESS!<\/div>\n
<\/div>\n
\n####cluster2####
\n[root@cluster2 ~]# sed -ne ‘\/\\[mariadb-10.0\\]\/,\/\/p’ \/etc\/my.cnf.d\/server.cnf
\n[mariadb-10.0]
\nquery_cache_size=0
\nbinlog_format=ROW
\ndefault_storage_engine=innodb
\ninnodb_autoinc_lock_mode=2
\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address=gcomm:\/\/192.168.1.60,192.168.1.63
\nwsrep_cluster_name=’cluster1′
\nwsrep_node_address=’192.168.1.62′
\nwsrep_node_name=’cluster2′
\nwsrep_sst_method=rsync
\nwsrep_sst_auth=root:password<\/div>\n
<\/div>\n
\n####cluster3####
\n[root@cluster3\u00a0 ~]# sed -ne ‘\/\\[mariadb-10.0\\]\/,\/\/p’ \/etc\/my.cnf.d\/server.cnf
\n[mariadb-10.0]
\nquery_cache_size=0
\nbinlog_format=ROW
\ndefault_storage_engine=innodb
\ninnodb_autoinc_lock_mode=2
\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address=gcomm:\/\/192.168.1.60,192.168.1.62
\nwsrep_cluster_name=’cluster1′
\nwsrep_node_address=’192.168.1.63′
\nwsrep_node_name=’cluster3′
\nwsrep_sst_method=rsync
\nwsrep_sst_auth=root:password<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
[root@cluster1 my.cnf.d]# mysql -u root -p
\nEnter password:
\nWelcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.
\nYour MariaDB connection id is 4
\nServer version: 5.5.46-MariaDB-wsrep MariaDB Server, wsrep_25.12.r4f81026<\/div>\n
<\/div>\n
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.<\/div>\n
<\/div>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/div>\n
<\/div>\n
MariaDB [(none)]> create database mohan;
\nQuery OK, 1 row affected (0.02 sec)<\/div>\n
<\/div>\n
MariaDB [(none)]> show databases;
\n+——————–+
\n| Database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————–+
\n| information_schema |
\n| mohan\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| mysql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| performance_schema |
\n| test\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————–+
\n5 rows in set (0.00 sec)<\/div>\n
<\/div>\n
MariaDB [(none)]> drop databases test;
\nERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘databases test’ at line 1
\nMariaDB [(none)]> drop database test;
\nQuery OK, 0 rows affected (0.01 sec)<\/div>\n
<\/div>\n
MariaDB [(none)]><\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
\nroot@cluster2 my.cnf.d]# mysql -u root -p
\nEnter password:
\nWelcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.
\nYour MariaDB connection id is 4
\nServer version: 5.5.46-MariaDB-wsrep MariaDB Server, wsrep_25.12.r4f81026<\/div>\n
<\/div>\n
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.<\/div>\n
<\/div>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/div>\n
<\/div>\n
MariaDB [(none)]> show databases;
\n+——————–+
\n| Database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————–+
\n| information_schema |
\n| mohan\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| mysql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| performance_schema |
\n| test\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————–+
\n5 rows in set (0.00 sec)<\/div>\n
<\/div>\n
MariaDB [(none)]> show databases;
\n+——————–+
\n| Database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————–+
\n| information_schema |
\n| mohan\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| mysql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| performance_schema |
\n+——————–+
\n4 rows in set (0.00 sec)<\/div>\n
<\/div>\n
MariaDB [(none)]> quit
\nBye<\/div>\n
<\/div>\n
<\/div>\n
<\/div>\n
[root@cluster3 my.cnf.d]# mysql -u root -p
\nEnter password:
\nWelcome to the MariaDB monitor.\u00a0 Commands end with ; or \\g.
\nYour MariaDB connection id is 4
\nServer version: 5.5.46-MariaDB-wsrep MariaDB Server, wsrep_25.12.r4f81026<\/div>\n
<\/div>\n
Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.<\/div>\n
<\/div>\n
Type ‘help;’ or ‘\\h’ for help. Type ‘\\c’ to clear the current input statement.<\/div>\n
<\/div>\n
MariaDB [(none)]> show databases;
\n+——————–+
\n| Database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————–+
\n| information_schema |
\n| mohan\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| mysql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| performance_schema |
\n| test\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————–+
\n5 rows in set (0.00 sec)<\/div>\n
<\/div>\n
MariaDB [(none)]> show databases;
\n+——————–+
\n| Database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n+——————–+
\n| information_schema |
\n| mohan\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| mysql\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |
\n| performance_schema |
\n+——————–+
\n4 rows in set (0.00 sec)<\/div>\n
<\/div>\n
MariaDB [(none)]> quit
\nBye<\/div>\n","protected":false},"excerpt":{"rendered":"

Yum to configure multiple master cluster MariaDB Galera Hereinafter, if the command is not preceded by PS1 is to represent the three nodes are required to perform the same action, if it means the implementation of the action on the specified node<\/p>\n

cluster1.rmohan.com Centos6.7 192.168.1.60 MariaDB cluster2.rmohan.com Centos6.7 192.168.1.62 MariaDB cluster3.rmohan.com Centos6.7 192.168.1.63 MariaDB<\/p>\n

[…]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[72,16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5377"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5377"}],"version-history":[{"count":1,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5377\/revisions"}],"predecessor-version":[{"id":5378,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/5377\/revisions\/5378"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}