(Daniel Guzmán Burgos) The importance of having periodic backups is a given in Database life. There are different flavors: binary ones (Percona XtraBackup), binlog backups, disk snapshots (lvm, ebs, etc) and the classic ones: logical backups, the ones that you can take with tools like mysqldump, myd
Tag: Open Source
The all new MySQL InnoDB ReplicaSet
(Kenny Gryp) Following MySQL InnoDB Cluster as our first, fully integrated MySQL High Availability solution based on Group Replication, MySQL Shell 8.0.19 includes MySQL InnoDB ReplicaSet which delivers another complete solution, this time based on MySQL Replication.
MySQL – A Series of Bad Design Decisions
(Peter Zaitsev) MySQL obviously got many things right, otherwise, it would not be the World’s Most Popular Open Source Database (according to DB-Engines). Sometimes, however, I run into some decisions or behaviors which are just plain bad designs.
MySQL InnoDB Cluster Tutorial 3 ( Switching cluster mode and primary member )
(Sri Sakthivel Durai Pandian) So far, I have written two tutorial blogs about MySQL InnoDB Cluster . Those blogs describe about the InnoDB Cluster configuration and how to integrate InnoDB Cluster with the MySQL router .
Enable LDAP on Percona Monitoring and Management (PMM)
(Vinicius Grippa) Percona Monitoring and Management (PMM) has been on the road for a while now, and it brings exciting new features and improvements.
Indexing the MySQL Document Store
(Dave Stokes) I am writing a tutorial on the MySQL Document Store for the sold out (sorry) pre-FOSDEM MySQL days. For those who do not write such exercise they are often a difficult task as you have a limited time to convey information, need to provide vivid examples, and create exercises that give
How Securing MySQL with TCP Wrappers Can Cause an Outage
(Ananias Tsalouchidis) Securing MySQL is always a challenge. There are general best practices that can be followed for securing your installation, but the more complex setup you have the more likely you are to face some issues which can be difficult to troubleshoot.
Tips for Delivering MySQL Database Performance – Part Two
(Bart Oles) The management of database performance is an area that businesses when administrators often find themselves contributing more time to than they expected.
Data Masking in Percona Server for MySQL to Protect Sensitive Data
(Zsolt Parragi) Starting with Percona Server for MySQL 8.0.17, Percona Server ships with a data masking plugin, using the same API as the MySQL Enterprise Masking and De-identification feature.
Puzzled by MySQL Replication (War Story)
(Jean-François Gagné) Recently, I was puzzled by MySQL replication ! Some weird, but completely documented, behavior of replication had me scratching my head for hours. I am sharing this war story so you can avoid losing time like me (and also maybe avoid corrupting your data when restoring a back