Mariadb

What we really want to set up is a galera cluster. We will use 3 systems for this

servers then continue by adding encryption.

192.168.1.55 mariadb01
192.168.1.56 mariadb02
192.168.1.57 mariadb03

Software

apt-get install mariadb-server rsync

Configuration

Set the mariadb root password.

mysql_secure_installation

Stop mariadb on all nodes.

service mariadb stop

Add the configuration for galera to /etc/mysql/conf.d/galera.cnf. Replace names so they fit the current node.

[galera]
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://mariadb01,mariadb02,mariadb03
wsrep_node_address=mariadb01
wsrep_node_name=mariadb01.kallenberg.dk
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_cluster_name="mariadb_galera" 
wsrep_sst_method=rsync
bind-address=0.0.0.0

On the first node the cluster is started.

galera_new_cluster

On additional nodes the service is started.

service mariadb start

-  ⇤ ← Revision 3 as of 2018-01-20 17:06:00 → 
  Size: 266
  Editor: Kristian Kallenberg
  Comment:
+   ← Revision 15 as of 2018-01-20 22:01:48 → ⇥
  Size: 1479
  Editor: Kristian Kallenberg
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 1:
+incomplete, do not use!
-Line 6:
+Line 8:
- * 192.168.1.45 mariadb01
 * 192.168.1.45 mariadb02
 * 192.168.1.45 mariadb03
+[[Mariadb Server|servers]] then continue by adding [[Mariadb Encryption|encryption]].

 * 192.168.1.55 mariadb01
 * 192.168.1.56 mariadb02
 * 192.168.1.57 mariadb03
-Line 12:
+Line 16:
-apt-get install mariadb-server
+apt-get install mariadb-server rsync
-Line 16:
+Line 20:
+Set the mariadb root password.
{{{
mysql_secure_installation
}}}

Stop mariadb on all nodes.
{{{
service mariadb stop
}}}

Add the configuration for galera to `/etc/mysql/conf.d/galera.cnf`. Replace names so they fit the current node.
{{{
[galera]
wsrep_on=ON
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address=gcomm://mariadb01,mariadb02,mariadb03
wsrep_node_address=mariadb01
wsrep_node_name=mariadb01.kallenberg.dk
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_cluster_name="mariadb_galera" 
wsrep_sst_method=rsync
bind-address=0.0.0.0
}}}

On the first node the cluster is started.
{{{
galera_new_cluster
}}}

On additional nodes the service is started.
{{{
service mariadb start
}}}

== References ==
 * https://blog.cloudandheat.com/index.php/en/2016/09/09/tutorial-simple-mariadb-galera-cluster-with-haproxy-load-balancing/
 * https://linode.com/docs/databases/mariadb/set-up-mariadb-clusters-with-galera-debian-and-ubuntu/
 * http://galeracluster.com/documentation-webpages/sslcert.html