(René Cannaò) One of the interesting features of ProxySQL is the support of query rewrite.
Tag: Open Source
InnoDB locks and transaction isolation level
(Sveta Smirnova) What is the difference between InnoDB locks and transaction isolation level? We’ll discuss it in this post.
Using VividCortex to Help Optimize MySQL Configuration
(Alex Slotnick) Many users new to MySQL will find themselves overwhelmed when tasked with configuring their system for best performance. It doesn’t need to be intimidating, however.
Scaling Percona XtraDB Cluster with ProxySQL in Kubernetes
(Vadim Tkachenko) How do you scale Percona XtraDB Cluster with ProxySQL in Kubernetes?
MySQL Workbench & Performance_Schema
(Frederic Descamps) Last week during the Oracle Users Group Leaders Summit in Bucharest I had the pleasure the meet the leaders for the MySQL Users Group from Azerbaijan, Finland, Madrid and the Netherlands.
Utilizing OpenStack Trove DBaaS for deployment management
(Ronald Bradford) Trove is used for self service provisioning and lifecycle management for relational and non-relational databases in an OpenStack cloud. Trove provides a RESTful API interface that is same regardless of the type of database.
Scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm
(Vadim Tkachenko) In this post, we’ll look at scaling Percona XtraDB Cluster with ProxySQL in Docker Swarm.
sync_binlog = 1 in MySQL 5.7
(Frederic Descamps) As Morgan announced it his blog post related to new defaults in 5.7, in 5.7.7 and newer the default value of sync_binlog is now 1.
MySQL 5.7: New Audit Log Filtering Feature – Part 1
(Marek Szymczak) Security auditing plays important role in the process of securing a database system. Thanks to the MySQL Enterprise Audit extension, we can record all activities, such as client connections and execution of queries into a single log file, for later inspection.
Restoring MySQL Database from xtrabackup – facepalm moments
(Kedar Vaijanapurkar) In this post we’ll see some facepalm moments during MySQL database restore from Percona Xtrabackup. I think: “To mistake is Homo-sapiens, to learn from them is Homo-sapiens-sapiens.”
