MariaDB Replikation (Ubuntu): Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
| Zeile 23: | Zeile 23: | ||
<pre> | <pre> | ||
sudo systemctl restart mariadb | sudo systemctl restart mariadb | ||
</pre> | |||
<pre> | |||
CREATE USER 'master'@'%' IDENTIFIED BY '<password>'; | |||
GRANT REPLICATION SLAVE ON *.* TO 'master'@'%'; | |||
FLUSH PRIVILEGES; | |||
SHOW MASTER STATUS; | |||
</pre> | </pre> | ||
Version vom 5. Februar 2020, 23:29 Uhr
Noch in Bearbeitung
Server A
Die Datei /etc/mysql/mariadb.conf.d/50-server.cnf editieren
sudo vi /etc/mysql/mariadb.conf.d/50-server.cnf
und folgende Zeilen hinzufügen/anpassen:
log-bin /var/log/mysql/mysql-bin.log server_id=1 replicate-do-db=replicate bind-address=10.0.0.157
Danach den Server neu starten:
sudo systemctl restart mariadb
CREATE USER 'master'@'%' IDENTIFIED BY '<password>'; GRANT REPLICATION SLAVE ON *.* TO 'master'@'%'; FLUSH PRIVILEGES; SHOW MASTER STATUS;
Server B
Links
Zurück zu MariaDB