Auditing Selection of Classified Data
1 day ago, mysql

The Challenge Often with sensitive information, you need to have an audit log. Not just that a table had a select run, but that specific cells within the table were accessed.  Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc.…...

Auditing Selection of Classified Data Stored in MySQL 8.0
1 day ago, mysql

The Challenge Often with sensitive information, you need to have an audit log. Not just that a table had a select run, but that specific cells within the table were accessed.  Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc.…...

InnoDB Data Locking – Part 1 “Introduction”
2 weeks ago, mysql

In this blog series, I’d like to introduce you gently to the topic on which I was working last 2 years, which is improving how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, while in reality there is a lot of concurrency.…...

MySQL Shell Dump & Load part 4: Dump Instance & Schemas
1 month ago, mysql

MySQL Shell 8.0.21 comes with two utilities which can be used to perform logical dumps of all the schemas from an instance (util.dumpInstance()) or selected schemas (util.dumpSchemas()). These tools offer major performance improvements over the mysqldump utility, some of our benchmarks show a throughput up to 3GB/s!…...

New Consistency for Datafile Locations in MySQL 8.0.21
1 month ago, mysql

When you create a general tablespace in MySQL 8.0, you can choose the directory where the associated datafile is created. CREATE TABLESPACE tablespace_name ADD DATAFILE ‘/my/table/space/dir’; However, that directory must be known to InnoDB. Known directories are defined by the following settings: datadir,  innodb_data_home_dir,  innodb_undo_directory  &  innodb_directories.…...

Improvements to Undo Truncation in MySQL 8.0.21
1 month ago, mysql

Undo Tablespaces can be truncated either implicitly or explicitly in MySQL 8.0. Both methods use the same mechanism. This mechanism could cause periodic stalls on very busy systems while an undo tablespace truncate completes. This problem has been fixed in MySQL 8.0.21.…...

MySQL Shell Dump & Load part 2: Benchmarks
1 month ago, mysql

This is part 2 of the blog post series about MySQL Shell Dump & Load: MySQL Shell Dump & Load part 1: Demo! This second part about the new MySQL Shell Dump & Load utilities aims to demonstrate the performance while also comparing it with various other logical dump and load tools available: mysqldump, mysqlpump & mydumper.…...

MySQL Shell Dump & Load part 1: Demo!
1 month ago, mysql

MySQL Shell 8.0.21 includes some exciting new utilities to create a logical dump and do a logical restore, with a focus on ease of use, performance and integration. In MySQL Shell 8.0.17, we already introduced a multi-threaded CSV import utility util.importTable()…...

MySQL Shell Dump & Load part 3: Load Dump
1 month ago, mysql

This is part 3 of the blog post series about MySQL Shell Dump & Load: MySQL Shell Dump & Load part 1: Demo! MySQL Shell Dump & Load part 2: Benchmarks 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.…...

What’s New in MySQL Shell 8.0.21
2 months ago, mysql

The MySQL team is proud to announce the general availability of version 8.0.21 of the MySQL Shell. MySQL Shell Logical Dump and Load Utilities A new suite of logical dump utilities was introduced in MySQL Shell 8.0.21. util.dumpInstance(), util.dumpSchemas() and util.loadDump()…...

Hiding instances on MySQL InnoDB Cluster/ReplicaSet
2 months ago, mysql

MySQL Router is a core component of InnoDB Cluster/ReplicaSet that enables the automatic routing of client traffic to the right instances of your database architecture. Router can automatically adapt to topology changes, however, there are some scenarios on which one would certainly benefit from having the possibility to tag an instance with a certain attribute that indicates a specific behavior change to Router’s default behavior.…...

Hiding instances on MySQL InnoDB cluster/ReplicaSet
2 months ago, mysql

MySQL Router is a core component of InnoDB cluster/ReplicaSet that enables the automatic routing of client traffic to the right instances of your database architecture. Router can automatically adapt to topology changes, however, there are some scenarios on which one would certainly benefit from having the possibility to tag an instance with a certain attribute that indicates a specific behavior change to Router’s default behavior.…...

MySQL Shell AdminAPI – What’s new in 8.0.21?
2 months ago, mysql

The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.21! As always, we have listened to the growing community of users and introduced a very useful feature for any production deployment of MySQL InnoDB cluster or ReplicaSet.…...

The MySQL 8.0.21 Maintenance Release is Generally Available
2 months ago, mysql

The MySQL Development team is very happy to announce that MySQL 8.0.21 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.21 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories.…...

A Tale of Two Password Authentication Plugins…
3 months ago, mysql

A long long time ago (in a galaxy far away… cue the music!) MySQL added support for an authentication plugin which is now known as mysql_native_password. The mysql_native_password plugin uses SHA1 hash to Store the password(SHA1(SHA1(password)) in mysql.user table Authenticate user One of the good traits of this plugin is that it allows authentication using challenge-response mechanism which made it possible to verify identity of the client on an unencrypted channel without having a need to se...

MySQL Shell 8.0.20 – What’s New?
4 months ago, mysql

The MySQL Development team is proud to announce version 8.0.20 of the MySQL Shell, with the following features: Admin API Improvements on the admin account handling for MySQL InnoDB cluster and MySQL InnoDB ReplicaSet as well as for MySQL Router Command line integration for MySQL InnoDB ReplicaSet Isolation of InnoDB ReplicaSet operations Connection compression options.…...

MySQL Shell AdminAPI – What’s new in 8.0.20?
4 months ago, mysql

The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.20! Following the previous exciting release, on which InnoDB ReplicaSet was introduced, we focused on improving the management of ReplicaSets but also, most importantly, InnoDB cluster.…...

The MySQL 8.0.20 Maintenance Release is Generally Available
4 months ago, mysql

The MySQL Development team is very happy to announce that MySQL 8.0.20 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release.  Please download 8.0.20 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories.…...

Using a MySQL Keyring SECRET and Asymmetric Encryption
5 months ago, mysql

For an encrypt only or decrypt/encrypt applications The following is an example of how to allow applications to asymmetrically encrypt data using a public key. In MySQL 8.0.19 support for the SECRET datatype was added to our Keyring technology. With this technology, users can securely manage their own keys using: Oasis KMIP protocol implementations: Oracle Key Vault Gemalto KeySecure Thales Vormetric Key Management Server Fornetix Key Orchestration New!…...

Controlling table encryption in MySQL 8.0
6 months ago, mysql

MySQL 5.7.11 introduced InnoDB transparent tablespace encryption, which enabled support for file-per-table tablespaces, and this feature is discussed in this blog. Later in MySQL 8.0.13, encryption for general tablespace  was introduced. To improve usability of encryption handling, MySQL 8.0.16 added several features to enable, disable and enforce table encryption for tables within a schema, general tablespace or entire MySQL system.…...

Next