(Daniel Guzmán Burgos) One of the great things about Percona Monitoring and Management (PMM) is its flexibility. An example of that is how one can go beyond the exporters to collect data.
Tag: Open Source
HA for MySQL and MariaDB – Comparing Master-Master Replication to Galera Cluster
(Ashraf Sharif) Galera replication is relatively new if compared to MySQL replication, which is natively supported since MySQL v3.23. Although MySQL replication is designed for master-slave unidirectional replication, it can be configured as an active master-master setup with bidirectional replicati
Group Replication – Consistent Reads Deep Dive
(Nuno Carvalho) On previous posts about Group Replication consistency we:
How to Manage MySQL – for Oracle DBAs
(Bart Oles) Open source databases are quickly becoming mainstream, so migration from proprietary engines into open source engines is a kind of an industry trend now. It also means that we DBA’s often end up having multiple database backends to manage.
MySQL 8 Security Tips
(Rob Gravelle) If data security is not a top priority at your organization, it’s time to make it one. External regulations like PCI-DSS or HIPAA are being introduced to make companies’ data handling more secure, but there’s no reason to wait for regulations to force your hand.
MySQL 8.0 all new Error Logging
MySQL error log contains diagnostics messages such as errors, warnings and notes that occur during MySQL startup, shutdown and while the server is running.
TTL – Perfect Accuracy by using an insertable VIEW
(Mario Beck) One more comment regarding TTL in MySQL:
MySQL and PHP Basics Part I
(Dave Stokes) I have had some requests to write some blogs on the basics of using PHP and MySQL together. This will not be a series for the experienced as it will start at a level where I will go into a lot of details but expect very few prerequisites from the reader. If this is not you, please mo
TTL – Time-to-Live in MySQL
(Mario Beck) A customer recently asked for a TTL feature in MySQL. The idea is to automatically delete rows from a certain table after a defined lifespan, e.g. 60 seconds.
MySQL: IS NULL conditions and indexes
(Federico Razzoli) It is not uncommon for an application to use WHERE conditions like this: