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...
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...
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...
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...
How to Cluster Odoo 12 with PostgreSQL Streaming Replication for High Availability
Odoo (formerly known as OpenERP) is a suite of open-source business apps. It comes in two versions - community and enterprise. Some of the most popular apps (and free!) integrated within this platform are Discuss,...
PostgreSQL High Availability with Master-Slave & Master-Master Architectures
Below is an excerpt from our whitepaper “PostgreSQL Management and Automation with ClusterControl” which can be downloaded for free. Revision Note: Keep in mind that the terms used in this blog Master-Slave are synonymous of Master-Standby...
PostgreSQL Replication for Disaster Recovery
With Disaster Recovery, we aim to set up systems to handle anything that could go wrong with our database. What happens if the database crashes? What if a developer accidently truncates a table? What if...
Database High Availability Comparison – MySQL / MariaDB Replication vs Oracle Data Guard
In the “State of the Open-Source DBMS Market, 2018”, Gartner predicts that by 2022, 70 percent of new in-house applications will be developed on an open-source database. And 50% of existing commercial databases will have...
A Developer’s Guide to MongoDB Sharding
A massive growth of data comes with a cost of reduced throughput operations especially when being served by a single server. However, you can improve this performance by increasing the number of servers and also...
Tracking High Availability for PostgreSQL With Heartbeat
When deploying a database cluster in different servers you will have achieved the replication advantage of improving data availability. However there is need to keep track of processes, and see whether they are running or...