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....
Disaster Recovery for Galera Cluster Deployed to a Hybrid Cloud
Running a Galera Cluster in a hybrid cloud should consist of at least two different geographical sites, connecting hosts in the on-premises or private cloud with the ones in the public cloud. Whether you use...
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...
The DevOps Open-Source Database Audit Manual – Everything You Should Know
Auditing is the monitoring and recording of selected user database actions. It is typically used to investigate suspicious activity or monitor and gather data about specific database activities. For example, the database administrator can gather...
Database Security 101: Security in Open Source Databases
Data security is one of the most significant aspects of administering a database. Depending on the organizational structure, if you are managing the production database, you must monitor for unauthorized access and usage. This also...
Database Security 101: Understanding Database Access Privileges
Data is the new gold for big companies and organizations It's considered as the lifeblood of most modern businesses and there's a bonanza of opportunities to sell or to market to the large audience of...
MySQL 5.6 EOL Announcement
MySQL 5.6 has reached its EOL in February 2021, and we recommend that you start to plan migrating to MySQL 8.0. The latest version of MySQL is supported until April 2026 and keeps your database...
Driving Performance in a Hybrid Cloud Setup
A hybrid cloud refers to mixed computing, storage, and services environment made up of on-premises infrastructure, private cloud services, and a public cloud orchestration among the various platforms. Using a combination of public clouds, on-premises...
How to Encrypt Hybrid Cloud Database Traffic
A secure database environment is hard to achieve, but extremely important in order to avoid data breaches, ransomware and other malicious activity. Security of data is a top priority from a business standpoint. When running...
Hybrid Cloud vs Full Public Cloud – Pros & Cons
Technology consumers and users have embraced cloud computing ever since its boom. It implicates a very beneficial part nowadays to the technology on how humans use and interact with technology, especially the advent of IoT...
Deploy a Hybrid Cloud MySQL Database using ClusterControl
A hybrid cloud database is a mix of active hosts residing on both on-premises and cloud infrastructures, working as a single operational system. It helps implement a high availability environment, and since both database and...
Working with BLACKHOLEs in MySQL
If you have ever worked with MySQL, chances are you have stored your data inside of it. If you have ever stored data inside of it, chances are you have used one or more of...