Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titleMySQL Commands for Replication Initialisation
# Auf den jeweiligen Master (auch bei Master-Master)
mysql> SHOW MASTER STATUS\G

# Auf den Slave
# Hier <acd-dbm> sowie <Name Logfile> und <Position LogFile> anpassen:
mysql> CHANGE MASTER TO MASTER_HOST='<acd-dbm>',MASTER_USER='repl',MASTER_PASSWORD='<passwort>',MASTER_LOG_FILE='<Name LogFile>', MASTER_LOG_POS=<Position LogFile>;

# Slave starten
mysql> START SLAVE;


# Status prüfen
mysql> SHOW SLAVE STATUS\G

...