#MySQL articles — Page 3

At Percona, we believe that transparency is key to improving our products. We are dedicated to creating top-of-the-line open-source database solutions and provi...

A multi-tenant database is a database that serves multiple clients, or tenants, who share the same database schema but have separate data sets. One way to achie...

At Percona, we operate on the premise that full transparency makes a product better. We strive to build the best open-source database products, but also to help...

For as long as I can remember, Innotop has been the go-to terminal tool for real-time MySQL monitoring. It is an invaluable addition to any DBA’s toolkit, but u...

This will be the third in my series of Percona Products on a Raspberry Pi. My previous posts:...

If you read - Using the JSON data type with MySQL 8 - Part I, you will see that inserting data into MySQL of JSON type is a very common and effective practice. ...

ProxySQL is a great load balancer which however suffers from some shortcomings concerning the management of MySQL users. ProxySQL provides a firewall which, in ...

MySQL 8.0.32 came out recently and had some important bugfixes contributed by Perconians. Here is a brief overview of the work done....

If you are a mobile app, frontend, backend, or game developer, you use data types such as string, numeric, or DateTime. You also know that since the advent of n...

Basic Usage mysqldump is a client utility that can be used for doing logical backups. It will generate the necessary SQL statements to reproduce the original da...

In this blog, we will explore databases on containers. We will use Docker as a container engine tool and Percona Server for MySQL as a database administration t...

If you need test data for the database of your project, you can get a dataset from Kaggle or use a data generator. In the first case, if you need to process the...

Percona’s XtraBackup is a beautiful tool that allows for the backup and restoration of MySQL databases....

Percona Toolkit + pt-table-checksum + pt-table-sync = Faster Replica Recovery Asynchronous replication with MySQL is a tried and true technology. Add the use of...

I am always surprised to learn something new whenever I talk to a member of the open-source community. No matter how much I think I have heard of every use case...