Severalnines Blog
The automation and management blog for open source databases

Planets9s - Join us next Tuesday: introducing a new Blueprint for MySQL Replication

Severalnines
Posted in:

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source databases.

Join us next Tuesday: introducing a new Blueprint for MySQL Replication

In this new webinar, we will introduce the Severalnines Blueprint for MySQL Replication - this includes all aspects of a MySQL Replication topology with the ins and outs of deployment, setting up replication, monitoring, upgrades, performing backups and managing high availability using proxies as ProxySQL, MaxScale and HAProxy.

Sign up for the webinar

Read-Write Splitting for Java Apps using Connector/J, MySQL Replication and HAProxy

In this new blog post, we play around with Java, Connector/J, MySQL Replication and HAProxy. And we describe how to manually deploy a MariaDB Replication setup and add it into ClusterControl using “Add Existing Server/Cluster” as well as deploy HAProxy with Keepalived, and create a simple Java application to connect to our Replication setup.

Read the blog

How ProxySQL adds Failover and Query Control to your MySQL Replication Setup

In this new blog post we describe how to set up ProxySQL to work in a MySQL Replication environment managed by ClusterControl. We take a look at the metrics it provides to a DBA, and how this data can be used to ensure smooth operations.

Read the blog

That’s it for this week! Feel free to share these resources with your colleagues and follow us in our social media channels.

Have a good end of the week,

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: