Categories
Products
Technologies
Top Rated docs

May 28, 2019

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...

May 23, 2019

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...

May 20, 2019

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...

May 14, 2019

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...

May 14, 2019

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...

May 10, 2019

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...

May 8, 2019

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...

May 6, 2019

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...

April 26, 2019

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...

April 25, 2019

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...

April 16, 2019

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...

April 15, 2019

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...

Subscribe below to be notified of fresh posts