Alternative MySQL versions

From ISPWiki
Jump to: navigation, search

Introduction

MySQL is a free database management system.

Starting from version 5.68 ISPmanager 5 Lite enables to install several alternative MySQL versions on a single server.

It's now possible thanks to Docker container virtualization.

Installing an alternative MySQL server

In order to set up a MySQL-server, navigate to Settings ->Database servers, and click Create.

 This feature is supported only on Debian 8, CentOS 7, and  Ubuntu 16 

A server creation form will open, where you can choose a MySQL version for setup.

Mysql1-fom-exist.png

If you choose MySQL server type, you will be able to choose action for this server. You can:

  1. Connect an existing local or remote server
  2. Install new local MySQL server

Mysql1-fom-install.png


The following versions are currently supported: 
  • MySQL 5.5
  • MySQL 5.6
  • MySQL 5.7
  • Mariadb 10.0
  • Mariadb 10.1

Enter a name for the new server, that will be displayed in the control panel, and root password.

Note: by default, the newly created server will listen to IP address 127.0.0.1 (localhst). To make it accessible from the outside, select the check box Accessible from outside. The server will listen to 0.0.0.0. Once completed, click Ок.

If you want to use this server for installation of APS-scripts, select the "APS installation" check box. You can change a sever for scripts in the list of servers by clicking the "Default server" button. Once you are done, click OK.

Creating a database

After your server is successfully installed and configured, it will be added into the list of servers.

Now you can navigate to Tools -> Databases and select the newly created server in the database creation form.

Technology

All alternative MySQL-servers are deployed within containers (isolated environments). Data from each container are kept in a separate directory /var/lib/server_name. Docker is responsible for creation and management of containers, and MySQL versions are kept in its repositories.

 All of the alternative MySQL versions will be used for setup of the local MySQL-server. You should not delete those versions.

Container setup procedure:

  • A directory is created for the container(/var/lib/server_name)
  • A selected MySQL version is uploaded from the repository
  • A free port is selected for the container ( the first free port starting from 3310)
  • The server is configured, and root password is set up.