Intro To Key-value Stores
When the internet gained popularity and relational databases could not cope with the tremendous variety of data types in the mid-1990s, non-relational databases or commonly referred to as NoSQL was developed and introduced by Carlo...
Upgrading to PostgreSQL13
In a recent blog about what is new in PostgreSQL 13, we reviewed some of the new features of this version, but now, let’s see how to upgrade to be able to take advantage of...
Digging Deeper into ClusterControl’s Performance Advisors
If you are a frequent reader of the Severalnines’ database blog, you have probably noticed that Severalnines’ crew talks about performance of databases pretty frequently. Part of that is because of ClusterControl - the flagship...
ACL using s9s CLI
Starting with ClusterControl 1.8.2, we have introduced new user management, permissions as well as access controls. From this version onwards, all of the features we mentioned earlier will be controlled by a set of Access...
ClusterControl – Advanced Backup Management – mariabackup Part II
In the previous part we have tested backup time and effectiveness of the compression for different backup compression levels and methods. In this blog we will continue our efforts and we will talk about more...
ClusterControl runtime configuration options
When you install ClusterControl, it has a default configuration that maybe doesn’t fit your requirements so probably you will need to customize this installation. For this, you can modify the configuration files, but you can...
ClusterControl – Advanced Backup Management – mariabackup Part I
ClusterControl can, among others, act as a great tool to help you design and execute the backup schedule. Numerous features are available including backup verification, transparent backup encryption and many others. What is quite commonly...
How to Configure PostgreSQL Sharding with ClusterControl
Sometimes it is hard to manage a large amount of data in a company, especially with the exponential increment of Data Analytics and IoT usage. Depending on the size, this amount of data could affect...
ClusterControl Alert Integration Using Webhooks
There is no doubt that monitoring and alerting is one of critical aspects for any application, especially for a mission-critical environment. From those alerts and notifications, one should be able to act or respond in...
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...
Importance of Append-only File in Redis
While looking around Redis data directory you may have noticed several files, among them a file with .aof extension. root@vagrant:~# ls -alh /var/lib/redis/ total 54M drwxr-x--- 2 redis redis 4.0K Jul 1 10:40 . drwxr-xr-x...