What is the correct way to start a second copy of the mysql daemon?

Question

MySQL

Hello!
There is a server with mysql (percona), on which several databases are running, serving sites running on the same server.
For development needs, it is necessary to create a database accessible from the Internet. At the same time, there is no desire to post the main demon on the Internet. I'm trying to run a copy of the daemon according to the ancient instructions: guruadmin.ru/page/zapuskaem-neskolko-kopij-mysql-n...
I made this config:

cat /etc/mysql_internet/debian.cnf 
[client]
host     = localhost
port	 = 3322
user     = debian-sys-maint
password = password
socket   = /var/run/mysqld/mysqld_internet.sock
pid-file = /var/lib/mysql/mysql_internet.pid
datadir  = /var/lib/mysql_internet/
log	 = /var/log/mysql_internet/ 
log-bin  = /var/log/mysql_internet/
log-update  = /var/log/mysql_internet/
log-isam  = /var/log/mysql_internet/
bdb-logdir  = /var/log/mysql_internet/
[mysql_upgrade]
host     = localhost
port	 = 3322
user     = debian-sys-maint
password = password
socket   = /var/run/mysqld/mysqld_internet.sock
basedir  = /usr
pid-file = /var/lib/mysql/mysql_internet.pid
datadir  = /var/lib/mysql_internet/
log      = /var/log/mysql_internet/
log-bin  = /var/log/mysql_internet/
log-update  = /var/log/mysql_internet/
log-isam  = /var/log/mysql_internet/
bdb-logdir  = /var/log/mysql_internet/

When the daemon is started with the line
mysqld_safe --defaults-file=/etc/mysql_internet/debian.cnf The config is ignored
and the daemon does not start, swearing at the presence of a pid file.
When starting mysqld_safe --pid-file=/var/lib/mysql/mysql_internet.pid --defaults-file=/etc/mysql_internet/debian.cnf --port=3322
The daemon allegedly starts, but does not even pick up the path to the logs from config, and netstat shows nothing on port 3322.
The question is standard: CHYADNT and how to be?

Answer 1

Discover virtualization or docker containers

Answer 2

Take the /etc/init.d/mysql file, copy it to some /etc/init.d/mysql-second, edit the paths to the config in it and what else (like HOME=/etc/mysql, here's another edit) and start your mysql-second.

Answer 3

Don't worry, run it in the chute - https://debian.pro/440
There, only the port will need to be changed so that it does not try to hang itself on 3306.

Answer 4

I walk with a transporter and chant: Docker! Docker! Docker!

Answer 5

Good afternoon!
On my sentos, I did the following:
- created a separate config
- ran the command: sudo mysql_install_db --user=mysql --datadir=/opt/mysql2 --defaults-file=/etc/my2.cnf
- modified files for start/ stop the demon
- the port gave 53306 and 53307 respectively :)
Now two different demons, with different bases - test and combat

Answer 6

Create a user who is allowed to connect to the Internet.
You can restrict both the user and the entire database by IP.