PmaControl

Alt text , _(*1)

UI & CLI Tools for DBA (monitoring / backup / install / cleaner ...), _(*2)

This software is distributed under Free Software Lisense : GNU / GPL v3 (http://www.gnu.org/licenses/gpl-3.0.en.html), _(*3)

Distribution based on Linux. (don't work with windows!), _(*4)

Automatic discovery and monitoring
Monitoring : Master/Slave, Galera Cluster, HA Proxy
Query analyzer
Backup system (Xtrabackup / mysqldump / mydumper) with different storage area
Manage array of servers (like it's was only one)
Manage user
Pluging : Cleaner

Deployment

Install server

have a look on : https://github.com/Esysteme/Debian/blob/master/ubuntu_server.bash, _(*5)

Dependencies to install

**PHP 7.0.*** or highter
ext-gd
ext-mcrypt
ext-ssh2 => used for monitoring system and backup
ext-mysqlnd
ext-curl
MariaDB 10.11
graphviz => make a graph about replication (include multi master and galera cluster)
apache2 (with a2enmod php5 & a2enmod rewrite)
curl used for get translatation from google

in [mysqld] section, _(*6)

plugin-load=ha_rocksdb, _(*7)

Install composer

$ curl -sS https://getcomposer.org/installer | php
$ mv composer.phar /usr/local/bin/composer

Deploy this project

git clone https://github.com/PmaControl/PmaControl.git pmacontrol

Install dependencies

cd pmacontrol
git config core.fileMode false
composer install

Auto install

./install

You are ready !

go to http://127.0.0.1/pmacontrol/

Screenshots

To develop

git config --global --add merge.ff false, _(*8)

23/01 2017

dev-master

9999999-dev

PmaControl 0.5 Beta

Sources Download

GPL-3.0

library pmacontrol