Differences between revisions 8 and 23 (spanning 15 versions)
Revision 8 as of 2018-01-20 18:41:03
Size: 546
Comment:
Revision 23 as of 2020-02-03 17:08:57
Size: 463
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 ==

== 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 encryption]].

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 encryption.

None: Mariadb (last edited 2020-02-03 17:13:54 by Kristian Kallenberg)