MySQL Metups, Sep-Nov 2024

The article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin.

The post How to Restore a MySQL Database with Command Line or Restore Tools appeared first on Devart Blog.

In this article, we will address questions such as the purpose of query logging in MySQL, why it is important, how to enable and configure it, and more. You’ll find a detailed guide on how to use mysqldumpslow to analyze slow query logs, along with tips on harnessing convenient GUI tools like dbForge Studio for MySQL to your advantage.

The post How to Enable, Configure, and Use MySQL Query Logging appeared first on Devart Blog.

In this blog post, we will explore how network partitions impact group replication and the way it detects and responds to failures. In case you haven’t checked out my previous blog post about group replication recovery strategies, please have a look at them for some insight. Topology: [crayon-67f66f57d3f7c920418928/] Scenario 1: One of the GR nodes […]

There's nothing quite like delivering regular feature-packed updates to our dear users—and we've got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports.

The post Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1 appeared first on Devart Blog.

Using “failed login” policies, dbas can prevent brute force rapid fire attacks on MySQL user’s passwords. This uses a technique know as “login throttling”. This method affectively thwarts these “rapid fire” login attempt attacks by increasing delays for each failed attempt. These policies are simple and straightforward to put in place and define. Enabling defense and detection of rapid fire and other password attacks.

When it comes to MySQL databases, performance is everything. As more activities move online and data volumes grow exponentially, ensuring efficient data retrieval and query execution becomes crucial. Database indexing plays a significant role in this by providing powerful tools to optimize operations in MySQL. Without an index, MySQL must perform a full table scan, […]

If you’ve encountered the “Encryption can’t find master key” error while starting MySQL, you’re likely facing issues with the keyring plugin. I recently faced a similar issue on my server,…

The post Troubleshooting MySQL: Encryption can’t find Master Key first appeared on Change Is Inevitable.

Galera Cluster Enterprise Edition (EE) has had support for Non-Blocking Operations (NBO) schema upgradesever since the first release of Galera Cluster Enterprise Edition (EE). It is reasonably well documented, and we think more people will benefit from using it, of course. Schema changes tend to always remain a daunting task when you have large databases to manage.

To compare between Total Order Isolation (TOI), the default, with NBO that is available in Galera Cluster Enterprise Edition (EE), we create a test table:

CREATE TABLE large;
USE large;

CREATE TABLE test_table (
    id INT PRIMARY KEY AUTO_INCREMENT,
    data VARCHAR(255),
    num1 INT,
    num2 INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Then we …

MySQL is a widely used database management tool; however, as your application grows, maintaining optimal performance may become more challenging. 

Thankfully, ProxySQL provides many features that can help optimize MySQL performance and functions as a high-performance MySQL proxy. Let us understand the scope of improvement and how you can optimize MySQL performance using the powerful ProxySQL.

The Challenge of MySQL Performance

MySQL can face performance challenges under heavy load or complex query workloads. Conventional optimization techniques often reach their limits, necessitating additional strategies. Under such circumstances, ProxySQL can address these challenges and significantly enhance MySQL performance.   

ProxySQL is a high-performance open-source SQL proxy that organizations can use to optimize the MySQL database performance.

10 Ways ProxySQL Can Optimize …