(Jesper Krogh) The other day, I was reading a blog by Magnus Hagander about tracking foreign keys throughout a schema in PostgreSQL. I thought it was a good idea, so I decided to look at how you can track foreign key in MySQL.
Tag: Open Source
A Tale of Two JSON Implementations – MySQL and MariaDB
(Dave Stokes) JSON has proven to be a very import data format with immense popularity. A good part of my time for the last two or so years has been dedicated to this area and I even wrote a book on the subject.
MySQL Replication Data Recovery using ‘mysqlbinlog’ – Part II
(Ivan Ma) The previous post (PART-I) http://mysqlhk.blogspot.com/2018/10/mysql-replication-recovery-from-binlog.html It describes the Replication Recovery from binlog by using those binlog files to be treated as Relay Log.
Data Masking in MySQL
(Ivan Švaljek) If you’re here, that probably means you’re about to acquire some sensitive data to take care of. Or that you’ve already acquired it and are protecting it, and you want to see how MySQL Enterprise Data Masking and De-Identification features can help you do it in an easier, better and m
Common Table Expressions: A Shocking Difference Between MySQL and MariaDB
(Dave Stokes) Common Table Expressions (CTEs) are a very useful tool and frankly a big improvement on sub-queries. But there are differences in how they are implemented in MySQL and MariaDB.
Temporary tables are now allowed in transactions when GTIDs are enabled
(Daogang Qu) There has been a recurring request from our users to remove a limit when using global transaction identifiers (GTIDs) and temporary tables together.
How to Quickly Add a Node to an InnoDB Cluster or Group Replication
(Przemys³aw Malkowski) In this blog, we’ll look at how to quickly add a node to an InnoDB Cluster or Group Replication using Percona XtraBackup.
Using Django with MySQL 8
(Jesper Krogh) A framework can be a great way to allow you to spend more time on the actual application or web site and less time on standard tasks. It can also greatly reduce the amount of custom code needed.
Extending replication instrumentation: account for memory used in XCom
(André Negrão) Version 8.0.12 added many great new features to MySQL. One of the new features included is the memory instrumentation of the XCom cache, which allows users to view and monitor the memory utilization of the cache by querying Performance Schema (PS).
Maintenance Windows in the Cloud
(Tibor Korocz) Recently, I’ve been working with a customer to evaluate the different cloud solutions for MySQL.