How to Make Your MySQL or MariaDB Database Highly Available on AWS and Google Cloud
Running databases on cloud infrastructure is getting increasingly popular these days. Although a cloud VM may not be as reliable as an enterprise-grade server, the main cloud providers offer a variety of tools to increase...
Capacity Planning for MySQL and MariaDB – Dimensioning Storage Size
Server manufacturers and cloud providers offer different kinds of storage solutions to cater for your database needs. When buying a new server or choosing a cloud instance to run our database, we often ask ourselves...
Comparing Replication Solutions From Oracle and MySQL
Databases can fail without warning - either because of a crash caused by a software bug, or the underlying hardware components. The cloud brings another dimension to the issue, because of the ephemeral nature of...
Webinar Replay: How to Design Open Source Databases for High Availability
Thanks for joining this week’s webinar on how to design open source databases for high availability with Ashraf Sharif, Senior Support Engineer at Severalnines. From discussing high availability concepts through to failover or switch over...
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...
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....
Migrating from MySQL to PostgreSQL – What You Should Know
Whether migrating a database or project from MySQL to PostgreSQL, or choosing PostgreSQL for a new project with only MySQL knowledge, there are a few things to know about PostgreSQL and the differences between the...
Comparing Oracle RAC HA Solution to Galera Cluster for MySQL or MariaDB
Business has continuously desired to derive insights from information to make reliable, smarter, real-time, fact-based decisions. As firms rely more on data and databases, information and data processing is the core of many business operations...
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....
Failover for MySQL Replication (and others) – Should it be Automated?
Automatic failover for MySQL Replication has been subject to debate for many years. Is it a good thing or a bad thing? For those with long memory in the MySQL world, they might remember the...