Answering Eurofunk’s Database SOS Call
Eurofunk replaces Oracle with feature-rich Severalnines ClusterControl Today we’re happy to announce Eurofunk, one of the largest European command centre system specialists, as our latest customer. Severalnines was brought on board to help manage the...
MySQL Replication Failover – MaxScale vs MHA: Part Four
In the earlier blogs in this series, we concluded that MaxScale with MariaDB Replication Manager still has some way to go as a failover solution. The failover mechanism relied on MariaDB GTID, needed a wrapper...
How ProxySQL Adds Failover and Query Control to Your MySQL Replication Setup
In a previous blog post, we discussed the installation of ProxySQL and its configuration system. In today’s post, we’ll set up ProxySQL to work in a MySQL Replication environment managed by ClusterControl. We will take...
Read-Write Splitting for Java Apps Using Connector/J, MySQL Replication and HAProxy
In a previous post, we looked into load balancing for PHP apps and how to configure read-write splitting on MySQL Replication setups. The native PHP MySQL driver (php-mysqlnd_ms) would perform read/write splits, and the MySQL...
MySQL Load Balancing with ProxySQL – An Overview
Year 2015 was a good year for proxies in MySQL environments. First, MariaDB released a GA version of MaxScale, a new proxy that understands MySQL Replication and Galera topologies and supports read-write splitting. Later in...
Newly Updated “MySQL Load Balancing with HAProxy” Tutorial
We are glad to announce that one of our most popular tutorials has just been updated and is available here. In this tutorial, we cover how HAProxy works, and how to deploy, configure and manage...
MySQL Replication Failoverv – Maxscale vs MHA: Part Three
In our previous two posts we described in depth how MySQL Master-HA (MHA) and MaxScale + MariaDB Replication Manager (MRM) both perform their so called slave promotions (also known as master failover). MHA has been...
MySQL Replication Failover – Maxscale vs MHA: Part Two
In our previous post, we described how MySQL Master-HA (MHA) performs a so called slave promotion (also known as master failover) and ensures all remaining slaves in the topology get attached under the new master...
MySQL Replication Failover – Maxscale vs MHA: Part One
In our MySQL replication tutorial we have covered different aspects of replication including master failover by performing a slave promotion using ClusterControl. The slave promotion will turn a slave into the new master, and re-attach...
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...
Using NGINX as a Database Load Balancer for Galera Cluster
Nginx is well-known for its ability to act as a reverse-proxy with small memory footprint. It usually sits in the front-end web tier to redirect connections to available backend services, provided these passed some health...
How to Deploy and Manage MaxScale Using ClusterControl
We were delighted to announce that ClusterControl now supports MaxScale, the intelligent database gateway from the MariaDB team. In this blog, we will show you how to deploy and manage MaxScale from ClusterControl. We previously...