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 new feature is based on Docker container virtualization.

The mechanism was changed in ISPmanager 5 Lite 5.71.0. For more information about changes, read the article below.

Docker requires at least 2 GB of RAM to work properly.

System requirements

Supported operating systems: CentOS 7, Ubuntu 16, Debian 8 and later.

OpenVZ virtualization is not supported.

Installing alternative MySQL server. ISPmanager Lite

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

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 "Install APS" 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.

 If Install APS is not set for your servers, scripts will be installed from local server.
 If it is not specified, from the first server on the list.

Click Ок once completed.

Installing alternative MySQL server. ISPmanager Business

To be able to set up alternative versions in ISPmanager Business, you must have at least one cluster node with MySQL role. Navigate to Cluster settings --> MySQL set up

In the form that will open select one or several MySQL version and click Install. The selected version will be installed on all existing cluster nodes with MySQL role, and those you will connect in future.

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 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.