Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
255 blog posts in 12 categories

How to Deploy Open Source Databases - New Whitepaper

Choosing which DB engine to use between all the options we have today is not an easy task. An that is just the beginning. After deciding which engine to use, you need to learn about it and actually deploy it to play with it. In this whitepaper we’ll show you how to install, configure and secure some of the most popular open source DB engines.

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.

MySQL Replication for High Availability - New Whitepaper

This whitepaper covers information about MySQL Replication, with information about the latest features introduced in 5.6, 5.7 and 8.0. There is also a more hands-on, practical section on how to quickly deploy and manage a replication setup using ClusterControl.

Deploying Secure Multicloud MySQL Replication on AWS and GCP with VPN

MySQL Replication is still favored by some organization as it's simple to implement and run. However, in a multi-cloud setup like Google Cloud Platform <–> Amazon Web Services, things can get tedious without proper cluster management, monitoring and observability tools. This blog showcases how to create a secure implementation of cloud <–> cloud replication and how ClusterControl can be used to resolve these impediments.

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.

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.

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.

How to Manage MySQL - for Oracle DBAs

So, you are an Oracle DBA and your manager asked you to migrate a couple of Oracle databases to MySQL. Databases are migrated, and now what? How do you manage these MySQL databases?

In this blog, we show you how Oracle DBAs can best manage MySQL by covering the basic operations of MySQL with reference to similar tasks in your Oracle environment.

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.

Pages