Ben Stienstra

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

User Tools

Site Tools



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_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