Re: mysqld_multi missing after mysql50-server install

2008-11-26 Thread Valentin Bud
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]


Re: mysqld_multi missing after mysql50-server install

2008-11-26 Thread Valentin Bud
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=your sql instance dada dir --socket=/tmp/your
 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

2008-11-26 Thread Ott Köstner

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=your sql instance dada dir --socket=/tmp/your
socket ...

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]