https://bugzilla.novell.com/show_bug.cgi?id=353120
User mmarek@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=353120#c13
--- Comment #13 from Michal Marek
I think your latest proposal still has the problem that all the mysqld instances will look into the '[mysqld]' section for options not passed on the command-line. This means that only those options handled by parse_arguments can be set per-server afaics. Correct me if I'm wrong.
I think I have to correct you here. If the output of my_print_defaults can be trusted than each database section is a section on its own. For example:
That's unfortunately not sufficient. Consider this setting: [mysqld2] skip-networking datadir = /var/lib/mysql2 socket = /var/lib/mysql2/mysql.sock pid-file = /var/lib/mysql2/mysqld.pid log = /var/lib/mysql2/mysqld.log Then: # ./rcmysql2 start Starting mysql server: mysqld done Starting mysql server: mysqld done Starting mysql server: mysqld2 warning: /var/lib/mysql2/mysql.sock didn't appear within 30 seconds done That's because --skip-networking isn't propagated down to mysqld itself, which reads the default [mysqld] section and tries to bind to the already occupied tcp port 3306. IOW only arguments that are handled specially in parse_arguments can be set per-server. That's why I think using mysql_multi or mysqlmanager would be a solution. rcmysql would then only need to handle arguments it needs to know about (datadir, pid-file and socket). BTW, ./rcmysql2 stop seems to only shutdown the first instance.
BTW, if you want, I can give you access to the server:database:mysql51 project to try out this feature. If it turns out to be working, I can merge it to the Factory mysql package.
How would you track what changes I make to the script? The BS does not have a commit notification AFAIK.
An email when you make important changes will suffice (sure, commit notification in the bs would be cool). But what I wanted to say is that it would be better to first try this out in the buildservice and merge it to the distro after it has got some testing. The :mysql51 project is still rather experimental, so it's not such a big issue if something breaks there :) Factory mysql 5.0 is linked to server:database which is used more people, who don't expect it to break too often. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.