Implementing the golden backup rule for your databases
Data security is crucial in today’s world. Personally Identifiable Information (PII) is everywhere - emails, names, addresses, personal ID numbers and so on. There are regulations in place that organizations managing PII have to comply...
How to configure SELinux for MySQL-based systems (MySQL/MariaDB Replication + Galera)
In the era that we are living in now, anything with a less secure environment is easily a target for an attack and becomes a bounty for the attackers. Compared to the past 20 years,...
How to configure AppArmor for MySQL-based systems (MySQL/MariaDB Replication + Galera)
Last week, we discussed how to configure AppArmor for MongoDB Replica Sets which basically has the same concepts applicable when configuring this for your MySQL-based systems. Indeed, security is very important because you have to...
Deploying a Hybrid Infrastructure Environment for Percona XtraDB Cluster
A hybrid infrastructure environment is a mix of active hosts residing on both on-premises and cloud infrastructures in a single operational or distributed system. Percona XtraDB Cluster, one of the Galera Cluster variants, can be...
Deploying a Percona Server to a Hybrid Cloud
If you come across this question accompanied by doubts and scepticism, there's nothing different from the regular deployment. This is the fact, but the challenge awaits how the architecture is designed and how it can...
Tips for Storing Your Percona Backups in the Cloud
Percona has made a lot of great contributions in the open source world. One of the most downloaded software is their backup software for MySQL and for MongoDB. These softwares play a vital role for...
MongoDB Backup Management Tips for Sharded Clusters
Making proper backups of the database is a critical task. Besides setting the high availability architecture of your MongoDB for database services, you also need to have backups of your databases to ensure the availability...
How to Deploy Percona XtraDB Cluster 8 for High Availability
Percona XtraDB Cluster 8.0 is based on Percona Server for MySQL 8.0 embedded with Galera writeset replication API and Galera replication library, to form a highly available multi-master replication for MySQL-based database server. Percona XtraDB...
Monitoring Percona Server for MongoDB – Key Metrics
When running critical database services in production, we need to know and monitor the database. You need to understand the key metrics in the database that you are using. For example, when you run MongoDB...
A Look at the Percona Toolkit
The Percona Toolkit (PT Toolkit) was initially designed as a swiss army knife for MySQL/MariaDB/Percona Server and its underlying operating system to perform advanced database and system administration tasks that are hard to perform especially...
Monitoring Percona XtraDB Cluster – Key Metrics
Percona XtraDB Cluster is a very well known high availability solution in MySQL world. It is based on Galera Cluster and it does provide virtually synchronous replication across multiple nodes. As with every database, it...
An Overview of Percona Backup for MongoDB
The known and popular backup method for MongoDB is mongodump. It is a logical backup method, similar to mysqldump in MySQL or pg_dump in PostgreSQL database. There is another backup tool called Percona Backup for...