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...
How to Automate Migration from Standalone MySQL to Galera Cluster using Ansible
Database migrations don’t scale well. Typically you need to perform a great deal of tests before you can pull the trigger and switch from old to new. Migrations are usually done manually, as most of...
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...
Top Common Issues with MHA and How to Fix Them
In our previous blogs, we discussed MHA as a failover tool used in MySQL master-slave setups. Last month, we also blogged about how to handle MHA when it crashed. Today, we will see the top...
Database-Aware Load Balancing: How to Migrate from HAProxy to ProxySQL
HAProxy and ProxySQL are both very popular load balancers in MySQL world, but there is a significant difference between both those proxies. We will not go into details here, you can read more about HAProxy...
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...
How to Execute and Manage MySQL Backups for Oracle DBA’s
Migrating from Oracle database to open source can bring a number of benefits. The lower cost of ownership is tempting, and pushes a lot of companies to migrate. At the same time DevOps, SysOps or...
What’s New in ProxySQL 2.0
ProxySQL is one of the best proxies out there for MySQL. It introduced a great deal of options for database administrators. It made possible to shape the database traffic by delaying, caching or rewriting queries...
Benchmarking Manual Database Deployments vs Automated Deployments
There are multiple ways of deploying a database. You can install it by hand, you can rely on the widely available infrastructure orchestration tools like Ansible, Chef, Puppet or Salt. Those tools are very popular...
How to Perform a Failback Operation for MySQL Replication Setup
MySQL master-slave replication is pretty easy and straightforward to set up. This is the main reason why people choose this technology as the first step to achieve better database availability. However, it comes at the...
Monitoring & Ops Management of MySQL 8.0 with ClusterControl
Users of open source databases often have to use a mixture of tools and homegrown scripts to manage their production database environments. However, even while having own homegrown scripts in the solution, it’s hard to...
How to Deploy Open Source Databases
We’re happy to announce that our new whitepaper How to Deploy Open Source Databases is now available to download for free! Choosing which DB engine to use between all the options we have today is...