powerdns_master-slave_replication_with_mysql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
powerdns_master-slave_replication_with_mysql [2015/04/10 18:26] – [Client verification] admin | powerdns_master-slave_replication_with_mysql [2015/04/10 18:31] – [Slave configuration] admin | ||
---|---|---|---|
Line 83: | Line 83: | ||
* Create backup on **master**:< | * Create backup on **master**:< | ||
* Copy the dump to the ** slave**. | * Copy the dump to the ** slave**. | ||
+ | |||
+ | ====Slave configuration==== | ||
+ | * Edit /etc/my.cnf on the **slave**:< | ||
+ | log_bin = mysql-bin | ||
+ | server_id = 20 | ||
+ | log_slave_updates = 1 | ||
+ | relay_log = mysql-relay-bin | ||
+ | read_only = 1</ | ||
+ | |||
+ | ====Enable replication==== | ||
+ | * Import the backup on the **slave**:< | ||
+ | * Configure replication:< | ||
+ | Master_Host=' | ||
+ | Master_User=' | ||
+ | Master_Password=' | ||
+ | Master_SSL=1, | ||
+ | Master_SSL_CA = '/ | ||
+ | Master_SSL_CERT = '/ | ||
+ | Master_SSL_KEY = '/ | ||
+ | Master_SSL_Verify_Server_Cert = 1; | ||
+ | Query OK, 0 rows affected (0.08 sec)</ |
powerdns_master-slave_replication_with_mysql.txt · Last modified: 2021/10/09 15:14 by 127.0.0.1