Understanding Indexes in MySQL: Part One
Indexes in MySQL are a very complex beast. We have covered MySQL indexes in the past, but we have never taken a deeper dive into them - we will do that in these series of...
Understanding MySQL’s New Heatwave
Data Analytics is important in any company as you can see what happened in the past to be able to make smart decisions or even predict future actions using the existing data. Analyze a huge...
Announcing CCX Database as a Service from Severalnines
We at Severalnines are thrilled to announce the release of CCX, our brand new database as a service (DBaaS) offering! It’s a fully managed service built atop the powerful ClusterControl automated operational database management...
Automating Security Audits for MySQL
Taking care of the security of your MySQL instances is a near-daily task of almost every MySQL DBA. Today, we will look into how you should go about automating security audits for MySQL. Why Automate...
Securing MySQL Backups: A Guide
If you’ve ever used MySQL, chances are you probably took backups of your database. If you took backups of your database, chances are you have at least once thought of how you could secure them....
Understanding Lock Granularity in MySQL
If you’ve been working with MySQL for some time, you have probably heard the terms “table-level locking” and “row-level locking”. These terms refer to the lock granularity in MySQL - in this blog we will...
MySQL Point in Time Recovery: How Does it Work?
If you have ever worked with MySQL, you have probably heard the term “Point-in-Time Recovery” or PITR for short. PITR enables you to restore a database up to a certain time that you can specify...
Tips and Trick using Audit Logging for MariaDB
MariaDB’s Audit Plugin provides auditing functionality for not only MariaDB but MySQL as well (as of, version 5.5.34 and 10.0.7) and Percona Server. MariaDB started including by default the Audit Plugin from versions 10.0.10 and...
Securing MySQL – Making Use of Data Access Privileges for a Secure Installation
MySQL installation security is something that should be on the mind of every MySQL DBA. While we have discussed how you should take care of your MySQL security as a whole (take a look at...
Utilizing mysqldump to Dump Specific MySQL Tables
mysqldump is often one of the primary recommendations when it comes to backing up your MySQL-related data. It’s a well-known tool in the MySQL world that helps you perform logical backups of your data. This...
Tips and Tricks for Implementing Database Role-Based Access Controls for MariaDB
In a database management system (DBMS), role-based access controls (RBAC), is a restriction on database resources based on a set of pre-defined groups of privileges and has become one of the main methods for advanced...
MySQL Backups and Indexes: a Guide
It’s not a secret that if you back up your MySQL data, you back up all of the data related to MySQL storage engines including the database schema, the data itself and also the indexes....