Difference between revisions of "MySQL database replication"
From WormBaseWiki
Jump to navigationJump to search (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...) |
|||
Line 1: | Line 1: | ||
− | = Description = | + | __TOC__ |
+ | |||
+ | = 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. | 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 = | + | = 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. | 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). | These parameters should be set in the my.cnf file (/etc/my.cnf on WormBase servers). | ||
+ | |||
<pre>[mysqld] | <pre>[mysqld] | ||
log-bin=mysql-bin | log-bin=mysql-bin | ||
server-id=1 | server-id=1 | ||
</pre> | </pre> | ||
+ | |||
''See [[WormBase Infrastructure|WormBase_Infrastructure]] and [[Hardware catalog|Hardware catalog]] for server IDs.'' | ''See [[WormBase Infrastructure|WormBase_Infrastructure]] and [[Hardware catalog|Hardware catalog]] for server IDs.'' | ||
+ | |||
+ | <code>brie3</code> (the primary WormBase development machine) acts as the master server, with <code>server-id = 1</code>. |
Revision as of 18:52, 17 May 2008
Contents
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.
brie3
(the primary WormBase development machine) acts as the master server, with server-id = 1
.