Severalnines Blog
The automation and management blog for open source databases

New Whitepaper: MySQL Replication for High Availability

Severalnines
March 22, 2016
Posted in: DB Ops

MySQL Replication is probably the most popular high availability solution for MySQL, and widely used by top web properties like Twitter and Facebook. Although easy to set up, ongoing maintenance like software upgrades, schema changes, topology changes, failover and recovery have always been tricky. At least until MySQL 5.6.

Having recently discussed deployment and management of MySQL replication topologies, we’re now making this handy whitepaper available to all those of you who are currently working with or intending to work with MySQL Replication.

Our new whitepaper covers all you need to know about MySQL Replication, including information on the latest features introduced in 5.6 and 5.7. It also provides a more hands-on, practical section on how to quickly deploy and manage a replication setup using ClusterControl.

More specifically, the following topics are discussed:

  • What is MySQL Replication?
  • Topology for MySQL Replication
  • Deploying a MySQL Replication Setup
  • Connecting Application to the Replication Setup
  • Failover with ClusterControl
  • Operations: managing your MySQL Replication Setup
  • Issues & troubleshooting

To download your free copy of this new whitepaper, click here.

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

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

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.