mysql

MySQL Audit Data Consolidation – Made Simple In this blog, I am going to demonstrate how to create your own consolidated audit log archive across many mysql instances. In a followup I’ll show how to extend this example by creating a simple hash chain on that archive – so you can prove whether or not its been modified or tainted in any way and if so where.… Facebook Twitter LinkedIn Source: MySQL Audit Data Consolidation – Made Simple

What’s New in MySQL Shell 8.0.22 MySQL Shell 8.0.22 has just been released and is now available for download. In addition to bug fixes and minor changes described in the Release Notes, some more significant enhancements were also included. Dump and Load Utilities importTable: Custom Data Transformations The importTable utility now supports applying arbitrary data transformations to imported data.… Facebook Twitter LinkedIn Source: What’s New in MySQL Shell 8.0.22

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

InnoDB Data Locking – Part 2 “Locks” In InnoDB Data Locking – Part 1 “Introduction” we’ve described the difficulties Lock System tries to solve using metaphor of people trying to concurrently edit spreadsheets. While it might be useful metaphor to get some intuitions about the problem, to talk about solutions it helps to know at least a little about the “reality” this metaphor maps to.… Facebook Twitter LinkedIn Source: InnoDB Data Locking – Part 2 “Locks”

Auditing Selection of Classified Data 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. … Facebook Twitter LinkedIn Source: Auditing Selection of Classified Data