Planet MySQL HA Blog
Lessons From 20 Years Hacking MySQL (Part 2)
A relational database is more than a data bank, it’s a profound philosophical expression. This is the second and final part of “Lessons From 20 Years Hacking MySQL”.
Trusting mysqldump and Insecure MySQL Client Lead to Remote Code Execution
Sakila, Where Are You Going?
This article is in large part the same of what I have published in the Percona blog. However I am reproposing it here given it is the first some other benchmarking exercise that I am probably going to present here in an extended format, while it may be more concise in other platforms.
In any case why this tests.
I am curious, and I do not like (at all) what is happening around MySQL and MariaDB, never like it, but now is really think is time to end this negative trend, that is killin
Galera Cluster works on Oracle Linux
We recently had a customer request to run Galera Cluster on Oracle Linux. We are pleased to tell you that you can use the Red Hat Enterprise Linux 8 or Red Hat Enterprise Linux 9 repositories: for the latest Galera Cluster with MySQL 8 and the wsrep library.
It is worth noting that while it is difficult to find an Oracle Linux image in many cloud providers, there is Oracle Cloud that offers Oracle Linux as a default. However, remember that if you are using Oracle Cloud, you still have to configu
RFC: Database / Schema in the Slow Query Log File
Let's take a look at Percona Everest 1.0.0 RC
Managing MySQL Shell Configuration Options
Why is My Java Application Freezing Under Heavy I/O Load?
The Question
Recently, a customer asked us:
Why would heavy disk IO cause the Tungsten Manager and not MySQL to be starved of resources?
For example, we saw the following in the Manager log file tmsvc.log:
2019/06/03 00:50:30 | Pinging the JVM took 29 seconds to respond. 2019/06/03 00:50:30 | Pinging the JVM took 25 seconds to respond. 2019/06/03 00:50:30 | Pinging the JVM took 21 seconds to respond. 2019/06/03 00:50:30 | Pinging the JVMMySQL Connection Status with MySQL Shell
Configuring the Tungsten Connector for PCI Compliance
Summary
It is always a good idea to be mindful of open ports on your hosts, since they can be used by bad actors to gain access to your systems.
For this reason, it is often desirable to prevent outside connections to the port whenever possible to prevent intrusions.
For security purposes (and possibly PCI compliance), the Tungsten Connector proxy has the ability to bind to localhost/127.0.0.1 instead of listening on all available IP addresses via 0.0.0.0.
The Quest