Categories
Products
Technologies
Top Rated docs

October 27, 2020

How to Backup your Dockerized WordPress Data using Named Volumes vs Backup Ninja

With containers, there are a couple of ways that you can backup and restore your data. The most typical way to do data backups for databases in container environments is by creating database dumps. Unlike...

October 22, 2020

Migrating Amazon RDS (MySQL or MariaDB) to an On-Prem Server

Amazon Web Services is a technology giant, especially when it comes to pioneering itself in top-of-the-line cloud computing services. Its fully managed services products (Amazon RDS) is one of a kind. But then again, while...

October 20, 2020

Top Open Source Tools for MySQL & MariaDB Migrations

Large organizations that are using MySQL or MariaDB database platforms are often faced with a need to perform a database migration from one place to another. Regardless of the platform, type of database software (such...

October 19, 2020

Live Migrations Using MySQL Replication

Migrating your database to a new datacenter can be a high-risk and time-consuming process. A database contains state, and can be much harder to migrate as compared to web servers, queues or cache servers. In...

October 14, 2020

Tips for Upgrading Percona XtraDB Cluster to 8.0

MySQL 8.0 has been available for a while and Percona XtraDB Cluster 8.0 has also been available for some time as well. Also, MySQL 5.6 is coming up to its End-of-Life and people using PXC...

October 13, 2020

How to Perform Rolling Upgrades for MySQL

There are different reasons for upgrading your databases. It could be to apply security fixes, to use new features, solve compatibility issues, or just to keep your system up-to-date. This upgrade can be a major...

October 12, 2020

How to Perform an Online Upgrade of Percona XtraDB Cluster to Percona XtraDB Cluster 8.0

Percona XtraDB Cluster based on MySQL 8.0 has been out there for some time, so it’s not surprising more and more people are attempting to migrate into it. You may wonder how to approach this...

October 5, 2020

Tips for Upgrading to from MySQL 5.7 to MySQL 8

MySQL 8.0 has been with us already for quite some time and many MySQL users have already upgraded to this version. For those who are still using older MySQL versions, we would like to present...

September 24, 2020

Understanding the HAProxy Statistics for MySQL & PostgreSQL

Having a Load Balancer is always a good option to improve your database environment. It can help you on redirect applications to available database nodes, distribute the traffic across multiple servers to improve performance, or...

September 21, 2020

Connection Handling & Throttling with ProxySQL

The ability to shape the traffic that goes to the database is one of the most important ones. In the past days you had not that much control over it - applications sent the traffic...

September 18, 2020

A Guide to MySQL Indexes

When MySQL query optimization is mentioned, indexes are one of the first things that get covered. Today, we will try to see why they are so important. What are Indexes? In general, an index is...

September 2, 2020

Building a Highly Available Database for Moodle Using MySQL Replication

Moodle is an open source learning management system, widely used by schools and universities around the world. The project started in 2002 by Martin Dougiamas, with the aim to provide learners, teachers, educators a secure,...

Subscribe below to be notified of fresh posts