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...
Tips for Monitoring PostgreSQL for Moodle
Moodle is a Learning Management System (LMS) designed to provide educators, administrators, and learners with a single robust, secure, and integrated system to create personalized learning environments. It supports different database technologies (e.g. MariaDB, MySQL,...
Automatic Failover of the Moodle PostgreSQL Database
One of the key aspects of high availability is the ability to quickly react to failures. It is not uncommon to manually manage databases, and have monitoring software keep an eye on database health. In...
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...
How to Audit a PostgreSQL Database
Auditing is a good way to keep your data as safe as possible, and to know what is happening in your databases. It is also required for many security regulations or standards, like PCI -...
Which Moodle Database Should You Use?
The open source, eLearning LMS Moodle has recently been getting a lot of attention due to the COVID-19 Pandemic. The strain on the resources as educators move their students to eLearning platforms has caused many...
How to Backup Google Cloud SQL for PostgreSQL and Restore on Your Own Server
Google Cloud SQL for PostgreSQL is a fully managed database service to create and manage PostgreSQL relational databases using a Google Cloud Console. Google Cloud for PostgreSQL gives you more time to spend on developing...
How to Deploy a Highly Available Canvas LMS with a PostgreSQL Database Cluster
In these pandemic times, Learning Management System (LMS) platforms are getting more and more important to allow you to continue learning remotely when the traditional education system just isn’t available anymore. Having an LMS platform...
Using the pt-pg-summary Percona Toolkit for PostgreSQL
The Percona Toolkit is a powerful, free, and open-source product developed by Percona. It is a collection of command-line tools that allow you to perform different MySQL, MongoDB, PostgreSQL, and system tasks that, in general,...
How to Deploy Percona Distribution for PostgreSQL for High Availability
High Availability is a requirement for many systems, no matter what technology you are using. This is especially important for databases, as they store data that applications rely upon. Depending on the requirements, there are...
How to Backup Your Amazon RDS for PostgreSQL Data and Restore on Your Own Server
Amazon Relational Database Service (Amazon RDS) is another service by Amazon, which allows you to deploy a scalable relational database in minutes in the cloud without the need to worry about infrastructure setup during the...
Monitoring Percona Distribution for PostgreSQL – Key Metrics
Monitoring is the base to know if your systems are working properly, and it allows you to fix or prevent any issue before affecting your business. Even in a robust technology like PostgreSQL, monitoring is...