Severalnines Blog
The automation and management blog for open source databases

Managing MySQL Replication for High Availability

Severalnines
Posted in:

Join us on February 2nd for this new webinar on Managing MySQL Replication for High Availability led by Krzysztof Książek, Senior Support Engineer at Severalnines. This is part of our ongoing ‘Become a MySQL DBA’ series.

Deploying a MySQL Replication topology is only the beginning of your journey. Maintaining it also involves topology changes, managing slave lag, promoting slaves, repairing replication issues, fixing broken nodes, managing schema changes and scheduling backups. Multi-datacenter replication also adds another dimension of complexity. It is always good to be prepared up front and know how to deal with these cases.

In this webinar we will cover deployment and management of MySQL replication topologies using ClusterControl, show how to schedule backups, promote slaves and what are the most important metrics to keep a close eye on. We will also cover how you can deal with schema and topology changes as well as some of the most common replication issues.

Date & time

Europe/MEA/APAC

Tuesday, February 2nd at 09:00 GMT / 10:00 CET (Germany, France, Sweden)
Register Now

North America/LatAm

Tuesday, February 2nd at 09:00 Pacific Time (US) / 12:00 Eastern Time (US)
Register Now

Agenda

  • Deployment of MySQL replication topologies using ClusterControl
  • Schedule backups
  • Promote slaves
  • Important metrics to keep an eye on
  • Schema changes
  • Topology changes
  • Common replication issues

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. This webinar builds upon recent blog posts and related webinar series by Krzysztof on how to become a MySQL DBA.

We look forward to “seeing” you there and to some good discussions!

To read our new MySQL Replication online tutorial, please visit:
http://severalnines.com/tutorials/mysql-replication-high-availability-tutorial

To view all the blogs of the ‘Become a MySQL DBA’ series visit:
http://www.severalnines.com/blog-categories/db-ops

To view all our webinar replays, please visit:
http://severalnines.com/webinars-replay

Related Post

Percona Live 2017 - Severalnines Recap

This blog contains a recap of Severalnines participation the Percona Live 2017 Open Source Database Conference including videos and slides from our sessions.

How to deploy and manage HAProxy, MaxScale or ProxySQL with ClusterControl - Webinar May 9th

New webinar on support for proxies for MySQL HA setups in ClusterControl: how they differ and what their pros and cons are. We will also demonstrate how you can easily deploy and manage HAProxy, MaxScale and ProxySQL from ClusterControl during a live demo.

Meet the Severalnines team at M|17 and Percona Live this month

April 2017 will see the Severalnines team attend two open source database conferences, namely the MariaDB User Conference, and the Percona Live Conference. Find all details about our participation here.

Posted in:

High Availability in ProxySQL: new webinar with René Cannaò

New joint webinar with ProxySQL’s creator, René Cannaò, on how to build a highly available proxy layer with ProxySQL; and how to automate some of these processes with ClusterControl.