The master-slave hot standby of databese of wordpress

Introduction

The master-slave hot standby of database could improve the data security, stability, and efficient transmission of wordpress.

Configuration of steps

1 configure my.cnf in salve vps
server-id need different from the master
replicate-do-db: the database you want to syn

2 input SHOW MASTER STATUS; in the master and remember the file and position

3 input CHANGE MASTER TO MASTER_HOST in the slave
address: your database address
port: your database port
File: your begin file (mysql-bin.000004)
Position: begin position (23033)

4 input SHOW SLAVE STATUS\G in the slave database
if Slave_IO_Running and Slave_SQL_Running is yes that is successful

likes

Leave a Reply

Your email address will not be published. Required fields are marked *