Re: mysqld_multi missing after mysql50-server install
On Wed, Nov 26, 2008 at 2:23 PM, Ott Köstner <[EMAIL PROTECTED]> wrote: > Valentin Bud wrote: > >> And of course if there are other possibilities to run 2 mysqld >> instances on one server >> please let me know. >> >> > > There is no limit, how many instances of mysqld you can run. Just > specify different database directories and sockets for each instance. > Something like that: > > $ mysqld --datadir= --socket=/tmp/ socket> ... I get it. It's like making my own mysqld_multi. I can make multiple /etc/my.cnf and specify on the command line the default data dir, config file, etc and it just works. I will try it and get back with the results. I am thinking of making rc.d files to start the daemons at boot. > > There is no need to run mysqld as root (and better not do that). Just > any regular user is OK for mysqld. I am running mysql from /usr/local/etc/rc.d/mysql-server and it runs as user mysql. Thanks anyway for the heads up :). have a great day, v > > > Greetings, > O.K. > > > -- > Testi oma Interneti kiirust / Test Your Internet speed: > http://speedtest.zzz.ee/ > > > > > ___ > freebsd-questions@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-questions > To unsubscribe, send any mail to "[EMAIL PROTECTED]" > ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: mysqld_multi missing after mysql50-server install
Valentin Bud wrote: And of course if there are other possibilities to run 2 mysqld instances on one server please let me know. There is no limit, how many instances of mysqld you can run. Just specify different database directories and sockets for each instance. Something like that: $ mysqld --datadir= --socket=/tmp/ ... There is no need to run mysqld as root (and better not do that). Just any regular user is OK for mysqld. Greetings, O.K. -- Testi oma Interneti kiirust / Test Your Internet speed: http://speedtest.zzz.ee/ ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
Re: mysqld_multi missing after mysql50-server install
Hello again, Did some more research. I have a system running FreeBSD 6.2-RELEASE-p12 with an earlier version on mysql (mysql-server-5.0.41). Same thing, the mysqld_multi and mysqlmanager is missing. Once again do i miss something? If yes what is it? And of course if there are other possibilities to run 2 mysqld instances on one server please let me know. thank you and a great day, v On Tue, Nov 25, 2008 at 8:16 PM, Valentin Bud <[EMAIL PROTECTED]> wrote: > Hello list, > > I have just installed mysql50-server from ports. I need to start > 2 instances of mysqld. I have searched on dev.mysql.com how can I > accomplish that and there are 2 methods either using mysqld_multi > or mysqlmanager. After reading a little on mysql.com i decided i want > to go on mysqld_multi way because mysqlmanager will be removed in > 6.0 and i want to use this 2 instances quite some time from now on. > > The only problem is that i couldn't find neither of them (mysqld_multi > or mysqlmanager) after installing mysql50-server. My system is > FreeBSD 7.0-RELEASE-p5 amd64. I did some digging and extracted the sources > chnage dir to the sources dir and ./configure --help to see the > available options. > Found an options name --with-mysqlmanager. Went back to add this option to > the Makefile (CONFIGURE_ARGS section) reinstalled mysql50-server but > again the mysqlmanager program/script is missing. Am i missing something? > > And i found in /usr/local/share/mysql a script called > mysqld_multi.server which > doesn't run saying: "Can't execute /usr/local/mysql/bin/mysqld_multi > from dir /usr/local/mysql". > Check to see if there is a dir called /usr/local/mysql but there isn't > one. I even did a > find / -name "mysqld_multi" without no success. > > So can someone point me in the right direction please. > > thanks and a great day, > v > ___ freebsd-questions@freebsd.org mailing list http://lists.freebsd.org/mailman/listinfo/freebsd-questions To unsubscribe, send any mail to "[EMAIL PROTECTED]"
