mysql

MySQL Shell AdminAPI – What’s new in 8.0.23? The MySQL Development Team is happy to announce a new 8.0 Maintenance Release of MySQL Shell AdminAPI – 8.0.23! In addition to several bug fixes and minor changes, some significant enhancements regarding monitoring/troubleshooting and performance were included. MySQL Shell AdminAPI Cluster diagnostics Checking how a Cluster is running and, whenever the cluster is not 100% healthy, perform troubleshooting tasks is certainly one of the main tasks of a DBA.… Facebook Twitter LinkedIn Source: MySQL Shell AdminAPI – What’s new in 8.0.23?

The MySQL 8.0.23 Maintenance Release is Generally Available The MySQL Development team is very happy to announce that MySQL 8.0.23 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.23 from dev.mysql.com or from the MySQL  Yum,  APT, or SUSE repositories.… Facebook Twitter LinkedIn Source: The MySQL 8.0.23 Maintenance Release is Generally Available

InnoDB Clone and page tracking First we will talk about some of the other internal users of the technology that underpins the InnoDB Clone. MySQL Enterprise Backup (MEB) is an enterprise offering that provides backup and recovery for MySQL. Among various types of backups available, the following two types are of interest to us: Full Backup – A backup that backs up the entire MySQL instance – all the tables in each MySQL database. … Facebook Twitter LinkedIn Source: InnoDB Clone and page tracking

InnoDB Data Locking – Part 2.5 “Locks” (Deeper dive) All together now Let’s now put together all that we’ve learned in InnoDB Data Locking – Part 2 “Locks” about table and record locks to understand following situation: mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM t FOR SHARE; +—-+ | id | +—-+ | 5 | | 10 | | 42 | +—-+ 3 rows in set (0.00 sec) mysql> DELETE FROM t WHERE id=10; Query OK, 1 row affected (0.00 sec) mysql> INSERT INTO t VALUES (4); Query OK, 1 row affected (0.00 sec) mysql> SELECT INDEX_NAME,LOCK_TYPE,LOCK_DATA,LOCK_MODE FROM performance_schema.data_locks … Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 2.5 “Locks” (Deeper dive)

Auditing Changes to Classified Data Stored in MySQL 8.0 The Challenge Often with sensitive information, you need to have an audit log. Frequently data such as this will contain a classification level as part of the row, defining policies for how it is handled, audited, etc. In a prior blog I discussed how to audit the selection of classified data. … Facebook Twitter LinkedIn Source: Auditing Changes to Classified Data Stored in MySQL 8.0