Severalnines Blog
The automation and management blog for open source databases

Planets9s - Download our whitepaper on automation & management of open source databases

Posted in:

Welcome to Planets9s, a weekly communication on all the latest resources and technologies that we create at Severalnines around automation and management of open source databases. I trust that these resources will be useful to you and would love to get your feedback on them.

Download our whitepaper on automation & management of open source databases

Whether you’re looking into ways to automate various aspects of administering your open source databases or to take better control of your data, this whitepaper covers what tools to build (or buy) for effective management, database deployment options beyond Chef or Puppet, important aspects of monitoring and managing open source database infrastructures and how ClusterControl enables a systematic approach to their operations.

Click here to download the whitepaper

Managing MySQL Replication for High Availability

If you’re looking into deploying a MySQL Replication topology or maintaining one, you’ll find great insight in this webinar replay about topology changes, managing slave lag, promoting slaves, repairing replication issues, fixing broken nodes, managing schema changes and scheduling backups. Multi-datacenter replication is also covered.

Get access to the webinar replay

High availability read-write splitting with php-mysqlnd, MySQL Replication and HAProxy

MySQL Replication is used in a variety of use cases - scale out read workloads, provide high availability and geographic redundancy, offload backups and reporting/analytic jobs. However it has a big drawback - the application needs to be able to send writes to the master only. In this blog post, we explore the use of php-mysqlnd_ms with a PHP application (Wordpress) on a standard MySQL Replication backend.

Read the blog here

Do share these resources with your colleagues and follow us in our social media channels.

Have a good weekend,

Jean-Jérôme Schmidt
Planets9s Editor
Severalnines AB

Related Post

MongoDB Webinar - How to Secure MongoDB with ClusterControl

With authentication disabled by default in MongoDB, learning how to secure MongoDB becomes essential. In this webinar we will explain how you can improve your MongoDB security and demonstrate how this is automatically done by ClusterControl.

MySQL on Docker: Composing the Stack

Docker 1.13 introduces a long-awaited feature called Compose-file support. Compose-file defines everything about an application - services, databases, volumes, networks, and dependencies can all be defined in one place.  In this blog, we’ll show you how to use Compose-file to simplify the Docker deployment of MySQL containers.

Posted in:

How to deploy and manage MySQL multi-master replication setups with ClusterControl 1.4

MySQL replication, while simple and popular, may come in different shapes and flavors. Master slave or master master topologies can be configured to suit your environment.  ClusterControl 1.4 brings a list of enhancements to deploy and manage different types of MySQL replication setups. This blog outlines the different topologies that can be deployed, the merits of each topology, and shows how each can be managed in a live environment.

Posted in:

Automatic failover of MySQL Replication - New in ClusterControl 1.4

MySQL replication setups are inevitably related to failovers - what do you do when your master fails and your applications are not able to write to the database anymore? Automated failover is required if you need to quickly recover an environment to keep your database up 24x7. This blog post discusses this new replication feature recently introduced in ClusterControl 1.4.

Posted in: