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.
Collect Code-Level Performance TracingRetrace collects an amazing amount of details about what is happening at the code level within your application. It is a gold mine for developers who are trying to troubleshoot bugs and look for ways to optimize their code.
Source: Retrace Application Performance Management (APM) – Stackify
Tideways saves you time by taking the guesswork out of your app’s backend performance. Gain detailed insights, spot performance bottlenecks, and get real-time error detection alerts.
Source: Mission control center for PHP application performance | Tideways
debug sql
Simple SQL statements debugging with MySQL global general_log variable turned ON
and a standalone php script that display the relevant SQL statements that are sent by a specific Moodle instance, filtered by the instance admin db username.
PHP Script: github/nadavkav/gist/nadavkav/mysql_statements_monitoring.php
Dynomite and the target storage engine run on the same node. Clients connect to Dynomite, and requests are proxied to either the storage engine on the same node or to Dynomite processes running on other nodes.
Dynomite, inspired by Dynamo whitepaper, is a thin, distributed dynamo layer for different storage engines and protocols. Currently these include Redis and Memcached. Dynomite supports multi-datacenter replication and is designed for high availability.
The ultimate goal with Dynomite is to be able to implement high availability and cross-datacenter replication on storage engines that do not inherently provide that functionality. The implementation is efficient, not complex (few moving parts), and highly performant.
מקור: Netflix/dynomite: A generic dynamo implementation for different k-v storage engines
Also, checkout (alternatives?):
What are Chartlets?
Chartlets are tiny charts without grids or legends, like Sparklines. They’re perfect for conveying simple relationships or trends, especially when space is scarce.
Chartlets uses the HTML5
<canvas>element for fast performance and is only 2.8k when minified and gzipped. It has no dependencies.
<canvas class=”chartlet” data-type=”line” data-colors=”#ffcc00 #ff66cc” data-range=”0 10″ data-sets=”[1 5 3 9 4] [4 3 9 7 2]” width=”100″ height=”55″ data-opts=”stroke:2 shape:smooth cap:circle”></canvas>
שילוב מנגנון הגרפים לעיל בשאילתות SQL ב configurable reports block
Bi-Directional Replication for PostgreSQL (Postgres-BDR, or BDR) is the first open source multi-master replication system for PostgreSQL to reach full production status, developed by 2ndQuadrant and assisted by a keen user community. BDR is specifically designed for use in geographically distributed clusters, using highly efficient asynchronous logical replication, supporting anything from 2 to more than 48 nodes in a distributed database.
Adminer (formerly phpMinAdmin) is a full-featured database management tool written in PHP. Conversely to phpMyAdmin, it consist of a single file ready to deploy to the target server. Adminer is available for MySQL, PostgreSQL, SQLite, MS SQL, Oracle, Firebird, SimpleDB, Elasticsearch and MongoDB.
מקור: Adminer – Database management in a single PHP file
Yorker, Moodler and developer Marcus Green not only offers comprehensive training on the Java programming language. In his examulator.com portal, he shows us a visualization of the database that po…
מקור: Visualize The Extent of Moodle 3.1 Data Model With This Tool | Moodle News
SQL Fiddle. How does it work? The Schema DDL that is provided is used to generate a private database on the fly. If anything is changed in your DDL (even a single space!), then you will be prompted to generate a new schema and will be operating in a new database. All SQL queries are run within a transaction that gets immediately rolled-back after the SQL executes. This is so that the underlying database structure does not change from query to query, which makes it possible to share anonymously online with any number of users (each of whom may be writing queries in the same shared database, potentially modifying the structure and thus — if not for the rollback — each other’s results). As you create schemas and write queries, unique URLs that refer to your particular schema and query will be visible in your address bar. You can share these with anyone, and they will be able to see what you’ve done so far. You will also be able to use your normal browser functions like ‘back’, ‘forward’, and ‘reload’, and you will see the various stages of your work, as you would expect.
