The alarm definitions feature eases the process of creating and managing alarms to monitor HeatWave MySQL DB Systems. It enables you to create Oracle-recommended alarms by making use of the standardized set of rules and thresholds, across multiple databases.

Codership, the makers of Galera Cluster, are pleased to announce the availability of Helm charts for Galera Cluster for MySQL 8.0.39. It is available on our GitHub releases page, for convenience. You are encouraged to send feature requests at our GitHub issues.

Helm charts help you manage your Kubernetes applications, to install and upgrade any Kubernetes applications; think of it as a package manager. Kubernetes helps you automate the deployment, management and scaling of containerized applications.

For this blog post, we will use the example of setting it up at DigitalOcean, but the setup is similar, whether you do this in a …

Introduction Guaranteeing the atomicity of database operations is critical for maintaining data integrity. While DDL operations for InnoDB tables have long been atomic and crash-safe, we recognized that DDL operations for schemas lacked the same level of robustness. Starting from MySQL Server 9.1 Community Edition, we have improved the atomicity of CREATE SCHEMA and DROP […]

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.

Introduction What is a rapid fire brute force attack? It is a trial-and-error approach used to obtain login passwords.  A hacker tries a multitude of username and passwords typically using code that tests a wide range of combinations until they find a login user and password combination that works. At that point the hacker is “in” […]

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.