Severalnines Blog
The automation and management blog for open source databases

How to build a stable MySQL Replication environment

Severalnines
November 29, 2016
Posted in: DB Ops Events

While straight-forward to deploy, a production-ready and hence stable MySQL Replication setup requires a bit of planning and preparation. What does a solid replication configuration look like? What do you do when a topology is broken, and replication will not restart? How do you ensure performance? Or perform schema changes?

If you'd like to learn how to build a stable environment with MySQL replication, this webinar is for you. From OS and DB configuration checklists to schema changes and disaster recovery, you’ll have the information needed.

Join us next Tuesday as Krzysztof Książek, Senior Support Engineer at Severalnines, shares his top 9 tips on how to best build a production-ready MySQL Replication environment.

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

Planets9s - Eurofunk replaces Oracle with feature-rich Severalnines ClusterControl

Severalnines
December 02, 2016

Planets9s is a weekly communication on all the latest Severalnines resources and technologies around automation and management of open source databases such as MySQL, MariaDB, PostgreSQL & MongoDB.

Posted in: DB Ops Devops Planets9s

Planets9s - Top 9 Tips for MySQL Replication, MongoDB Sharding & NinesControl

Severalnines
November 25, 2016

Planets9s is a weekly communication on all the latest Severalnines resources and technologies around automation and management of open source databases such as MySQL, MariaDB, PostgreSQL & MongoDB.

Posted in: DB Ops Devops Planets9s

Become a MongoDB DBA: Sharding ins- and outs - part 2

Art van Scheppingen
November 23, 2016

In our previous post, we showed you how to shard your MongoDB databases and covered the theory behind it. But you are not done yet. How do you monitor the shards to make sure they are performing, and that data is distributed evenly between your shards? And how do you consistently backup your data across shards? This is our ninth post in the “Become a MongoDB DBA” blog series.

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