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