(Ashraf Sharif) ClusterControl is a great tool to deploy and manage databases clusters – if you are into MySQL, you can easily deploy clusters based on both traditional MySQL master-slave replication, Galera Cluster or MySQL NDB Cluster.
Tag: Open Source
MySQL 8.0: Listing Roles
(Frederic Descamps) As you may already know, MySQL 8.0 is coming with SQL Roles . I’ve already quoted them before in some posts (here and here). Giuseppe Maxia is doing a great job testing and promoting them (thank you for that!).
MySQL Security – Password Management
(Olivier Dssini) When thinking about security within a MySQL installation, you should consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.
MySQL 8.0 Histograms
(Frederic Descamps) Prior to MySQL 8.0, MySQL was missing a very well know feature in other RDBMS: optimizer histograms.
MySQL security for real users
(Giuseppe Maxia) One of Oracle’s tenets is the focus on security. For this reason, when it took over the stewardship of MySQL, it started addressing the most common issues. It was not quick acting, but we have seen real progress:
Failover for MySQL Replication (and others) – Should it be Automated?
(Vinay Joosery) Automatic failover for MySQL Replication has been subject to debate for many years.
Visualize This! MySQL Tools That Explain Queries
(Tate McDaniel) In this blog post, I want to go over some of the day-to-day MySQL tools and methods DBAs use to analyze queries and visualize “what is going on?” I won’t be going into the nitty-gritty details of each of these tools, I just want to introduce you to them and show you what they look li
New Defaults in MySQL 8.0
(Geir Hoydalsvik) MySQL 8.0 comes with improved defaults, aiming at the best out of the box experience possible. Here we describe the changes and why they are made.
MySQL 8.0 v/s MariaDB: Comparison of Database Roles
(Shree Nair) In our last blog, we had a look at MySQL 8 and mentioned new features available here. However, some of those features are already in MariaDB and have been for a while. We will here compare database roles in both server dialects.
MySQL Security – Password Validation Plugin
(Olivier Dasini) When thinking about security within a MySQL installation, you should consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.