(Jay Janssen) In this post, we’ll discuss how you can quick start MySQL testing using Docker, specifically in a Mac environment.
Tag: Open Source
Keyring framework
(Robert Golebiowski) Security these days is bigger than ever. This statement needs no proof. It seems like it is getting easier and easier to get access to ‘secure data’. As system grows it becomes really hard to secure all endpoints.
Query Rewrite plugin can harm performance
(Vadim Tkachenko) In this blog post, we’ll discuss how the Query Rewrite plugin can harm performance.
Oracle Linux 7, MySQL 5.7.12 and YUM for JSON Document Store Part 1
(Dave Stokes) Okay, I will admit that I grew up professionally without package management. Well, we did have SSCS and RCS under Unix and a lot of very brilliant shells scripts but nothing modern programmers would deign to touch.
Percona Server 5.7 parallel doublewrite
(Laurynas Biveinis and Alexey Stroganov) In this blog post, we’ll discuss the ins and outs of Percona Server 5.7 parallel doublewrite.
MySQL/MariaDB cursors and temp tables
(Federico Razzoli) In MariaDB and MySQL, cursors create a temporary table.
CPU governor performance
(Vadim Tkachenko) In this blog, we’ll examine how CPU governor performance affects MySQL.
How to delete rows in table when PK is referenced in another table
(Shahryar Ghazi) Before data insertion, updates, deletes etc, database management systems that support foreign keys (like MySQL) make sure you do not introduce any inconsistencies. So, you need to make sure you’re not leaving orphan records behind in child tables.
Percona Server 5.7: multi-threaded LRU flushing
(Laurynas Biveinis and Alexey Stroganov) In this blog post, we’ll discuss how to use multi-threaded LRU flushing to prevent bottlenecks in MySQL.
Lossless RBR for MySQL 8.0?
(Simon J Mudd) For MySQL 5.8 there was talk / suggestions about moving to minimal RBR as the default configuration (http://mysqlserverteam.com/planning-the-defaults-for-mysql-5-8/).
