Planet MySQL HA Blog

In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote two posts on the subject, the links are below.  So far, I did not share what brought my attention to this, and it is the subject of this post.  Also, and because it is related, I come back to the optimization / contribution I already made on Jean-François Gagnéhttp://www.blogger.com/profile/12267071794432977020noreply@blogger.com0

Learn More »

Don’t have time to read Efficient MySQL Performance? Here’s the book (10 chapters) in one-liners.

Performance is query response time. Proper left-most indexing is required for performance. The less data, the better. Access patterns (part of the workload) help or hinder performance. Sharding is how to scale writes when single-node performance is truly reached. Server metrics reflect how the app workload causes MySQL to work. Replication lag is data loss. Locks are held until a transa

Learn More »

MySQL system variables configure the server's operation, and the SET statement is used to change system variable. The MySQL SET statements have various options for specifying changes to SYSTEM VARIABLE. It’s important to understand how these changes are reflected in current sessions (connections), later sessions, and after database server restarts.

Learn More »

Learn More »

WePay, the integrated payments arm of JPMorgan Chase, has taken significant strides to enhance its database infrastructure by upgrading to MySQL Enterprise Edition. For businesses looking to optimize their payment infrastructure, the journey of WePay serves as an insightful case study on leveraging advanced database solutions for maximum uptime and security.

Learn More »

MySQL 8.3 introduced a new JSON format for EXPLAIN reflecting how the execution plan actually is built, allowing for programmatic analysis of plans and executions.

Learn More »

We have documented streaming replication, and we have also mentioned how you can use streaming replication, and we also once did a webinar with recording on it, and we wrote a very in-depth blog post on how to use streaming replication to manage large transactions with Galera Cluster.

However, we had a question recently about streaming replication around the usage of wsrep_trx_fragment_unit and wsrep_trx_fragment_size (also, well documented).

So we have a usual 3-node Galera Cluster, and here is

Learn More »

How using SET ROLE can be used to define a “Least Privilege” model for accessing database objects based on a user’s current task.

Learn More »

For people to prepare for their travel to Belgium, we want to announce that the preFOSDEM fringe event known as the MySQL Belgian Days will take place the Thursday and Friday, January 30 and 31, before FOSDEM.

Learn More »

MySQL 8.4 introduces a new privilege, FLUSH_PRIVILEGES, which allows database users to execute FLUSH PRIVILEGES statement without the need of RELOAD privilege.

Learn More »