Planet MySQL HA Blog

The Planet MySQL HA Blog aggregates content from sources that cover topics related to high availability (HA) for MySQL databases.

Understanding InnoDB Tablespace Duplicate Check (MySQL Startup with Many Tables)

This post is a little long, please bear with me as after the intro, you can skip to the essential.In the last weeks / months, I have been working on understanding / improving MySQL startup with many tables.  I already wrote three posts on the subject, they are listed below.  In this post, I focus on describing the startup phase InnoDB Tablespace Duplicate Check (Duplicate Check for Jean-François Gagnéhttp://www.blogger.com/profile/12267071794432977020noreply@blogger.com0

Learn More »

Where can you find MySQL during December 2024 - February 2025

MySQL Conferences 12/24-2/25

Learn More »

Ensuring High Availability and Fault Tolerance for Business-Critical Workloads

11/18/2024 | Continuent

Introduction

In the current MySQL ecosystem, organizations must prioritize high availability and fault tolerance to ensure business continuity and to maintain customer trust. High availability solutions ensure that critical services and applications remain accessible, even during unexpected outages or system failures. While fault tolerance allows systems to continue functioning without error even when some components fail, minimizing downtime and ensuring reliable performance for its

Learn More »

Enhancing Security and Compliance in Financial Services with MySQL Enterprise Edition

This blog highlights how MySQL Enterprise Edition helps financial services companies enhance security and comply with regulations.

Learn More »

Galera Manager November 2024 Release

11/13/2024 | Galera Cluster

Codership is pleased to announce a new release of Galera Manager. The current installer stands at version 1.14.0 (you can check this by typing: ./gm-installer version which will report gm-installer version 1.14.0 (linux/amd64)) and the actual Galera Manager GUI is at version 1.8.7. Users will notice usability improvements, and fixes for issues filed at the galera-manager-support issue tracker. Note that the installer didn’t change, only the Galera Manager GUI for your MySQL monitoring got update

Learn More »

MySQL Replication Monitoring : Enhanced Features for the Enterprise Edition

The latest update to MySQL Enterprise edition, version 9.1, introduces significant enhancements focused on replication monitoring. This update includes improvements to Group Replication Flow Control and the replication applier, providing users with better visibility and control over their replication performance, leading to potential long-term cost savings by ensuring efficient usage of their machine resources.

Learn More »

BSE (Bombay Stock Exchange) Processes Billions of Transactions Daily with MySQL Enterprise Edition

BSE leverages MySQL Enterprise Edition for processing 150 million trades and 5 billion orders per day.

Learn More »

Boosting Profitability in Financial Services with MySQL

MySQL not only helps financial institutions bolster their profitability but also equips them to thrive in a rapidly changing market. Embracing MySQL is a strategic move for any financial services organization looking to secure its future in a digital-first world. Read the full blog.

Learn More »

Long and Silent / Stressful MySQL Startup with Many Tables

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 »

Efficient MySQL Performance In 10 Sentences

11/09/2024 | Hack MySQL

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 »

Pages