Autoscaling Moodle stack for Postgres and MySQL databases
This work is mostly based on Paulo Teixeira’s work. It adds several configurable features and switches to a web stack with caching. It also uses Azure resources for Redis, ObjectFS and Databases.
After deploying, these templates will provide you with a new Moodle site with caching for speed and scaling frontends to handle PHP load. The filesystem behind it is mirrored for high availability and optionally backed up through Azure. Filesystem permissions and options have also been tuned to make Moodle more secure than a default install.
In this article, you will learn how to install the latest version of the Moodle Learning Platform with NGINX and MySQL/MariaDB database on CentOS 8 .
Source: How to Install Moodle Learning Platform with Nginx in CentOS 8
Freezer is a tool to help developers discover which database records are created by some application’s action and which tables received these new records because that action.
It makes much easier to spot these tables and its new records, understand how the third-party application interacts with the database and also how relationships are made.
Source: llagerlof/freezer: Freezer is a tool to help developers to discover which database’s records are inserted by other programs.
BigBlueButton is conceived for videoconference calls with large numbers of participants. With no limits on the number of users and often high traffic spikes, the solution shows no signs of weakness. The platform has the advantage of being as stable and easy to use as other popular video conferencing solutions, with the added option of controling participant permissions, for example. In order to ensure stability Scaleway has chosen very large servers for its back-end infrastructure rather than several smaller ones, and has therefore opted for powerful BareMetal servers with a hardware configuration using no hypervisor or virtualization layer.
Source: Scaleway provides BigBlueButton video conferencing hosted on its BareMetal servers
ProxySQL is a high performance, high availability, protocol aware proxy for MySQL and forks (like Percona Server and MariaDB). All the while getting the unlimited freedom that comes with a GPL license.
Its development is driven by the lack of open source proxies that provide high performance.
Source: sysown/proxysql: High-performance MySQL proxy with a GPL license.
PHP Agent for Elastic APM – This is a community PHP agent for Elastic.co’s APM solution.
Source: philkra/elastic-apm-php-agent: PHP Agent for Elastic APM
Open source Application Performance Monitoring
Already housing logs and system metrics in Elasticsearch? Expand to application metrics with free and open Elastic APM. See exactly where your application is spending time so you can quickly fix issues and feel good about the code you push.
And PHP APM agent
Source: Application Performance Monitoring (APM) with Elasticsearch | Elastic
What is mydumper? and Why?
- Parallelism (hence, speed) and performance (avoids expensive character set conversion routines, efficient code overall)
- Easier to manage output (separate files for tables, dump metadata, etc, easy to view/parse data)
- Consistency – maintains snapshot across all threads, provides accurate master and slave log positions, etc
- Manageability – supports PCRE for specifying database and tables inclusions and exclusions
Source: maxbube/mydumper: Official mydumper project