(René Cannaò) Query routing is one of the core features of ProxySQL.
Tag: Open Source
MySQL InnoDB Cluster – What’s New in the GA Release
(Miguel Araujo) We carefully listened to the feedback we got from the last release candidate and incorporated some of the suggested changes. On top of that, we have fixed several bugs to reach the desired maturity state.
Another Hanging Query
(Kathy Forte) You are a DBA, enjoying a good read about the MySQL 8.0.1 development milestone release which contains CTEs. And, window functions are coming in 8.0.2.
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows
(Martin Hansson) MySQL 8.0.1 introduces two new features which allow you to better manage situations where you have tables with hot row contention.
ProxySQL Rules: Applying and Chaining the Rules
(Tibor Korocz) In this post, I am going to show you how you can minimize the performance impact of ProxySQL rules by using some finesse.
MySQL 8.0: Improved performance with CTE
(Øystein Grøvlen) MySQL 8.0 introduces Common Table Expressions (CTE). My colleague Guilhem has written several blog posts on how to use CTEs , and you can also read about it in the MySQL 8.0 Reference Manual. In this blog post, I will focus on how using a CTE instead of a view or a derived table ca
Replication filter per channel is now available in MySQL!
(Abdel-Mawla Gharieb) On the same day last year, I wrote a post about replication filters in MySQL Multi Source Replication and whether we can set the filters per replication channel or not (Bug #80843).
Network attacks on MySQL, Part 6: Loose ends
(Daniel van Eeden) After securing application-to-database and replication traffic, you should also do the same for backup traffic.
Correct Index Choices for Equality + LIKE Query Optimization
(marcos.albe) As part of our support services, we do a lot of query optimization. This is where most performance gains come from. Here’s an example of the work we do.
MySQL, MariaDB, International Components for Unicode
(Peter Gulutzan) In an earlier blog post I wrote “MySQL has far better support for character sets and collations than any other open-source DBMS, except sometimes MariaDB.”
