Using Docker

This document will guide you build standalone MatrixOne using Docker.

Step 1: Download and install Docker

  1. Click Get Docker, enter into the Docker’s official document page, depending on your operating system, download and install the corresponding Docker.

  2. After the installation, you can verify the Docker version by using the following lines:

    1. docker --version

    The successful installation results are as follows:

    1. Docker version 20.10.17, build 100c701
  3. Execute the following command in your terminal, start Docker and check whether the running status is successfully:

    1. systemctl start docker
    2. systemctl status docker

    The following code example indicates that Docker is running. Active: active (running) shows that Docker is running.

    1. docker.service - Docker Application Container Engine
    2. Loaded: loaded (/usr/lib/systemd/system/docker.service; disabled; vendor preset: disabled)
    3. Active: active (running) since Sat 2022-11-26 17:48:32 CST; 6s ago
    4. Docs: https://docs.docker.com
    5. Main PID: 234496 (dockerd)
    6. Tasks: 8
    7. Memory: 23.6M

Step 2: Create and run the container of MatrixOne

It will pull the image from Docker Hub if not exists. You can choose to pull the stable version image or the develop version image.

Stable Version Image(0.6.0 version)Develop Version Image

  1. docker pull matrixorigin/matrixone:0.6.0
  2. docker run -d -p 6001:6001 --name matrixone matrixorigin/matrixone:0.6.0

If you want to pull the develop version image, see Docker Hub, get the image tag. An example as below:

  1. docker pull matrixorigin/matrixone:nightly-commitnumber
  2. docker run -d -p 6001:6001 --name matrixone matrixorigin/matrixone:nightly-commitnumber

Note: The nightly version is updated once a day.

If you need to mount data directories or customize configure files, see Mount the directory to Docker container.

Step 3: Connect to standalone MatrixOne

Install and configure MySQL Client

  1. Click MySQL Community Downloads to enter into the MySQL client download and installation page. According to your operating system and hardware environment, drop down to select Select Operating System, then drop down to select Select OS Version, and select the download installation package to install as needed.

    Note: MySQL client version 8.0.30 or later is recommended.

  2. Configure the MySQL client environment variables:

    1. Open a new terminal window and enter the following command:

      1. cd ~
      2. sudo vim /etc/profile
    2. After pressing Enter on the keyboard to execute the above command, you need to enter the root user password, which is the root password you set in the installation window when you installed the MySQL client. If no password has been set, press Enter to skip the password.

    3. After entering/skiping the root password, you will enter profile, click i on the keyboard to enter the insert state, and you can enter the following command at the bottom of the file:

      1. export PATH=/software/mysql/bin:$PATH
    4. After the input is completed, click esc on the keyboard to exit the insert state, and enter :wq at the bottom to save and exit.

    5. Enter the command source /etc/profile, press Enter to execute, and run the environment variable.

    6. To test whether MySQL is available:

      • Method 1: Enter mysql -u root -p, press Enter to execute, the root user password is required, if mysql> is displayed, it means that the MySQL client is enabled.

      • Method 2: Run the command mysql --version, if MySQL client is installed successfully, the example code line is as follows: mysql Ver 8.0.31 for Linux on x86_64 (Source distribution)

    7. If MySQL is available, close the current terminal and browse the next chapter Connect to MatrixOne Server.

Tips: Currently, MatrixOne is only compatible with the Oracle MySQL client. This means that some features might not work with the MariaDB client or Percona client.

Connect to MatrixOne

  • You can use the MySQL command-line client to connect to MatrixOne server. Open a new terminal window and enter the following command:

    1. mysql -h IP -P PORT -uUsername -p

    After you enter the preceding command, the terminal will prompt you to provide the username and password. You can use our built-in account:

    • user: dump
    • password: 111
  • You can also use the following command line on the MySQL client to connect to the MatrixOne service:

    1. mysql -h 127.0.0.1 -P 6001 -udump -p
    2. Enter password:

Currently, MatrixOne only supports the TCP listener.