How do I configure and deploy a recommended MySQL Replication setup?
FeaturedA MySQL Replication cluster can be configured using the Severalnines Configurator: http://www.severalnines.com/replication-configurator/
The wizard collects some high level data (e.g. IP addresses of machines, size of database, amount of RAM in machines, type of database workload, etc.). The application then generates the configuration of the Replication Cluster. At the end, a deployment package is automatically generated and emailed to the user.
The deployment package automates a number of tasks:
- copy and install binaries on all servers
- create datadirs
- create OS user
- create the mysql user for MySQL Servers
- install system tables
- set permissions for MySQL
- set up replication links (Master->Backup Master->Slaves)
install ClusterControl™ on all hosts to monitor the cluster, detect failures and automate fail-over
At the end, it has a verification phase that verifies whether the cluster has been properly set up. The Replication Cluster is now deployed.
Please sign in to leave a comment.
Comments
0 comments