How to Migrate Standalone Moodle to a Clustered Database Scalable Setup
Online Learning nowadays is quickly gaining traction since the COVID-19 pandemic happened. Most of the educational institutions are having to set up platforms for online learning, and pretty much all students are having to access...
Cluster-Wide Database Maintenance and Why You Need It
Undoubtedly, there is a long list of maintenance tasks that have to be performed by system administrators, especially when it comes to critical systems. Some of the tasks have to be performed at regular intervals,...
How to Improve Replication Performance in a MySQL or MariaDB Galera Cluster
In the comments section of one of our blogs a reader asked about the impact of wsrep_slave_threads on Galera Cluster’s I/O performance and scalability. At that time, we couldn’t easily answer that question and back...
Simple Scheduling of Maintenance Windows Across Your Database Clusters
Maintenance is something that an operation team can not avoid. Servers have to keep up with the latest software, hardware and technology to ensure systems are stable and running with the lowest risk possible, while...
Top PG Clustering High Availability Solutions for PostgreSQL
If your system relies on PostgreSQL and you are looking for clustering solutions for High Availability, we want to let you know in advance that it is a complex task but not impossible to achieve....
Manage and Automate Galera Cluster – Why ClusterControl
Galera Cluster by Codership is a synchronous multi-master replication technology which can be utilized to build highly available MySQL or MariaDB clusters. It has been downloaded over one million times since last year, establishing itself...
MySQL Replication and GTID-Based Failover – A Deep Dive Into Errant Transactions
For years, MySQL replication used to be based on binary log events - all a slave knew was the exact event and the exact position it just read from the master. Any single transaction from...
Database Cluster Management: Manual vs Automation
In a previous blog, we looked at the efficiency gains when automating the deployment of a Galera cluster for MySQL. In this post, we are going to dive into cluster management. Should we manage our...
Severalnines and WooServers Bring ClusterControl to Web Hosting
New partnership helps start-ups challenge Google, Amazon and Microsoft Stockholm, Sweden and anywhere else in the world - 07 September 2016 - Severalnines, the provider of database automation and management software for open source databases,...
Clustering MySQL Backend in OpenStack
OpenStack uses a database to store data for all OpenStack services such as compute nodes available, running instances, state and so on. The DB takes part in every user request, from listing all instances to...