Comparing Database Proxy Failover Times – ProxySQL, MaxScale and HAProxy
ClusterControl can be used to deploy highly available replication setups. It supports switchover and failover for GTID-based MySQL or MariaDB replication setups. ClusterControl can deploy different types of proxies for traffic routing: ProxySQL, HAProxy and...
Making Your Database Components Highly Available (HA) via Load Balancers
Choosing Your HA Topology There are various ways to retain high availability with databases. You can use Virtual IPs (VRRP) to manage host availability, you can use resource managers like Zookeeper and Etcd to (re)configure...
Getting Started with ProxySQL – MySQL & MariaDB Load Balancing Tutorial
We’re excited to announce a major update to our tutorial “Database Load Balancing for MySQL and MariaDB with ProxySQL” ProxySQL is a lightweight yet complex protocol-aware proxy that sits between the MySQL clients and servers....
Tips for Managing Your Database Configurations
In the past five posts of the blog series, we covered deployment of clustering/replication (MySQL / Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health,...
Join Us in Amsterdam for a Meetup with OptimaData & VidaXL
Severalnines, our partner OptimaData, and customer VidaXL are joining forces to present the meetup “How to Manage Fast Growing Databases” in Amsterdam featuring a myriad of technical information and tips on load balancing, automation, open...
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...
How to Get Started with ClusterControl
Managing database production systems takes a ton of work. Even with all the passion you can muster, it is never an easy undertaking. For one, the times when you had single database vendor are gone....
MySQL Query Performance Tuning
Bad query performance is the most common problem DBA’s have to deal with. There are numerous ways to collect, process and analyze the data related to query performance - we’ve covered one of the most...
SSL Key Management and Encryption of MySQL Data in Transit
Databases usually work in a secure environment. It may be a datacenter with a dedicated VLAN for database traffic. It may be a VPC in EC2. If your network spreads across multiple datacenters in different...
How to Schedule Database Backups with ClusterControl
Database backup is a critical part of database management and has to be carefully planned. Scheduling a backup is not enough; backup data also needs to be verified for consistency and integrity. There are other...
Deploying Highly Available Databases and Clusters with ClusterControl
We get some nice feedback with regards to our product ClusterControl, especially how easy it is to install and get going. Installing new software is one thing, but using it properly is another. It is...