(Dave Stokes) Embedding Structured Query Language (SQL) within PHP, or other programming languages, has been problematic for some. Mixing two programming languages together is just plainly not aesthetically pleasing.
Tag: Open Source
Tips & Tricks – DevOps Database Glossary for the MySQL Novice
(Krzysztof Ksiazek) When you need to work with a database that you are not 100% familiar with, you can be overwhelmed by the hundreds of metrics available. Which ones are the most important? What should I monitor, and why?
Why Thread May Hang in “Waiting for table level lock” State – Part I
(Valeriy Kravchuk) Last time I had to use gdb to check what’s going on in MySQL server and found something useful with it to share in the blog post it was April 2017, and I miss this kind of experience already. So, today I decided to try it again in a hope to get some insights in cases when other […]
Group Replication – Extending Group Replication performance_schema tables
(jaideep.karande) In MySQL 8.0.2, users will see the additional columns in the existing Group Replication Performance Schema tables which will provide extended information about Group Replication.
Group-Replication, sweet & sour
(Marco Tusa) In the last few months we had 2 main actors in the the MySQL ecosystem, ProxySQL and Group-Replication (with the evolution to InnoDB Cluster).
Multi-Threaded Slave Statistics
(Juan Arruti) In this blog post, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
Protecting your data! Fail-safe enhancements to Group Replication.
(AnibalPinto) Group Replication has been around for some time now and the feedback from community is overwhelming. One of the suggestions (BUG#84795) received is related to deploying a mechanism to prevent a server from being updated after stopping group replication.
InnoDB Basics – Compaction: when and when not
(Jean-François Gagné) This is old news for MySQL/MariaDB expert but people that are starting using InnoDB do not always know that disk space is not automatically released when deleting data from a table. To explain and demonstrate that, I will take two real-world examples: table1 and table2.
How to extract change data events from MySQL to Kafka using Debezium
(Vlad Mihalcea) As previously explained, CDC (Change Data Capture) is one of the best ways to interconnect an OLTP database system with other systems like Data Warehouse, Caches, Spark or Hadoop.
MySQL 8.0.2 is out, some change is required to still use ProxySQL with GR
(Frederic Descamps) As you may know by now, MySQL 8.0.2 DMR is out ! o/
