Database Automation with Puppet: Deploying MySQL & MariaDB Replication
Puppet is an open source systems management tool for centralizing and automating configuration management. Automation tools help to minimize manual and repetitive tasks, and can save a great deal of time. Puppet works by default...
Comparing Data Stores for PostgreSQL – MVCC vs InnoDB
One of the primary requirements for any database is to achieve scalability. It can only be achieved if the contention (locking) is minimized as much as possible, if not removed all together. As read /...
How to Automate Deployment of MySQL Galera Cluster using s9s CLI and Chef
In our previous blog, we showed how devops can automate your daily database tasks with Chef. Now, let's see how we can quickly deploy a MySQL Galera Cluster with Chef using s9s CLI. Setting up...
An Overview of WiredTiger Storage Engine for MongoDB
Every database system has a structured component which is responsible for maintaining how data is stored and served both in memory and disk. This is often referred to as a storage engine. More often when...
How to Migrate WHMCS Database to MariaDB Galera Cluster
WHMCS is an all-in-one client management, billing and support solution for web hosting companies. It's one of the leaders in the hosting automation world to be used alongside the hosting control panel itself. WHMCS runs...
Popular Docker Images for MySQL and MariaDB Server
A Docker image can be built by anyone who has the ability to write a script. That is why there are many similar images being built by the community, with minor differences but really serving...
MongoDB Schema Planning Tips
One of the most advertised features of MongoDB is its ability to be “schemaless”. This means that MongoDB does not impose any schema on any documents stored inside a collection. Normally, MongoDB stores documents in...
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...
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...
How to Migrate from Oracle DB to MariaDB
Migrating from Oracle database to MariaDB can come with a number of benefits: lower cost of ownership, access to and use of an open source database engine, tight integration with the web, an active community...
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...