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...
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...
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...
Redis How To: Installation, setup and configuration
Twitter, GitHub, Pinterest, Snapchat, Craigslist, StackOverflow and Flickr just to name a few are the companies that are adopting Redis either for their storage or as a cache to boost performance. Redis is an in-memory...
Installing Redis Cluster (cluster mode enabled) with auto failover
Redis is an open-source in-memory datastore used as a database or cache. It has built-in replication and provides high availability via Redis Sentinel and automatic partitioning with Redis Cluster. In this blog, we will see...
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,...