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...
Automating PostgreSQL Backups: A Guide
If you are a database administrator, chances are that you have backups of your data. And if you have backups of your data, chances are that you thought about how to automate your backup processes...
Announcing ClusterControl 1.8.2: Enhanced Security, Resource Utilization and Administration
We are pleased to announce the release of version 1.8.2 of Severalnines ClusterControl - the only management system you’ll ever need to deploy, monitor, and manage your open source databases. ClusterControl version 1.8.2 features new...
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...
MongoDB Backup Preparation
Backups are very crucial to any organization as they cushion against the complete loss of important data or information. In case of accidental data loss, it can easily be restored or recovered from the earlier...
How Database Automation Lowers The Total Cost of Ownership of Infrastructure Services
With the pandemic scorching the world for more than a year already, businesses are looking for a reduction in the cost of operating a business. In many cases, IT is one of the most expensive...
A Guide to Database Automation with Severalnines ClusterControl
Nowadays, database automation is a very hot topic. Database automation, simply speaking, refers to leveraging processes and tools to make administrative tasks for database developers and database administrators simpler. Why Database Automation? Database automation refers...
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...
Architecting for Security: A Guide for MySQL
Security is paramount today across the whole of IT. From time to time we hear about ransomware attacks or data leaks that have their origin in not secured databases or IT infrastructure. You may wonder:...
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....
Database Encryption: Why and Where You Need to Have Data Encryption
Database encryption provides enhanced security for your at-rest and in-transit data. Many organizations have started to look at data encryption seriously with recent security breach cases. In most cases, database servers are a common target...