[CentOS] mysql secure installation and multi mysqld

Bob Hoffman bob at bobhoffman.com
Thu May 17 14:54:52 UTC 2012


On 5/17/2012 5:30 AM, Leon Jacobs wrote:
> On Thu, May 17, 2012 at 5:44 AM, Bob Hoffman<bob at bobhoffman.com>  wrote:
>> is it possible to make each one of those instances a replicate/slave of
>> a different master
>> (thus a backup mysql server in a way?)
> I just recently finished playing with this. I ended up brining up a
> dedicated VM for this "backup mysql server". I then created 2 new init
> scripts (based off the mysqld one) and modified both to point to their
> respective my.cnf's (with auto startup via chkconfig etc etc). Both
> have separate data directories, run off 2 separate ports (and socket
> files) - which are fire walled anyways as I have no requirement for
> this to be open on the slaves and replicate 2 separate masters :)
>
> L.
>
Okay, so it looks doable.
My plan is to add the instances inside of the my.cnf and then use 
mysqld_multi to run them as slaves
to separate website masters...




More information about the CentOS mailing list