Cloud Computing Makes MySQL Replication Easier
DZone's Guide to
Cloud Computing Makes MySQL Replication Easier
Join the DZone community and get the full member experience.
Join For FreeDiscover a centralized approach to monitor your virtual infrastructure, on-premise IT environment, and cloud infrastructure – all on a single platform.
MySQL Replication tends to be complex.
Creating a new slave to support your system expansion is not easier: copying large data files over the LAN, recovering replication, etc.
Fortunately, virtualization and SAN help us do it easier and faster.
Lucky us, Cloud Computing make it even easier.
Creating a new slave to support your system expansion is not easier: copying large data files over the LAN, recovering replication, etc.
Fortunately, virtualization and SAN help us do it easier and faster.
Lucky us, Cloud Computing make it even easier.
Adding a New Slave is Easier than Ever
- Select an existing slave that can be reboot w/o affecting the service.
- Take the slave out of the production environment.
- Stop the MySQL slave and perform a read lock: SLAVE STOP;FLUSH TABLES WITH READ LOCK;
- Create an AMI based on this instance using AWS console or API.
- Recover the instance upon AMI creation completion and get the slave back to production: UNLOCK TABLES;SLAVE START;SHOW SLAVE STATUS\G
- Create a new slave based on the AMI
- Launch a new slave using the AWS console or API.
- Change the server's /etc/my.cnf file to fit a new slave instance:
- Change the server-id=N value to a new numeric value.
- Set relay-log='server-relay-bin' to the original slave server relay log name. (if you want to make it even easier, configure in the first slave's my.cnf relay-log=mysqld-relay-bin, and you'll be able to avoid this step).
- Restart the MySQL instance: sudo /etc/init.d/mysql restart
- Recover the MySQL: UNLOCK TABLES;SLAVE START;SHOW SLAVE STATUS\G
- Add this new slave to the production environment.
Bottom Line
Expanding your business today is easier w/o the need for file copy or any other tedious action.
Keep Performing,
Learn how to auto-discover your containers and monitor their performance, capture Docker host and container metrics to allocate host resources, and provision containers.
Like This Article? Read More From DZone
Topics:
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}