On Fri, 15 Feb 2008, Richard Bos wrote:
[one more try, to get someone to try the new startup script for mysql. Or did someone try it out already?]
anybody out there that want to test a new mysql rpm, that supports the start of multiple databases during system startup (and stop during shutdown)?
The rpm and it's dependencies can be retrieved from this repository: http://download.opensuse.org/repositories/server:/database:/mysql51/openSUSE... (a 10.3 version is available as well)
The /etc/init.d/mysql script has 2 legs: - 1 with code that is currently in use - and a leg with the new code, that starts and stops multiple databases
With a variable in /etc/sysconfig/mysql (or in the sysconfig editor Applications/Mysql) one can select which leg to use. To use the new code the variable MYSQLD_MULTI has to be set "yes".
The code to start the multiple databases uses mysqld_multi that comes with the mysql code to start the databases.
Databases can be added using the databases sections at the bottom of /etc/my.cnf
Looking forward to test reports!
I did a quick test and I did not have any problems. I hope to test it
more in a few weeks.
Sorry, I can't do more right now.
--
Boyd Gerber