How to do Point-in-Time Recovery of MySQL & MariaDB Data Using ClusterControl
Backups are crucial when it comes to safety of data. They are the ultimate disaster recovery solution - you have no database nodes reachable and your datacenter could literally have gone up in smoke, but...
Visualizing Your Cluster Topology in ClusterControl
Distributed databases or clusters typically consist of multiple node and nodes types, and it is not always easy to understand how all these hang together. For instance, one could have a replication setup with intermediate...
Automation and Management of Open Source Databases in the Cloud – Announcing ClusterControl 1.6
Today we are excited to announce the 1.6 release of ClusterControl - the all-inclusive database management system that lets you easily deploy, monitor, manage and scale highly available open source databases - and load balancers...
Database Automation Behind Sweden’s New Electronic Identity Freja eID
Severalnines is excited to announce its newest customer Verisec AB, an international IT security company on the cutting edge of digital security, creating solutions that make systems secure and easily accessible for industries like banking,...
Using socat on CentOS/RHEL for Streaming Backups
There are several ways to perform remote-to-remote data copy - socat, netcat, rsync, scp, sftp. ClusterControl was using netcat for remote copy purposes, however we have flipped that decision to use socat. This blog post...
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...