Ben Stienstra

Linux, Unix, network, radio and more...

User Tools

Site Tools


powerdns_master-slave_replication_with_mysql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
powerdns_master-slave_replication_with_mysql [2015/04/10 20:28]
admin [Slave configuration]
powerdns_master-slave_replication_with_mysql [2015/04/10 20:33]
admin [Enable replication]
Line 92: Line 92:
 read_only = 1</​code>​ read_only = 1</​code>​
  
 +====Enable replication====
 +  * Import the backup on the **slave**:<​code>​MariaDB [(none)]>​ source /​tmp/​master_backup.sql</​code>​
 +  * Configure replication:<​code>​CHANGE MASTER TO
 +Master_Host='​ns1.polaire.nl',​
 +Master_User='​replicator',​
 +Master_Password='​yourpassword',​
 +Master_SSL=1,​
 +Master_SSL_CA = '/​etc/​pki/​tls/​certs/​mariadb/​ca.pem',​
 +Master_SSL_CERT = '/​etc/​pki/​tls/​certs/​mariadb/​slave-public.pem',​
 +Master_SSL_KEY = '/​etc/​pki/​tls/​certs/​mariadb/​slave-private.pem',​
 +Master_SSL_Verify_Server_Cert = 1;
 +Query OK, 0 rows affected (0.08 sec)</​code>​
 +  * Start slave:<​code>​MariaDB [(none)]>​ slave start;
 +Query OK, 0 rows affected (0.00 sec)
 +
 +MariaDB [(none)]>​ show slave status \G</​code>​
powerdns_master-slave_replication_with_mysql.txt ยท Last modified: 2015/04/10 20:33 by admin