{"id":80,"date":"2017-12-20T20:07:18","date_gmt":"2017-12-20T20:07:18","guid":{"rendered":"http:\/\/www.linuxauthority.com\/wordpress\/?p=80"},"modified":"2018-02-01T01:08:30","modified_gmt":"2018-02-01T01:08:30","slug":"maria-dbmysql-two-node-installation-with-galera-data-replication","status":"publish","type":"post","link":"https:\/\/www.linuxauthority.com\/wordpress\/?p=80","title":{"rendered":"Maria-db(mysql) two node installation with galera data replication"},"content":{"rendered":"\n\n

This is the first step toward unsupported installation of the NDC, New Data Cloud. To get the commercial version with full support, click here<\/a>.<\/p>\n

This document takes you through the installation and creation of a two node database installation. This install was done in google compute engine but with the right band width will work between data centers. It is an Enterprise class solution that has absolutely no license fees whatsoever. This document is provided without support or warranty.<\/p>\n

The base configuration:<\/p>\n

2 nodes 1 VCPU 3.7 GB running CentOS 7. This does not use the Maria-db that ships with CentOS 7, which is the free version of Red Hat Enterprise Linux.<\/p>\n

instance-4 is primary node<\/p>\n

instance-5 is failover node (replication target)
\n<\/a><\/p>\n

Install Mariadb repos.<\/a>\u00a0Cut and paste the repo text from the mariadb site.<\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

This procedure is for version 10.1 (stable). Execute on both nodes.<\/p>\n

cd \/etc\/my.cnf.d<\/p>\n

modify server.cnf<\/p>\n

\"server.cnf.active\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

#<\/p>\n

# These groups are read by MariaDB server.
\n# Use it for options that only the server (but not clients) should see
\n#
\n# See the examples of server my.cnf files in \/usr\/share\/mysql\/
\n#<\/p>\n

# this is read by the standalone daemon and embedded servers
\n[server]<\/p>\n

# this is only for the mysqld standalone daemon
\n[mysqld]
\nlog_error=\/var\/log\/mariadb.log<\/p>\n

#
\n# * Galera-related settings
\n#
\n[galera]
\n# Mandatory settings
\nbinlog_format=ROW<\/span>
\n default-storage-engine=innodb<\/span>
\n innodb_autoinc_lock_mode=2<\/span>
\n bind-address=0.0.0.0<\/span>
\n wsrep_on=ON<\/span>
\n wsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so<\/span>
\n wsrep_cluster_address=”gcomm:\/\/10.240.0.2,10.240.0.3″<\/span><\/p>\n

## Galera Cluster Configuration
\nwsrep_cluster_name=’cluster1′<\/span>
\n## Galera Synchronization Configuration
\nwsrep_sst_method=rsync<\/span>
\n## Galera Node Configuration
\nwsrep_node_address=’10.240.0.2′<\/span>
\n wsrep_node_name=’instance-4′<\/span>
\n# this is only for embedded server
\n[embedded]<\/p>\n

# This group is only read by MariaDB servers, not by MySQL.
\n# If you use the same .cnf file for MySQL and MariaDB,
\n# you can put MariaDB-only options here
\n[mariadb]<\/p>\n

# This group is only read by MariaDB-10.1 servers.
\n# If you use the same .cnf file for MariaDB of different versions,
\n# use this group for options that older servers don’t understand
\n[mariadb-10.1]<\/p>\n

On failover node edit the same file<\/p>\n

\"instance-5.servercnf\"<\/a><\/p>\n

 <\/p>\n

#<\/p>\n

# These groups are read by MariaDB server.
\n# Use it for options that only the server (but not clients) should see
\n#
\n# See the examples of server my.cnf files in \/usr\/share\/mysql\/
\n#<\/p>\n

# this is read by the standalone daemon and embedded servers
\n[server]<\/p>\n

# this is only for the mysqld standalone daemon
\n[mysqld]<\/p>\n

#
\n# * Galera-related settings
\n#<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

[galera]
\n# Mandatory settings
\nwsrep_on=ON
\n#wsrep_provider=
\n#wsrep_cluster_address=
\n#binlog_format=row
\n#default_storage_engine=InnoDB
\n#innodb_autoinc_lock_mode=2
\n#
\n# Allow server to accept connections on all interfaces.
\n#
\n#bind-address=0.0.0.0
\n#
\n# Optional setting
\n#wsrep_slave_threads=1
\n#innodb_flush_log_at_trx_commit=0
\nbinlog_format=ROW
\ndefault-storage-engine=innodb
\ninnodb_autoinc_lock_mode=2
\ninnodb_locks_unsafe_for_binlog=1
\nquery_cache_size=0
\nquery_cache_type=0
\nbind-address=0.0.0.0
\ndatadir=\/var\/lib\/mysql
\ninnodb_log_file_size=100M
\ninnodb_file_per_table
\ninnodb_flush_log_at_trx_commit=2
\nwsrep_provider=\/usr\/lib64\/galera\/libgalera_smm.so
\nwsrep_cluster_address=”gcomm:\/\/10.240.0.2,10.240.0.3″
\nwsrep_cluster_name=’galera_cluster’
\nwsrep_node_address=’10.240.0.3′
\nwsrep_node_name=’db2′
\nwsrep_sst_method=rsync
\nwsrep_sst_auth=sst_user:SarBit@2010
\n#wsrep_on=ON
\n# this is only for embedded server
\n[embedded]<\/p>\n

# This group is only read by MariaDB servers, not by MySQL.
\n# If you use the same .cnf file for MySQL and MariaDB,
\n# you can put MariaDB-only options here
\n[mariadb]<\/p>\n

# This group is only read by MariaDB-10.1 servers.
\n# If you use the same .cnf file for MariaDB of different versions,
\n# use this group for options that older servers don’t understand
\n[mariadb-10.1]<\/p>\n

On active node:<\/p>\n

galera_new_cluster<\/p>\n

echo $?<\/p>\n

0<\/p>\n

## Zero return code indicates successful new cluster starrt<\/p>\n

systemctl status mariadb.service<\/p>\n

\"activenode.status\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

On passive or replication node:<\/p>\n

systemctl start mariadb.service<\/p>\n

systemctl status mariadb.service<\/p>\n

\"passive.node.status\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Check the logs:<\/p>\n

tail -f \/var\/log\/mariadb.log<\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

To check galleria cluster status see this page.<\/a><\/p>\n

You have an\u00a0 Enterprise class active-passive database cluster.<\/p>\n

You paid Oracle $0.<\/p>\n","protected":false},"excerpt":{"rendered":"

This is the first step toward unsupported installation of the NDC, New Data Cloud. To get the commercial version with full support, click here. This document takes you through the installation and creation of a two node database installation. This install was done in google compute engine but with the right band width will work […]<\/p>\nRead More →<\/a>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10,9,21,11],"tags":[],"class_list":["post-80","post","type-post","status-publish","format-standard","hentry","category-clustering-2","category-scripting-2","category-systems-administration","category-yum"],"_links":{"self":[{"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/80"}],"collection":[{"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=80"}],"version-history":[{"count":12,"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions"}],"predecessor-version":[{"id":118,"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions\/118"}],"wp:attachment":[{"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.linuxauthority.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}