|
Size: 1269
Comment:
|
Size: 462
Comment:
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 1: | Line 1: |
| incomplete, do not use! |
|
| Line 5: | Line 3: |
| What we really want to set up is a galera cluster. We will use 3 systems for this | Mariadb is a relational database. Configured as a Galera cluster it can run as a distributed sql server that automatically replicates data between servers. |
| Line 7: | Line 5: |
| We will configure 3 mariadb servers in a Galera cluster. | |
| Line 8: | Line 7: |
| * 192.168.1.55 mariadb01 * 192.168.1.56 mariadb02 * 192.168.1.57 mariadb03 == Software == {{{ apt-get install mariadb-server rsync }}} == Configuration == 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 # Custom settings 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/ |
Configure the [[Mariadb Server|servers]] then continue by adding [[Mariadb Encryption|replication encryption]] between servers in the cluster and finalize by adding [[Mariadb Client-Server Encryption|client/server encyption]]. |
Mariadb
Mariadb is a relational database. Configured as a Galera cluster it can run as a distributed sql server that automatically replicates data between servers.
We will configure 3 mariadb servers in a Galera cluster.
Configure the servers then continue by adding replication encryption between servers in the cluster and finalize by adding client/server encyption.