Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

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

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.

An Introduction to Database High Availability for MySQL & MariaDB

These days high availability is a must for any serious deployment. Long gone are days when you could schedule a downtime of your database for several hours to perform a maintenance. Making a database environment highly available is one of the highest priorities nowadays alongside data integrity. For a database, which is often considered the single source of truth, compromised data integrity can have catastrophic consequences.

How to Migrate from Oracle DB to MariaDB

Watch the replay of this webinar in which we walk you through all you need to know to plan and execute a successful migration from Oracle database to MariaDB.

Posted in:

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.

High Availability on a Shoestring Budget - Deploying a Minimal Two Node MySQL Galera Cluster

Learn how to set up a Galera cluster with just 2 nodes and use Garbd to retain high availability.

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.

Migrating from Oracle Database to MariaDB - What You Should Know

For many organizations, migrating from Oracle to an open source database platform is just a matter of time. An Oracle to MariaDB migration can be a complex multistage process, but choosing the right database architecture and features can reduce the cost and time of the operation. This blog aims to help you better understand the details of the complexities involved and how to overcome them.

Hybrid OLTP/Analytics Database Workloads in Galera Cluster Using Asynchronous Slaves

Reporting and analytics is a common requirement, but should you run it on your production database? For Galera Cluster, heavy OLAP queries may interfere with the performance of regular OLTP operations. In this blog post, we’ll describe an easy way to offload OLAP workload from Galera Cluster to asynchronous replication slave.

Analytics with MariaDB AX - the Open Source Columnar Datastore

What is a columnar datastore? When is it a better fit over a relational datastore? In this blog post, we will take a look at MariaDB AX and how it fits in this landscape.