Re: multiple mysql servers

From: nanard (nanard_at_tou.nu)
Date: 07/29/05

  • Next message: Sean Ellis: "Re: multiple mysql server" 
    To: <sellis@telus.net>, <freebsd-isp@freebsd.org>
Date: Fri, 29 Jul 2005 22:14:53 +0200

    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@telus.net>
    To: <freebsd-isp@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@freebsd.org mailing list
    > http://lists.freebsd.org/mailman/listinfo/freebsd-isp
    > To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org"
    >

    _______________________________________________
    freebsd-isp@freebsd.org mailing list
    http://lists.freebsd.org/mailman/listinfo/freebsd-isp
    To unsubscribe, send any mail to "freebsd-isp-unsubscribe@freebsd.org"

  • Next message: Sean Ellis: "Re: multiple mysql server"