Deploying MariaDB Sharding with Spider using ClusterControl
MariaDB offers built-in multi-host sharding capabilities with the Spider storage engine. Spider supports partitioning and XA transactions and allows remote tables of different MariaDB instances to be handled as if they were on the same...
Installing Redis Master-Slave with Sentinel for Auto Failover
In a previous blog, we already wrote on how to set up Redis Master-Slave replication with manual failover. The disadvantages of Redis Master-Slave architecture, as mentioned in a previous blog, refer to the ability to...
Installing Redis Master-Slave with Manual Failover
The use of in memory databases as a data structure layer for storing frequently accessed data is on the rise. Infrastructure built for high concurrent traffic typically use an in memory database layer to implement...
How to configure AppArmor for PostgreSQL and TimescaleDB
Security is a must for all systems to protect your data as much as possible. Even when there is always a risk to be hacked, by following a security checklist will reduce this risk significantly....
Backing Up Redis Clusters: A Guide
As we discussed in one of our previous blogs, backing up Redis is quite important to do, even if all we use Redis for is a cache for your application or the database. We have...
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...
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...
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...
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...
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....
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...