Database High Availability for Camunda BPM using MySQL or MariaDB Galera Cluster
Camunda BPM is an open-source workflow and decision automation platform. Camunda BPM ships with tools for creating workflow and decision models, operating deployed models in production, and allowing users to execute workflow tasks assigned to...
MySQL Replication for High Availability
We’re happy to announce that our newly updated whitepaper MySQL Replication for High Availability is now available to download for free! MySQL Replication enables data from one MySQL database server to be copied automatically to...
Deploying Secure Multicloud MySQL Replication on AWS and GCP with VPN
Why Choose MySQL Replication? Some basics first about the replication technology. MySQL Replication is not complicated! It is easy to implement, monitor, and tune as there are various resources you can leverage - google being...
Dealing with MySQL Long Running Queries
Long running queries/statements/transactions are sometimes inevitable in a MySQL environment. In some occasions, a long running query could be a catalyst to a disastrous event. If you care about your database, optimizing query performance and...
Understanding the Effects of High Latency in High Availability MySQL and MariaDB Solutions
High availability is a high percentage of time that the system is working and responding according to the business needs. For production database systems it is typically the highest priority to keep it close to...
How to Run and Configure ProxySQL 2.0 for MySQL Galera Cluster on Docker
ProxySQL is an intelligent and high-performance SQL proxy which supports MySQL, MariaDB and ClickHouse. Recently, ProxySQL 2.0 has become GA and it comes with new exciting features such as GTID consistent reads, frontend SSL, Galera...
An Introduction to Database High Availability for MySQL & MariaDB
The following is an excerpt from our whitepaper “How to Design Highly Available Open Source Database Environments” which can be downloaded for free. A Couple of Words on “High Availability” These days high availability is...
HA for MySQL and MariaDB – Comparing Master-Master Replication to Galera Cluster
Galera replication is relatively new if compared to MySQL replication, which is natively supported since MySQL v3.23. Although MySQL replication is designed for master-slave unidirectional replication, it can be configured as an active master-master setup...
How to Manage MySQL – for Oracle DBAs
Open source databases are quickly becoming mainstream, so migration from proprietary engines into open source engines is a kind of an industry trend now. It also means that we DBA’s often end up having multiple...
High Availability on a Shoestring Budget – Deploying a Minimal Two Node MySQL Galera Cluster
We regularly get questions about how to set up a Galera cluster with just 2 nodes. The documentation clearly states you should have at least 3 Galera nodes to avoid network partitioning. But there are...
Dealing with Unreliable Networks When Crafting an HA Solution for MySQL or MariaDB
Long gone are the days when a database was deployed as a single node or instance - a powerful, standalone server which was tasked to handle all the requests to the database. Vertical scaling was...
A Review of the New Analytic Window Functions in MySQL 8.0
Data is captured and stored for a variety of reasons. Hours beyond count (and even more budget) invested in collecting, ingesting, structuring, validating, and ultimately storing of data; to say that it is a valuable...