Yesterday I have been working on MySQL Replication between two servers. And I think you will need it as a reference article. Because of I also re-search a lot before starting.
Some question:
What is MySQL replication?
How to do?
How is Master? is Slave?
How to configure?
MySQL replication for non-standard port?
How to stop MySQL replication?
How it works?
Ok, let's start!
What is MySQL replication?
MySQL replication is a process that allows you to easily maintain multiple copies of a MySQL data by having them copied automatically from a master to a slave database
How to do?
It has two components: master & slave. They have to configure on two servers. The mysql data will be transferred real time between them.
How is Master? is Slave?
Master: it is running on production in your company. The data will be transferred from here to slave server. Slave: The data will be transferred to here. In case of disaster, this will be take over as master (primary database).
How to configure?
MySQL replication for non-standard port?
How to stop MySQL replication?
How it works?
0 nhận xét:
Post a Comment