"Vitess is a database solution for deploying, scaling and managing large clusters of MySQL instances. It's architected to run as effectively in a public or private cloud architecture as it does on dedicated hardware. It combines and extends many important MySQL features with the scalability of a NoSQL database. Vitess can help you with the following problems:

Scaling a MySQL database by allowing you to shard it, while keeping application changes to a minimum.
Migrating from baremetal to a private or public cloud.
Deploying and managing a large number of MySQL instances.

Vitess includes compliant JDBC and Go database drivers using a native query protocol. Additionally, it implements the MySQL server protocol which is compatible with virtually any other language.

Vitess has been serving all YouTube database traffic since 2011, and has now been adopted by many enterprises for their production needs."

"I'm happy to announce the availability of Outbrain's Orchestrator: MySQL replication management & visualization tool.

Orchestrator reads your replication topologies (give it one server - be it master or slave - in each topology, and it will reveal the rest). It keeps a state of this topology. It can continuously poll your servers to get an up to date topology map. It visualizes the topology in a clear and slick D3 tree. It allows you to modify your topology; move slaves around. You can use the command line variation, the JSON API, or you can use the web interface."

"Percona Server with XtraDB" is a drop-in replacement for MySQL, with full backward compatibility.

Percona Server provides diagnostic tools useful to DBAs, and more tunability of server behavior. Also included is Percona's online backup utility XtraBackup, the open source tool for the XtraDB / InnoDB.

 Percona Server with XtraDB shows outstanding performance and scalability on today's high-end server systems with many CPUs and fast storage subsystems such as flash storage and SSD. Notable advantages include:

     Scalability: Handles more concurrent transactions, and scales up on powerful servers.      Performance: Fast IO path, improved internal cooperation, and fast checksums.      Flexibility: Variable page size, better table and buffer pool management, and configurable insert buffer.      Reliability: Resilience to corrupted data, and crash-safe transactional replication.      Management: Online backup, InnoDB table import/export, fast recovery, and configurable data dictionary.      Diagnostics: Improved profiling and instrumentation.

This project is a repository of simple utilities written in various scripting languages, which are designed to make slow tasks a bit faster. The name is taken from the common garden snail.

Many of these tools are developed by consultants at Percona, where the author works.

This patch adds several INFORMATION_SCHEMA tables, several FLUSH and SHOW commands, and the userstat_running variable. These tables and commands can be used to understand the server activity better and identify the source of the load.

The functionality is disabled by default, and must be enabled by setting the userstat_running variable to ON. It works by keeping several hash tables in memory. To avoid contention over global mutexes, each connection has its own local statistics, which are occasionally merged into the global statistics, and the local statistics are then reset to 0.

mysql-snmp is a Net-SNMP Perl subagent that connects to a MySQL server and reports its statistics through SNMP. Additionally this project contains material to graph MySQL variables/counters in OpenNMS.

The graphs are based on the excellent MySQL Cacti Templates by Baron Schwartz.

mycheckpoint is an open source monitoring utility for MySQL, with strong emphasis on user accessibility to monitored data.

It is SQL oriented: charts, reports and advances metrics are generated on the fly with views. There is no need for an external program to diagnose the data. In fact, mycheckpoint’s main duty is to to a one-time creation of a special purpose schema.

The openark kit is a set of utilities for MySQL. They solve everyday maintenance tasks, which may be complicated or time consuming to work by hand.

The available tools are:

* oak-apply-ri: apply referential integrity on two columns with parent-child relationship.
* oak-block-account: block or release MySQL users accounts, disabling them or enabling them to login.
* oak-kill-slow-queries: terminate long running queries.
* oak-modify-charset: change the character set (and collation) of a textual column.
* oak-purge-master-logs: purge master logs, depending on the state of replicating slaves.
* oak-security-audit: audit accounts, passwords, privileges and other security settings.
* oak-show-limits: show AUTO_INCREMENT “free space”.
* oak-show-replication-status: show how far behind are replicating slaves on a given master.

is real-time query performance and diagnostics tool for the MySQL database server. Core features:

* Query, table and user performance
* Graphical visualisation
* Low overhead
* Easy to use

A collection of scripts for making your daily MySQL DBA responsibilities easier.

* mt-backup-parallel -> runs mysql backups in parallel super fast, has lots of reporting features
* mt-check-replication -> script to report on replication status for slave servers
* mt-rhcluster-check-filesystems -> reports on redhat cluster filesystems (for mysql active/passive clustering)
* mt-rhcluster-script-wrapper -> wrapper script for running any of these scripts on a redhat cluster, chooses the active node to run the script on
* mt-connections-log -> logs connections to mysql to disk, reports on threshold overages
* mt-flush-tables-sequence -> runs through schema.tables to flush in sequence before global flush
* mt-rotate-logs -> rotates general and slow query logs on periodic basis
* mt-my.cnf_xG -> MySQL configuration file for a particular RAM size installation