(Bernd Ocklin) MySQL NDB Cluster uses row level locks instead of a single shared commit lock in order to prevent inconsistency in simultaneous distributed transactions.
Tag: Open Source
How Not to do MySQL High Availability: Geographic Node Distribution with Galera-Based Replication Misuse
(Marco Tusa) Let’s talk about MySQL high availability (HA) and synchronous replication once more.
(Jean-François Gagné) This is Part #2 of the MySQL Master Replication Crash Safety series. In the previous post, we explored the consequence of reducing durability on masters with slaves using legacy file+position replication.
(Marco Tusa) In this article, we’ll look at an example of an on-premises, geographically distributed MySQL high availability solution.
(Dave Stokes) I love the new shell but the one thing I missed from the old shell was the ability to use a pager like more or less to throttle the output of the screen. Low and behold the engineers have added paging in MySQL Shell 8.0.13!!
(Jesper Krogh) MySQL Shell makes it easy to develop tools you can use for example to generate reports. In a previous blog, I showed how to use external modules in MySQL Shell.
(Frederic Descamps) Recently, I did some maintenance on Innotop and I merged several pull requests including one to support MySQL 8.0 (thank you yoku0825 for the contribution).
(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.
(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.
(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.