Severalnines Blog
The automation and management blog for open source databases

Managing MySQL Replication for High Availability

Severalnines
January 20, 2016
Posted in: Events

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

How to build a stable MySQL Replication environment

Severalnines
November 29, 2016

During this webinar, participants will learn how to build a production-ready environment with MySQL replication. From OS and DB configuration checklists to schema changes and disaster recovery, they’ll have the information needed to plan and prepare the best setup for their requirements.

Posted in: DB Ops Events

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

Severalnines
November 22, 2016

Join our new webinar during which we’ll cover our 9 Top Tips on how to build a stable MySQL Replication environment. From OS and DB configuration checklists to schema changes and disaster recovery,  you’ll have the tips needed for a production-ready replication setup.

Posted in: DB Ops Events

Webinar: Become a MongoDB DBA - Scaling and Sharding

Severalnines
October 27, 2016

In this third webinar of the ‘Become a MongoDB DBA’ series, we will focus on scaling and sharding your MongoDB setup.

Posted in: DB Ops Events MongoDB

Completing the MySQL Query Tuning Trilogy: working with optimizer & SQL tuning

Severalnines
October 27, 2016

This webinar was the third and last part of our webinar trilogy on MySQL Query Tuning, in which we discussed query tuning and related tools. In this trilogy we’ve covered SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans. Part 3 focussed on working with the optimizer and SQL tuning.

Posted in: DB Ops Events