MySQL is an extremely popular open-source RDMS, and it is widely used by millions of companies and professionals. In this article, you will learn how to check the current MySQL version, and how to update it if necessary.
The post How to Check MySQL Version appeared first on Devart Blog.
By now you must have read our documentation on isolation levels and also our Support for Transaction Isolation Levels. It is worth noting that the default transaction isolation level in MySQL 8 is REPEATABLE READ.
Here is a simple example of this, in action (you can test this on two different nodes, even across a 9-node Galera Cluster!).
First we do some simple setup:
CREATE DATABASE isolate;
USE isolate;
CREATE TABLE products (
id INT PRIMARY KEY,
name VARCHAR(50),
price DECIMAL(10, 2)
);
Then we insert some initial data:
INSERT INTO products (id, name, …[Read more]
The aim of this long article is to give you the instructions and tools to migrate your production database, from your current environment to a solution based on Percona Everest (MySQL).
Nice, you decided to test Percona Everest, and you found that it is the tool you were looking for to manage your private DBaaS. For sure the easiest part will be to run new environments to get better understanding and experience on how the solution works. However, the day when you will look to migrate your existing environments will come. What should you do?
Prepare a plan! In which the first step is to understand your current environment.
When I say understand the current environment, I mean that you need to have a clear understanding of:
The aim of this long article is to give you the instructions and tools to migrate your production database, from your current environment to a solution based on Percona Everest (MySQL).
Nice, you decided to test Percona Everest, and you found that it is the tool you were looking for to manage your private DBaaS. For sure the easiest part will be to run new environments to get better understanding and experience on how the solution works. However, the day when you will look to migrate your existing environments will come. What should you do?
Prepare a plan! In which the first step is to understand your current environment.
When I say understand the current environment, I mean that you need to have a clear understanding of:
Well, that is more a catchy headline, than the reality: XA transactions work in your Galera Cluster Enterprise Edition (EE). This has been supported since our very first release with 8.0.28 Enterprise, right up till now, in 8.0.39 Enterprise. If you try to run an XA transaction in your regular Galera Cluster you’ll be given an error as such:
mysql> XA START 'xatest'; ERROR 1235 (42000): This version of MySQL doesn't yet support 'XA with wsrep replication plugin'
However, with Galera Cluster Enterprise Edition (EE), XA transactions, “just work”. What is an XA transaction, you might ask? An XA transaction is a distributed transaction …
[Read more]Codership is pleased to announce a new beta preview release of the multi-master Galera Cluster for MySQL 8.4, consisting of MySQL-wsrep 8.4.2-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.4.2, adding a synchronous option for your MySQL High Availability solutions.
One will notice that MySQL-wsrep 8.4.2-26.20 uses …
[Read more]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]
How do you run non-blocking schema changes in MySQL? This is an
eternal question. With a plethora of 3rd party solutions and with
recent advancements in MySQL, it's difficult to track which
solution is preferable for a given schema migration. In this
post, we provide a high level overview of the state of MySQL
online schema migrations in 2024. We limit the discussion to
ALTER TABLE statements, as other DDL statements are
typically fast (DROP TABLE is somewhat of
an exception, but out of scope of this post).
We'll first examine the native MySQL options:
INPLACE and INSTANT. For reference, see
Online DDL Operations MySQL 8.0 documentation.
…
[Read more]On July 1st, 3 new releases of MySQL came out. Indeed, we released the next 8.0 (8.0.38), the first update of the 8.4 LTS (8.4.1), and the very first 9.0 as Innovation Release. We now support 3 versions of the most popular Open Source database. With these releases, we also want to thank all the […]
On July 1st, 3 new releases of MySQL came out. Indeed, we released the next 8.0 (8.0.38), the first update of the 8.4 LTS (8.4.1), and the very first 9.0 as Innovation Release. We now support 3 versions of the most popular Open Source database.
With these releases, we also want to thank all the great contributors who send patches to MySQL.
For some time now, all the contributors have also been highlighted in the Release Notes, but we never thank enough, so let’s take back the good habits of listing them in a dedicated blog post.
Some contributions were merged into multiple versions. Let’s have a look at all these contributions:
…
[Read more]