multiple mysql servers

[nanard]

Hi,

You just have to specify a different port , different socket, and different 
data directory to run it a second mysql server on the same box. :

I didn't try this but you can:

- Copy /var/db/mysql /var/db/mysql2 (and give same owner/perm than the 
other)
- Create a my.cnf in /var/db/mysql2 and configure it.
- Copy /usr/local/etc/rc.d/mysql-server.sh to 
/usr/local/etc/rc.d/mysql-server2.sh
- In /usr/local/etc/rc.d/mysql-server2.sh, change in it "mysql_dbdir" 
variable to the new path and set mysql_enable to YES directly in it.

Other solutions that i did, is to configure JAILS.

Regards


----- Original Message ----- 
From: "Sean Ellis" <sellis at telus.net>
To: <freebsd-isp at freebsd.org>
Sent: Friday, July 29, 2005 7:01 PM
Subject: multiple mysql servers


> Hello,
>
> 4.11-STABLE FreeBSD 4.11-STABLE #2: Fri May 13 17:43:58 PDT 2005
>
> can anyone recommend  a good online resource for implementing a second
> mysql daemon on freebsd?
>
> Or, perish the thought, any gotchas with this,
>
> thanks,
>
> Sean
> _______________________________________________
> freebsd-isp at freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-isp
> To unsubscribe, send any mail to "freebsd-isp-unsubscribe at freebsd.org"
>