(MC Brown) I’ve recently been trying to improve the performance of the Vertica replicator, particularly in the form of the of the new single schema replication. We’ve done a lot in the new Tungsten Replicator 5.3.0 release to improve (and ultimately support) the new single schema model.
Tag: Open Source
MySQL Enterprise Transparent Data Encryption (TDE) – provides at-rest encryption for physical InnoDB tablespace data files
(Tony Darnell) With MySQL version 5.7.11 and up, Oracle continues to improve MySQL’s security features by adding MySQL Enterprise Transparent Data Encryption (TDE) for InnoDB tables stored in innodb_file_per_table tablespaces. This feature provides at-rest encryption for physical tablespace data fil
Three client error messages that MySQL DBAs should know by heart to save time
(John Scott) Working in an operations environment means that you get a lot of questions. There’s the inevitable troubleshooting tasks that go along with being a DBA. This is designed to be a quick reference post, much like my more in depth post in 2016 about timeouts.
Thoughts on MySQL 8.0.3 RC – The First MySQL 8.0 Release Candidate
(Roel Van de Paar) On 21 September 2017, our upstream friends at Oracle released MySQL 8.0.3 RC as the first MySQL 8.0 Release Candidate.
MySQL 5.7 reads all your binlog files more often than you think
(Rick Pizzi) After upgrading some of our slaves to latest 5.7, I have found what looks like a serious regression introduced in MySQL 5.7.
Group Replication Features backported to MySQL 5.7
(Hemant Dangi) We have brought further enhancement to MySQL Group Replication 5.7 release by backporting some most requested features to MySQL 5.7.20 release:
Hands-On Look at ZFS with MySQL
(Yves Trudeau) This post is a hands-on look at ZFS with MySQL.
Ransomware Attacks Against MySQL and How to Avoid Them
(Rob Gravelle) One of the biggest news stories of 2017 on the MySQL front was unfortunately not a good one. In February, hundreds of MySQL databases were erased and replaced with a ransom demand for 0.2 bitcoin, or about $234 US dollars at the time.
How Scary is Enabling Semi-Sync Replication?
(Gavin Towey) Semi-sync Replication is a plugin available for mysql which allows you to create more durable replication topologies. For instance you can ensure that in the event of a master crash that at least one of your replicas has all transaction currently written to the master so that when you
MySQL 8.0: Query Optimizer Takes Data Buffering into Account
(Øystein Grøvlen) In earlier versions of MySQL, the query optimizer did not distinguish between data that was cached in the database buffer and data that had to be read from disk.