Hybrid Cloud Replication for MySQL for High Availability
Hybrid environments, where a part of the database infrastructure is located on-prem and some of it is located in a public cloud are not uncommon. There may be different reasons to use such setup -...
How to Backup Your Moodle Database
Moodle is a popular learning management tool created for educators to build and manage online learning easily. The tool aims to provide a robust, secure, and integrated system to efficiently manage online education for educators...
Deploying a Percona Server to a Hybrid Cloud
If you come across this question accompanied by doubts and scepticism, there's nothing different from the regular deployment. This is the fact, but the challenge awaits how the architecture is designed and how it can...
How do You Restore MySQL Databases From Physical Files?
Open Restoring MyISAM configuration optionsIf you have taken a physical backup of your database and have a need to restore it, you have probably wondered how. This blog post should provide you with some insight...
How to Backup Your Chamilo LMS MySQL Database
Backup is the process of creating and storing copies of data that can be used to protect organizations against data loss. Chamilo LMS relies on MySQL or MariaDB as a database, so it is important...
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...
Best Practices for MySQL Backups
If you’re working with MySQL and you want to use some best practices, there are a lot of options you can focus on. Aside from performance tuning, engine and query optimization and replication configuration, you...
How to Deploy the Chamilo MySQL Database for High Availability
Chamilo is, just like Open edX or Moodle, a platform that allows educational institutions to transfer their educational activities to the internet. Given that the majority of the educational activity has moved online in the...
How to Automatically Manage Failover of the MySQL Database for Moodle
In our previous blogs, we made justification for why you need a database failover and have explained how a failover mechanism works. I’m sharing this in case you have questions on why you should set...
How to Benchmark Performance of Moodle
Moodle, the world's most popular learning management system (LMS), is commonly being deployed in a rapidly growing and large scale environment. Fortunately, Moodle is built with availability and scalability in mind, with lots of tools,...
How to Setup Automatic Failover for the Moodle MySQL Database
In a previous blog, we had discussed how to migrate a standalone Moodle setup to scalable setup based on a clustered database. The next step you will need to think about is the failover mechanism...
How to Backup Your Moodle MySQL Database
Data is an essential part of running a Moodle environment. Should the IT operations team lose data accidentally, then it could lead to a huge loss. So, to protect valuable information, sysadmins need to back...