Severalnines Blog
The automation and management blog for open source databases

Top 9 Tips for building a production-ready MySQL Replication environment

Severalnines
Posted in:

Join us on Tuesday, December 6th, for our last webinar of the year. Krzysztof Książek, Senior Support Engineer at Severalnines, will be sharing his top 9 tips on how to best build a production-ready MySQL Replication environment.

MySQL replication is a well known and proven solution for building distributed setups of databases, and it has gone through a total transformation with version 5.6 and more recently, 5.7. Although straight-forward to deploy, a production-ready setup requires a bit of planning and preparation. What does a good replication configuration look like? How do you ensure performance? What do you do when a topology is broken, and replication will not restart? How to perform schema changes?

So if you'd like to learn what is needed to build a stable environment using MySQL replication, this webinar is for you!

Top 9 Tips for building a stable MySQL Replication environment

Tuesday, December 6th

Sign up for the webinar

We look forward to “seeing” you there!

Agenda

  1. Sanity checks before migrating into MySQL replication setup
  2. Operating system configuration
  3. Replication
  4. Backup
  5. Provisioning
  6. Performance
  7. Schema changes
  8. Reporting
  9. Disaster recovery

Speaker

Krzysztof Książek, Senior Support Engineer at Severalnines, is a MySQL DBA with experience managing complex database environments for companies like Zendesk, Chegg, Pinterest and Flipboard.

Related Post

Video: ClusterControl Command Line Client (CLI) Product Demonstration

This video details the features and functions that are available in the new ClusterControl Command Line Client (CLI).

Posted in:

Database Automation: Integrating the ClusterControl CLI with your ChatBot

The new ClusterControl command line client allows easy integration with other automation and collaboration tools, such as chatbots. Instead of integrating the CLI in your own chatbot, you can use the Hubot based ClusterControl chatbot called CCBot alternatively.

Webinar - How to use ClusterControl from the command line and integrate with your DevOps tools

The Severalnines command line interface offers an open source alternative for the web-based ClusterControl User Interface on the command line. You can perform almost any deployment, management or scaling task from the command line.

Webinar Replay and Q&A: how to deploy and manage ProxySQL, HAProxy and MaxScale

This blog provides details for the replay of our webinar on how to deploy and manage ProxySQL, HAProxy and MaxScale, as well as answers to the questions asked during this session.

Posted in: