(Robert Agar) MySQL is one of the most popular and widely used database platforms in the world. If you are a DBA or database developer, there is a very high probability that at least some of the systems under your purview are powered by MySQL.
Tag: Open Source
MySQL Shell Plugins: check (part 3)
(Frederic Descamps) What is great with MySQL Shell Plugins, it’s that it provides you an infinite amount of possibilities. While I was writing the part I and part II of the check plugin, I realized I could extend it event more.
The dangers of replication filters in MySQL
(Federico Razzoli) MySQL supports what it calls replication filters. They allow to decide which tables are replicated, and which are not. They can be set on a slave to filter-in tables and databases: the slave will not replicate everything from the master, but only the specified databases and tables
MySQL Shell Plugins: check (part 2)
(Frederic Descamps) In the first part of this article related to the check plugin, we discovered information retrieved from the binary logs.
UUIDs are Popular, but Bad for Performance — Let’s Discuss
(Yves Trudeau) If you do a quick web search about UUIDs and MySQL, you’ll get a fair number of results. Here are just a few examples:
MySQL InnoDB Cluster 8.0 – A Complete Operation Walk-through: Part Two
(Ashraf Sharif) In the first part of this blog, we covered a deployment walkthrough of MySQL InnoDB Cluster with an example on how the applications can connect to the cluster via a dedicated read/write port.
MySQL Shell Plugins: check
(Frederic Descamps) As you may know, it’s now possible to create your own plugins for MySQL Shell. See the following posts:
Best Practice for Creating Indexes on your MySQL Tables – Rolling Index Builds
By having appropriate indexes on your MySQL tables, you can greatly enhance the performance of SELECT queries.
Installing MySQL with Docker
(Peter Zaitsev) I often need to install a certain version of MySQL, MariaDB, or Percona Server for MySQL to run some experiments, whether to check for behavior differences or to provide tested instructions.
MySQL: Check who’s trying to access data they should not
(Frederic Descamps) To illustrate how easy it’s to see who’s trying to access data they have not been granted for, we will first create a schema with two tables: