Codership is pleased to announce a new Generally Available (GA) release of the multi-master Galera Cluster for MySQL 8.0, consisting of MySQL-wsrep 8.0.39-26.20 (release notes, download), with Galera replication library 4.20 (release notes, download) implementing wsrep API version 26. This release incorporates all changes to MySQL 8.0.39, adding a synchronous option for your MySQL High Availability solutions.
In the Galera replication …
[Read more]The article provides a detailed guide on MySQL Command Line Client and shares useful tips on how to download, install, and get started with it. Read the tutorial to find out the best MySQL client on the market today.
The post MySQL CLI (Command-Line Interface): How to Get Started With MySQL Database Management appeared first on Devart Blog.
In previous posts, I talked about how we can use MySQL Shell to dump and load data using a multithreaded process and also how to export table data in different formats that can then be imported to a new MySQL instance. This post will discuss how we can copy data directly to another MySQL instance without performing separate dump and load operations. The […]
MySQL Shell offer many features to make life easier for DBAs and developers. In this post we discuss how we can copy data from one MySQL instance directly to another.
This article covers some of the most popular MySQL performance monitoring tools alongside the key performance metrics that can help improve and optimize query performance in MySQL databases.
The post MySQL Performance Monitoring Tools and the Most Important Metrics to Monitor appeared first on Devart Blog.
MySQL has a set of built-in functions for data processing, transformation, and analysis. In particular, the following discussion will be about string functions. So, let's find out what they are and when to use them.
The post MySQL String Functions in Action appeared first on Devart Blog.
FIDO2 WebAuthN is a modern, widely supported and increasingly useful standard getting us closer to The Passwordless Future. MySQL has supported multi-factor authentication (in the Enterprise Edition) since 8.0. And, as of 8.2, we added support for WebAuthN authentication. But the support was primarily geared towards using hardware based FIDO2 authenticator devices (e.g. Yubikeys). While […]
Regular expressions are powerful but often misunderstood tools developers have at their disposal. In this post we discuss how to use lookahead and lookbehind to match, but not return, a pattern.
Regular expressions are powerful but often misunderstood tools for developers. In recent posts, we have discussed subexpressions and back references (which are special types of subexpressions). This post will show examples of two other special subexpressions: look ahead and look behind. The Requirement Using the same data we have used in the past, we now have a requirement to […]
Vitess is a popular CNCF project that is used to scale some of the largest MySQL installations in the world — by companies like Slack, Square, Shopify, and GitHub. It provides sharding, connection pooling, and many other features that make it easy to scale MySQL horizontally. Vitess and MySQL are ideally suited for use as an Online Transaction Processing (OLTP) system — where the end-user interacts directly with the system and fast response times are essential as they get product and service information, generating critical business records such as orders, user profiles, and more.