Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
44 blog posts in 13 categories

How to Migrate WHMCS Database to MariaDB Galera Cluster

The WHMCS software suite relies on a MySQL database to store its data, so how do you make it highly available? This blog post shows how to migrate the existing WHMCS database from a standalone MySQL server (provided by the WHM/cPanel server itself) to a three-node MariaDB Galera Cluster to improve the database availability.

How to Execute and Manage MySQL Backups for Oracle DBA’s

Whether you’re planning to migrate from Oracle database to MySQL or run your new project with MySQL, you need to know how to do copies of your data. In this blog post, we will cover some of the most typical cases of the data backups with reference to Oracle backup methods. We will tell you how to guard yourself against data loss, what tools and commands to use, and how can you recover your data.

How to Perform a Failback Operation for MySQL Replication Setup

In case of master failure in a MySQL Replication setup, the most updated slave can be promoted to new master and all slaves repointed to the new master. But once the failed master has been fixed, what is the best way to re-introduce it as master, so as to restore the original topology.

This blog post shows how to perform the MySQL master failback operation.

Monitoring & Ops Management of MySQL 8.0 with ClusterControl

MySQL 8.0 is a big step forward in terms of data consistency, developer features, performance and availability. MySQL 8.0 shortens the gap between proprietary databases and open source world, making the migration decision much easier to take.

But how can you manage it, along with other relational open source databases? In this blog post, we look at the challenges of operating a MySQL 8.0 database, and see how important tasks like monitoring, alerting, backups and failover can be handled in an automated way.

Database High Availability for Camunda BPM using MySQL or MariaDB Galera Cluster

This blog post covers how to deploy a highly available MySQL or MariaDB database cluster for Camunda BPM 7.10 Community Edition on Linux. Camunda supports major databases through JDBC drivers, namely Oracle, DB2, MySQL, MariaDB and PostgreSQL. We will show two different implementations for the database endpoint, one leveraging ProxySQL and the other using the standard JDBC driver.

Understanding the Effects of High Latency in High Availability MySQL and MariaDB Solutions

To insulate our database infrastructure from failures, we build redundant cluster systems. For instance, MySQL and MariaDB high availability can be implemented by master-slave as well as master-master replication solutions. There are a number of variables that affect our choice solution. In this blog, we will look into considerations around latency.

How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster on Docker

ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera and MySQL Group Replication native support. This blog post shows how to run the new ProxySQL 2.x for Galera Cluster on Docker container, which is quite a bit different as compared to ProxySQL 1.x.

HA for MySQL and MariaDB - Comparing Master-Master Replication to Galera Cluster

Replication and Galera Cluster are both widely used to implement high availability for MySQL/MariaDB, but when should you pick one over the other? What are the limitations of each solution, and what are the trade offs?
In this blog post, we will look at the differences in terms of data consistency, conflict resolution, failover, node provisioning and robustness.

Dealing with Unreliable Networks When Crafting an HA Solution for MySQL or MariaDB

Networks may not be always stable or reliable, but your database clusters have to. This blog discusses the things to keep in mind when designing an HA solution for MySQL or MariaDB, deployed across potentially unreliable networks.

Migration from Oracle Database to MariaDB - A Deep Dive

Following our recent blogs showcasing how to migrate from Oracle to MySQL/Percona, then to MariaDB and what you should know, this blog offers extra thoughts and insights before you plan to migrate to MariaDB.

Pages