Disaster Recovery Options for PostgreSQL Deployed to a Hybrid Cloud
In our previous Hybrid Cloud blogs, we often mention that one of the primary options of availing the Hybrid Cloud topology setup is to use this as your disaster recovery target. It's common for an...
Hybrid Cloud vs Full Public Cloud – Pros & Cons
Technology consumers and users have embraced cloud computing ever since its boom. It implicates a very beneficial part nowadays to the technology on how humans use and interact with technology, especially the advent of IoT...
Monitoring PostgreSQL in a Hybrid Environment
Hybrid Cloud is a recent concept that has been increased for a few years, and now is a common topology in any company for a Disaster Recovery Plan (DRP), or even to have redundancy on...
Hybrid Cloud PostgreSQL Deployment Tips
Hybrid Cloud is a common architecture design in any company. This concept combines public cloud, private cloud, and even on-premise solutions allowing companies to have flexibility on where to store and how to use their...
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) allowing educators to create their own website with courses or content that extend learning. These kinds of platforms are getting more and more important to allow...
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 -...
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,...