MySQL

The most popular, battle-tested, and highly scalable database solutions are achieved with asynchronous replication. In this blog post, we are going to deploy a Percona Server for MySQL replication setup specifically for high availability.

Oracle recently released MySQL 8.0.22, it included a new asynchronous connection failover mechanism which allows a replica to automatically establish an asynchronous replication connection to a new source, in case its existing one fails. 

This blog post will test out the deployment of Percona XtraDB Cluster 8.0 in a containerized environment, orchestrated by the Percona XtraDB Cluster Kubernetes Operator on Google Cloud Platform (GCP).

This blog will showcase not just the importance of auditing your database, but also how to use the Percona Audit Log Plugin to achieve these goals.

Data migration is a challenging task, but with the right setup, architecture, and tools it can be achieved. This blog will deal with the challenges and limitations when migrating your Azure Database for MySQL or MariaDB to an on-prem server.

This blog post will walk you through how to perform online migration from Google Cloud SQL to an on-premises server. There are differences between Google Cloud SQL and standard MySQL functionality like limited control, restricted resources, data locality, budget and security, which may influence your final decision to move out from the Google Cloud SQL instances and host the database service in the on-premises infrastructure

ProxySQL is a dedicated loadbalancer for MySQL database backends. If you run a HAProxy as your loadbalancer for MySQL, you may want to migrate to ProxySQL to benefit from all the features it comes with. This blog shares some tips regarding the migration process.

Migrating off Amazon RDS to an on-prem server can be tedious work,  especially if you need to determine how accurate the copy of your on-prem node is against the AWS RDS data. This blog will show you how to take care of this problem by sharing procedures to handle this situation.

Database migrations can be a hefty job to handle. This blog looks at tools which are freely available either to be used or to be extended in order to achieve your desired data migration activities.

Percona XtraDB Cluster comes with some changes from PXC 5.7. This blog is an attempt to highlight those, and which may have an impact on the upgrade process

Upgrades are necessary to apply security fixes, new features, compatibility issues, etc. Rolling Upgrades are a good option to keep your systems running during an upgrade process. In this blog, we will see some considerations to take into account before upgrading and how to perform a rolling upgrade on MySQL.

MySQL upgrades can be tricky, in this blog post we share some thoughts about the upgrade process from MySQL 5.7 to MySQL 8.0

HAProxy is one of the most common Load Balancing technologies nowadays. It is powerful open-source software and has many metrics to monitor to know how everything is going on. In this blog, we will look at the HAProxy statistics and how to monitor them.

This blog post covers the management tasks walkthrough of the advanced components commonly used in MariaDB Cluster - filters, logging, and maxscale - using MaxCtrl. All of the commands in this blog post are based on MaxScale 2.5.3.

ProxySQL comes with advanced features that allow users to take full control over the database traffic. This blog post will show you how to block certain queries and introduce delays.

A MySQL database index is a data structure that improves the speed of operations in a table. In this post, we discuss the benefits and the drawbacks of using indexes in MySQL.

Load balancers can be deployed into a number of topologies to achieve high availability for the database service with zero single-point-of-failure (SPOF). This blog post covers the pros and cons of distributed or centralized setup for your database load balancers.

MySQL Replication can be used as the database for Moodle implementations. In this blog we will show you how to deploy a highly available Moodle database using a master/slave MySQL setup.

In this blog post we discuss how to optimize one of MySQL’s most widely used storage engines - InnoDB - for high performance.

AWS, Google and Azure all provide public DBaaS services based on MySQL, but which of them is the best? This blog compares the features from each of the main cloud providers.