Running Vitess and MySQL with ClusterControl
For all who are not familiar with Vitess, it is a MySQL-based database system that is intended to deliver an easy-to-scale, sharded, relational database management system. We will not get into details about the design...
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...
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...
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...
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...
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....
6 Critical Components of Successful Data Governance
Properly established data governance means that you can make faster and smarter decisions. It sounds simple, but it requires you to build a set of processes and a culture that respects certain key principles. If...
Integrating ClusterControl with SNMP : Part Two
This blog post is a continuation of the previous part 1, where we have covered the basics of SNMP integration with ClusterControl. In this blog post, we are going to focus on SNMP traps and...
Integrating ClusterControl with SNMP – A Proof of Concept : Part One
ClusterControl comes with a number of distinctive alerts (or alarms) which you won't find in other monitoring systems. ClusterControl understands a database cluster topology as a whole - all database nodes and the relation between...
Best Practices in Scaling Databases: Part Two
In the previous blog post, we have covered the basics of scaling - what it is, what are the types, what is a must-have if we want to scale. This blog post will focus on...