Transparent Database Failover for Your Applications
ClusterControl is a great tool to deploy and manage databases clusters - if you are into MySQL, you can easily deploy clusters based on both traditional MySQL master-slave replication, Galera Cluster or MySQL NDB Cluster....
How ClusterControl Configures Virtual IP and What to Expect During Failover
Virtual IP address is an IP address that does not correspond to an actual physical network interface. It floats between multiple network interfaces and only one active interface will be holding the IP address for...
PostgreSQL Load Balancing Using HAProxy & Keepalived
A proxy layer can be quite useful in increasing availability of your database tier. It may reduce the amount of code on the application side to handle database failures and replication topology changes. In this...
HAProxy: All the Severalnines Resources
Load balancers are an essential component in MySQL and MariaDB database high availability; especially when making topology changes transparent to applications and implementing read-write split functionality. HAProxy is free, open source software that provides a...
HAProxy Connections vs MySQL Connections – What You Should Know
Having a load balancer or reverse proxy in front of your MySQL or MariaDB server does add a little bit of complexity to your database setup, which might lead to some, things behaving differently. Theoretically,...
The Command Line Interface to ClusterControl
s9s is our official command line tool to interact with ClusterControl. We’re pretty excited about this, as we believe its ease of use and script-ability will make our users even more productive. Let’s have a...
Webinar Replay: How to Deploy and Manage ProxySQL, HAProxy and MaxScale
Thanks to everyone who participated in yesterday’s webinar on how to deploy and manage ProxySQL, HAProxy and MaxScale with ClusterControl. Krzysztof Książek, Senior Support Engineer at Severalnines, discussed support for proxies for MySQL HA setups...
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...
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...
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...
WordPress Application Clustering Using Kubernetes with HAProxy and Keepalived
In a previous blog post, we showed you how to install Kubernetes on CentOS 7. Since then, there’s been a number of changes and we’ve seen the first production-ready release. The “minion” term has been...
Webinar Replay: A DevOps Guide to Database Infrastructure Automation for eCommerce
Thanks to everyone who attended and participated in last week’s webinar on ‘A DevOps Guide to Database Infrastructure Automation for eCommerce’. If you missed the sessions or would like to watch the webinar again &...