{"id":6744,"date":"2017-06-03T17:29:42","date_gmt":"2017-06-03T09:29:42","guid":{"rendered":"http:\/\/rmohan.com\/?p=6744"},"modified":"2017-06-03T17:30:18","modified_gmt":"2017-06-03T09:30:18","slug":"6744","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=6744","title":{"rendered":"MariaDB Galera Cluster deployment"},"content":{"rendered":"

MariaDB Galera Cluster deployment (how quickly deploy MariaDB cluster)<\/strong><\/p>\n

MariaDB is a branch of Mysql, has been widely used in open source projects, such as hot openstack, therefore, in order to ensure high availability of services, while increasing the load capacity of the system, clustered deployment is essential. <\/p>\n

MariaDB Galera Cluster Introduction<\/p>\n

MariaDB MariaDB cluster is synchronous multi-master cluster. It only supports XtraDB \/ InnoDB storage engine (although experimental support for MyISAM – see wsrep_replicate_myisam system variable).<\/p>\n

The main function:<\/p>\n

Replication
\nTrue multi-master, that is, all nodes can read and write the database at the same time
\nAutomatic control node members, the failed node is automatically cleared
\nThe new node joins the data is automatically copied
\nTrue parallel copy, row-level
\nUsers can directly connect to the cluster, use exactly the same experience with MySQL
\nAdvantage:<\/p>\n

Because it is multi-master, Slavelag so there is no (delayed)
\nThere is no case of lost transactions
\nBut also has the ability to read and write extended
\nSmaller client latencies
\nData synchronization between nodes, and the Master \/ Slave mode is asynchronous, the binlog on different slave may be different
\ntechnology:<\/p>\n

Galera Cluster replication based Galeralibrary achieve, in order to allow MySQL and Galera library communications, developed specifically for MySQL wsrep API.<\/p>\n

Galera Cluster Synchronization Plug-assurance data, maintaining data consistency, can rely on certified copy, it works in the following figure:<\/p>\n

\"\"<\/a><\/p>\n

When the client sends a commit command, before the transaction is committed, all changes to the database are collected write-set up, and sends the contents of write-set record to other nodes.<\/p>\n

write-set will be certification testing at each node, the node test results determine whether to apply the write-set change data.<\/p>\n

If the authentication test fails, the node will discard the write-set; if the certification test is successful, the transaction commits. <\/p>\n

1. Installation Environment Preparation<\/p>\n

Install MariaDB cluster requires at least 3 servers (if only two words requires special configuration, please refer to the official documentation)<\/p>\n

Here, I list the configuration of the test machine:<\/p>\n

Operating system version: CentOS 7<\/p>\n

node4: 192.168.1.16 Node5: 192.168.1.17 Node6: 192.168.1.18<\/p>\n

The first line as an example, node4 for the hostname, 192.168.1.16 for the ip, the three machines to modify \/ etc \/ hosts file, my file as follows:
\n192.168.1.16 Node4
\n192.168.1.17 Node5
\n192.168.1.18 Node6<\/p>\n

In order to ensure mutual communication between nodes, need to disable the firewall settings (if you need a firewall, refer to the official website to increase the firewall settings)<\/p>\n

Execute commands three nodes are:
\nsystemctl STOP firewalld<\/p>\n

Then the \/ etc \/ sysconfig \/ selinux selinux is set to disabled, so that the initialization is complete environment. <\/p>\n

2. Install the Cluster Galera MariaDB
\n[Node4 the root @ ~] # yum the install -Y-MariaDB MariaDB MariaDB Galera-Server-Common-Galera Galera the rsync<\/p>\n

[root@node5 ~]# yum install -y mariadb mariadb-galera-server mariadb-galera-common galera rsync<\/p>\n

[root@node6 ~]# yum install -y mariadb mariadb-galera-server mariadb-galera-common galera rsync<\/p>\n

3. MariaDB Galera Cluster<\/p>\n

Initialize the database service, only one node<\/p>\n

[root@node4 mariadb]# systemctl start mariadb
\n[root@node4 mariadb]# mysql_secure_installation<\/p>\n

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
\n SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!<\/p>\n

In order to log into MariaDB to secure it, we’ll need the current
\npassword for the root user. 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.<\/p>\n

Enter current password for root (enter for none):
\nOK, successfully used password, moving on…<\/p>\n

Setting the root password ensures that nobody can log into the MariaDB
\nroot user without the proper authorisation.<\/p>\n

Set root password? [Y\/n]
\nNew password:
\nRe-enter new password:
\nPassword updated successfully!
\nReloading privilege tables..
\n … Success!<\/p>\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. This is intended only for testing, and to make the installation
\ngo a bit smoother. You should remove them before moving into a
\nproduction environment.<\/p>\n

Remove anonymous users? [Y\/n] n
\n … skipping.<\/p>\n

Normally, root should only be allowed to connect from ‘localhost’. This
\nensures that someone cannot guess at the root password from the network.<\/p>\n

Disallow root login remotely? [Y\/n] y
\n … Success!<\/p>\n

By default, MariaDB comes with a database named ‘test’ that anyone can
\naccess. This is also intended only for testing, and should be removed
\nbefore moving into a production environment.<\/p>\n

Remove test database and access to it? [Y\/n] n
\n … skipping.<\/p>\n

Reloading the privilege tables will ensure that all changes made so far
\nwill take effect immediately.<\/p>\n

Reload privilege tables now? [Y\/n] y
\n … Success!<\/p>\n

Cleaning up…<\/p>\n

All done! If you’ve completed all of the above steps, your MariaDB
\ninstallation should now be secure.<\/p>\n

Thanks for using MariaDB!<\/p>\n

\"\"<\/a><\/p>\n

\/etc\/my.cnf.d\/galera.cnf
\n[root@node4 mariadb]# systemctl stop mariadb
\n[root@node4 ~]# vim \/etc\/my.cnf.d\/galera.cnf<\/p>\n

[mysqld]
\n……
\nwsrep_provider = \/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address = “gcomm:\/\/node4,node5,node6″
\nwsrep_node_name = node4
\nwsrep_node_address=192.168.1.16
\n#wsrep_provider_options=”socket.ssl_key=\/etc\/pki\/galera\/galera.key; socket.ssl_cert=\/etc\/pki\/galera\/galera.crt;”<\/p>\n

Tip: If you do not have a way ssl certification, please put wsrep_provider_options commented.<\/p>\n

Copy this file to node5, node6, attention should wsrep_node_name and wsrep_node_address into the corresponding node hostname and ip. <\/p>\n

4. Start MariaDB Galera Cluster Service
\n[root @ node4 ~] # \/ usr \/ libexec \/ mysqld –wsrep-new-cluster –user = root &<\/p>\n

?????
\n[root@node4 ~]# tail -f \/var\/log\/mariadb\/mariadb.log<\/p>\n

150701 19:54:17 [Note] WSREP: wsrep_load(): loading provider library ‘none’
\n150701 19:54:17 [Note] \/usr\/libexec\/mysqld: ready for connections.
\nVersion: ‘5.5.40-MariaDB-wsrep’ socket: ‘\/var\/lib\/mysql\/mysql.sock’ port: 3306 MariaDB Server, wsrep_25.11.r4026<\/p>\n

Ready for connections appear to prove that we started successfully, continue to start another node:
\n[root @ Node5 ~] # systemctl Start MariaDB
\n[root @ Node6 ~] # systemctl Start MariaDB<\/p>\n

You can view \/var\/log\/mariadb\/mariadb.log, the log can see the nodes are added to the cluster.<\/p>\n

Warning ?: – wsrep-new-cluster This cluster initialization parameters can only be used, and can only be used in a node. <\/p>\n

5. Check the cluster status<\/p>\n

We can focus on a few key parameters:<\/p>\n

wsrep_connected = on the link is on<\/p>\n

wsrep_local_index = 1 the cluster index value<\/p>\n

wsrep_cluster_size = the number of nodes in the cluster 3<\/p>\n

wsrep_incoming_addresses = 192.168.1.17:3306,192.168.1.16:3306,192.168.1.18:3306 access nodes in the cluster address <\/p>\n

6. verification data synchronization<\/p>\n

Our new database on node4 galera_test, then a query on node5 and node6, if you can check galera_test library, a data synchronization is successful, the cluster is operating normally.<\/p>\n

[root@node4 ~]# mysql -uroot -p root -e “create database galera_test”<\/p>\n

[root@node5 ~]# mysql -uroot -p root -e “show databases”
\n+——————–+
\n| Database |
\n+——————–+
\n| information_schema |
\n| galera_test |
\n| mysql |
\n| performance_schema |
\n+——————–+<\/p>\n

[root@node6 ~]# mysql -uroot -p root -e “show databases”
\n+——————–+
\n| Database |
\n+——————–+
\n| information_schema |
\n| galera_test |
\n| mysql |
\n| performance_schema |
\n+——————–+<\/p>\n

At this point, our MariaDB Galera Cluster has been successfully deployed.<\/p>\n

————————————–Dividing line———- —————————-<\/p>\n","protected":false},"excerpt":{"rendered":"

MariaDB Galera Cluster deployment (how quickly deploy MariaDB cluster)<\/p>\n

MariaDB is a branch of Mysql, has been widely used in open source projects, such as hot openstack, therefore, in order to ensure high availability of services, while increasing the load capacity of the system, clustered deployment is essential. <\/p>\n

MariaDB Galera Cluster Introduction<\/p>\n

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