Web lists-archives.com

Re: mysqld_multi






Am 19.05.2017 um 18:19 schrieb Matthew Black:
I just installed MySQL Enterprise Edition 5.7 on RHEL 6.8 to replace an aging 5.1 system running on RHEL 5. We run mysqld_multi with multiple instances, each database on its own TCP Port 33xx. I'm having trouble creating a database on the new server in a multi environment.

Can anyone provide a simple example of how to edit /etc/my.cnf file and command line steps necessary for creating a new database running on, for example, port 3311?

what has this to do with the my.cnf?
just connect to the correct instance and that's it

and probably get rid of RHEL6 because with systemd you don't need all the crap around to start multiple instances, just a few lines in the unit-file pointing to the correct config and mysqld_safe is also no needed

[harry@srv-rhsoft:~]$ mysql --help | grep port
-P, --port=# Port number to use for connection or 0 for default to, in
  --progress-reports  Get progress reports for long running commands (like
(Defaults to on; use --skip-progress-reports to disable.)

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql