MySQL database replication

From WormBaseWiki
Revision as of 18:50, 17 May 2008 by Tharris (talk | contribs) (New page: = 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 asym...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.