MySQL database replication
From WormBaseWiki
Jump to navigationJump to search
Description
We use mysql replication to mirror mysql databases from a single master mysqld server to a series of slave servers on back end nodes. This process is asynchronous and asymmetrical - back end nodes are read-only.
Configuration
Two options must be set to enable replication. First, binary logging must be enabled. Second, every mysqld server in the pool needs a unique ID.
These parameters should be set in the my.cnf file (/etc/my.cnf on WormBase servers).
[mysqld] log-bin=mysql-bin server-id=1
See WormBase_Infrastructure and Hardware catalog for server IDs.