/PmaControl

MySQL / MariaDB : Tools / Administration / Monitoring / Dashbord / Purge / Backup

Primary LanguagePHP

PmaControl

Alt text

UI & CLI Tools for DBA (monitoring / backup / install / cleaner ...)

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

Distribution based on Linux. (don't work with windows!)

  • 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

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)
  • postfix to send mail
  • curl used for get translatation from google

in [mysqld] section

plugin-load=ha_rocksdb

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 !

Screenshots

To develop

git config --global --add merge.ff false