2.2. Using containers to run multiple MariaDB and MySQL instances on a single host

Procedure

1. Authenticate to the registry.redhat.io registry by using your Red Hat Customer Portal account:

   # podman login registry.redhat.io

   Skip this step if you are already logged in to the container registry.

2. Start the containers you want to use:

   • MariaDB 10.11:

     $ podman run -d --name <container_name_1> -e MYSQL_ROOT_PASSWORD=<password> -p <host_port_1>:3306 rhel10/mariadb-1011

     For more information about the usage of this container image, see the Red Hat Ecosystem Catalog.

   • MySQL 8.4:

     $ podman run -d --name <container_name_2> -e MYSQL_ROOT_PASSWORD=<password> -p <host_port_2>:3306 rhel10/mysql-84

     For more information about the usage of this container image, see the Red Hat Ecosystem Catalog.

   重要

   The container names and host ports of the two database servers must differ.

3. To ensure that clients can access the database server on the network, open the host ports in the firewall:

   # firewall-cmd --permanent --add-port={<host_port_1>/tcp,<host_port_2>/tcp,...}
   # firewall-cmd --reload

Verification

1. Connect to the database server and log in as root:

   # mysql -u root -p -h localhost -P <host_port> --protocol tcp

2. Optional: Display information about the running containers:

   $ podman ps