Introduced in MySQL Shell 8.0.21, the new MySQL Shell Dump and Load utilities has as its main goal to minimize the time needed to create and restore logical dumps of large data sets.
Through heavy parallelization and other techniques, we were able to reduce the time needed for these tasks by an order of magnitude compared to previous dump utilities.…
The MySQL team is proud to announce the general availability of version 8.0.21 of the MySQL Shell.
A new suite of logical dump utilities was introduced in MySQL Shell 8.0.21.
util.dumpInstance(), util.dumpSchemas() and util.loadDump()…
An important thing to know when managing an InnoDB cluster are the states that the cluster can be in, especially to know how to interpret the reported status of the cluster and specifically what to do to recover from failure various scenarios.…
Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL. From understanding concepts and technologies, to the tooling, specific commands and files to execute and edit, there’s a lot of things you need to know even when planning a test deployment (the Quick Start Guide for Group Replication should give you an idea).…
UPDATE: This post refers to the first labs release of InnoDB cluster. For the updated version for the latest release, please see the new Tutorial blog post
Traditionally, setting up high availability (HA) in MySQL has been a challenging task, especially for people without advanced knowledge of MySQL.…
The classic MySQL command line tool is how most users – developers and administrators – interact with a MySQL server. From administrative tasks to trying out queries, it wouldn’t be far-fetched to call it the face of MySQL.
With a new programming interface built into the MySQL Server, we need to properly support it at the client side in connectors, tools and of course, the command line client.…