Categories
Products
Technologies
Top Rated docs

June 28, 2021

Using Sysbench to Generate Test Data for Sharded Table in MySQL

Sysbench is a great tool to generate test data and perform MySQL OLTP benchmarks. Commonly, one would do a prepare-run-cleanup cycle when performing benchmark using Sysbench. By default, the table generated by Sysbench is a...

June 24, 2021

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,...

June 23, 2021

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...

June 22, 2021

How to configure SELinux for PostgreSQL and TimescaleDB

Data is the most important asset in a company, so you should take all the security considerations into account in your database to keep it as safe as possible. One important security feature on RedHat-based...

June 21, 2021

Redis High Availability Architecture with Sentinel

Redis Sentinel is a dedicated process to automate and simplify the Redis replication failover and switchover. Without Sentinel, you could also manage your Redis replication manually, by using the SLAVEOF or REPLICAOF command. Sentinel requires...

June 16, 2021

PostgreSQL Replication Best Practices – Part 2

In the first part of this blog, we mentioned some important concepts related to a good PostgreSQL replication environment. Now, let’s see how to combine all these things together in an easy way using ClusterControl....

June 15, 2021

CMON High Availability and Failover

High availability is a must these days and ClusterControl performs a key role in ensuring that your database clusters will stay up and running. On the other hand, how can we ensure that ClusterControl itself...

June 14, 2021

Advanced Failover Using Post/pre Script Hooks

The Importance of Failover Failover is one of the most important database practices for database governance. It’s useful not only when managing large databases in production, but also if you want to be sure that...

June 11, 2021

Dealing With MySQL Replication Issues Using ClusterControl

One of the most popular ways in achieving high availability for MySQL is replication. Replication has been around for many years, and became much more stable with the introduction of GTIDs. But even with these...

June 9, 2021

Keeping Databases Up and Running in an Outage or Slowdown

Once you see that your database environment has issues, you are in trouble. Maybe one of your replicas is out or maybe you are experiencing a significant increase in the load across your databases that...

June 4, 2021

Managing Multiple Database Technologies with ClusterControl

Managing multiple open source database technologies in any environment can be a daunting task, especially if you have fewer resources. The scenario could be worse if deployment, monitoring, and other database management tasks are done manually....

June 3, 2021

Using PgBouncer Connection Pooler for PostgreSQL with ClusterControl 1.8.2

Modern apps like microservices typically require a lot of database connections, they also use and release those connections very quickly. When PostgreSQL was developed almost 25 years ago, its developers decided not to use threads...

Subscribe below to be notified of fresh posts