ClickHouse scaling and sharding best practices
ClickHouse is a core engine for real-time analytics, powering critical functions like event ingestion, observability, customer analytics, and large-scale dashboards. However, scaling a ClickHouse cluster predictably while ensuring high availability, peak performance, and efficient resource...
Scaling with Elasticsearch: use cases
We scale database clusters for many reasons; primarily, we do so to spread the load amongst the cluster peers. Scaling can be done up or out. Scaling up is what is commonly also known as...
Hash Slot Resharding and Rebalancing for Redis Cluster
Redis Cluster with automatic partitioning uses a cool approach in organizing and storing the data, where the keys are stored in a hash slot and the keyspace is split into 16384 slots. Each master node...
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...
What is a Hybrid Cloud Database?
With the usage increase of the Cloud, Hybrid Cloud is a common architecture design in any company. This concept combines public cloud, private cloud, and on-premise solutions allowing companies to have flexibility on where to...
Challenges of Scaling the Moodle MySQL Database
Moodle, an open source Learning Management System, became more and more popular in last year as the pandemic forced hard lockdowns and majority of the education activities have moved from schools, colleges and universities to...
Challenges of Scaling the Moodle PostgreSQL Database
Moodle is the most popular learning management system (LMS), and it allows educators to create their own website with courses or content that extend learning. These kinds of platforms are getting more and more important to...
Boosting Performance by Using Read Write Splitting of Database Traffic with Moodle 3.9
Moodle is a very well known Learning Management System which is intended to help educational organizations organize their online learning activities. As you can imagine, given the online shift in 2020 caused by the COVID-19,...
The Easy Way to Deploy a MySQL Galera Cluster on AWS
ClusterControl 1.7.3 comes with a notable improvement in cloud integration. It is possible to deploy a MySQL and PostgreSQL replication cluster to the cloud, as well as automatically launch a cloud instance and scale out...
Scaling PostgreSQL for Large Amounts of Data
Nowadays, it’s common to see a large amount of data in a company’s database, but depending on the size, it could be hard to manage and the performance could be affected during high traffic if...
Scaling Your Time-Series Database – How to Simply Scale TimescaleDB
Scaling your TimescaleDB instance to a multi-node cluster can seem challenging, but with ClusterControl, it’s a straightforward process. In this blog, we’ll show you how to scale your single TimescaleDB instance into a multi-node cluster...
Migrating from Oracle Database to MariaDB – What You Should Know
Gartner predicts that by 2022, 50% of existing commercial databases will have been converted to open source databases. Even more, 70% of new in-house applications will be developed on an open source database platform (State...