Vorbereitung

Installieren Sie eine geünschte Anzahl an Linux Debian Server, welche Sie später als Cluster Nodes verwenden möchten. In unserem Fall verwenden wir drei Nodes.
Konfigurieren Sie statische IP-Adressen für die einzelen Server und tragen Sie diese in der lokalen Hosts Datei ein:

31.42.183.71           vdbs01.4b42.net vdbs01
31.42.183.72           vdbs02.4b42.net vdbs02
31.42.183.73           vdbs03.4b42.net vdbs03

Installation

Installieren Sie nun den Datenbank-Server MariaDB Server auf allen Nodes:

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
The following additional packages will be installed:
  galera-4 libcgi-fast-perl libcgi-pm-perl libclone-perl libconfig-inifiles-perl libdaxctl1 libdbd-mariadb-perl libdbi-perl libencode-locale-perl libfcgi-bin
  libfcgi-perl libfcgi0ldbl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
  liblwp-mediatypes-perl liblzo2-2 libmariadb3 libncurses6 libndctl6 libnuma1 libpmem1 libregexp-ipv6-perl libsnappy1v5 libterm-readkey-perl libtimedate-perl
  liburi-perl liburing2 lsof mariadb-client mariadb-client-core mariadb-common mariadb-plugin-provider-bzip2 mariadb-plugin-provider-lz4
  mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo mariadb-plugin-provider-snappy mariadb-server-core mysql-common pv rsync socat
Suggested packages:
  libmldbm-perl libnet-daemon-perl libsql-statement-perl libdata-dump-perl libipc-sharedcache-perl libbusiness-isbn-perl libwww-perl mailx mariadb-test
  netcat-openbsd doc-base python3-braceexpand
The following NEW packages will be installed:
  galera-4 libcgi-fast-perl libcgi-pm-perl libclone-perl libconfig-inifiles-perl libdaxctl1 libdbd-mariadb-perl libdbi-perl libencode-locale-perl libfcgi-bin
  libfcgi-perl libfcgi0ldbl libhtml-parser-perl libhtml-tagset-perl libhtml-template-perl libhttp-date-perl libhttp-message-perl libio-html-perl
  liblwp-mediatypes-perl liblzo2-2 libmariadb3 libncurses6 libndctl6 libnuma1 libpmem1 libregexp-ipv6-perl libsnappy1v5 libterm-readkey-perl libtimedate-perl
  liburi-perl liburing2 lsof mariadb-client mariadb-client-core mariadb-common mariadb-plugin-provider-bzip2 mariadb-plugin-provider-lz4
  mariadb-plugin-provider-lzma mariadb-plugin-provider-lzo mariadb-plugin-provider-snappy mariadb-server mariadb-server-core mysql-common pv rsync socat
0 upgraded, 46 newly installed, 0 to remove and 0 not upgraded.
Need to get 19.1 MB of archives.
After this operation, 193 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://ftp.debian.org/debian bookworm/main amd64 mysql-common all 5.8+1.1.0 [6,636 B]
Get:2 http://ftp.debian.org/debian bookworm/main amd64 mariadb-common all 1:10.11.4-1~deb12u1 [24.2 kB]
Get:3 http://ftp.debian.org/debian bookworm/main amd64 galera-4 amd64 26.4.13-1 [825 kB]
Get:4 http://ftp.debian.org/debian bookworm/main amd64 libdbi-perl amd64 1.643-4 [773 kB]
Get:5 http://ftp.debian.org/debian bookworm/main amd64 lsof amd64 4.95.0-1 [318 kB]
Get:6 http://ftp.debian.org/debian bookworm/main amd64 libconfig-inifiles-perl all 3.000003-2 [45.9 kB]
Get:7 http://ftp.debian.org/debian bookworm/main amd64 libmariadb3 amd64 1:10.11.4-1~deb12u1 [172 kB]
Setting up liblzo2-2:amd64 (2.10-2) ...
Setting up libencode-locale-perl (1.05-3) ...
Setting up libsnappy1v5:amd64 (1.1.9-3) ...
Setting up socat (1.7.4.4-2) ...
Setting up libncurses6:amd64 (6.4-4) ...
Setting up libio-html-perl (1.004-3) ...
Setting up libmariadb3:amd64 (1:10.11.4-1~deb12u1) ...
Setting up libdaxctl1:amd64 (76.1-1) ...
Setting up lsof (4.95.0-1) ...
Setting up libtimedate-perl (2.3300-2) ...
Setting up libregexp-ipv6-perl (0.03-3) ...
Setting up libnuma1:amd64 (2.0.16-1) ...
Setting up pv (1.6.20-1) ...
Setting up libndctl6:amd64 (76.1-1) ...
Setting up libfcgi-perl (0.82+ds-2) ...
Setting up libterm-readkey-perl (2.38-2+b1) ...
Setting up liburing2:amd64 (2.3-3) ...
Setting up libpmem1:amd64 (1.12.1-2) ...
Setting up liburi-perl (5.17-1) ...
Setting up libdbi-perl:amd64 (1.643-4) ...
Setting up rsync (3.2.7-1) ...
rsync.service is a disabled or a static unit not running, not starting it.
Setting up libhttp-date-perl (6.05-2) ...
Setting up mariadb-client-core (1:10.11.4-1~deb12u1) ...
Setting up libdbd-mariadb-perl (1.22-1+b1) ...
Setting up libhtml-parser-perl:amd64 (3.81-1) ...
Setting up mariadb-server-core (1:10.11.4-1~deb12u1) ...
Setting up libhttp-message-perl (6.44-1) ...
Setting up mariadb-client (1:10.11.4-1~deb12u1) ...
Setting up libcgi-pm-perl (4.55-1) ...
Setting up libhtml-template-perl (2.97-2) ...
Setting up mariadb-server (1:10.11.4-1~deb12u1) ...
Created symlink /etc/systemd/system/multi-user.target.wants/mariadb.service → /lib/systemd/system/mariadb.service.
Setting up mariadb-plugin-provider-bzip2 (1:10.11.4-1~deb12u1) ...
Setting up mariadb-plugin-provider-lzma (1:10.11.4-1~deb12u1) ...
Setting up mariadb-plugin-provider-lzo (1:10.11.4-1~deb12u1) ...
Setting up mariadb-plugin-provider-lz4 (1:10.11.4-1~deb12u1) ...
Setting up libcgi-fast-perl (1:2.15-1) ...
Setting up mariadb-plugin-provider-snappy (1:10.11.4-1~deb12u1) ...
Processing triggers for libc-bin (2.36-9+deb12u3) ...
Processing triggers for mariadb-server (1:10.11.4-1~deb12u1) ...

Konfiguration