Re: [CentOS] mysql secure installation and multi mysqld

2012-05-17 Thread Bob Hoffman
On 5/17/2012 5:30 AM, Leon Jacobs wrote: > On Thu, May 17, 2012 at 5:44 AM, Bob Hoffman 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

Re: [CentOS] mysql secure installation and multi mysqld

2012-05-17 Thread Leon Jacobs
On Thu, May 17, 2012 at 5:44 AM, Bob Hoffman 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 serve

[CentOS] mysql secure installation and multi mysqld

2012-05-16 Thread Bob Hoffman
If you adjust the my.cnf file to make separate instances of mysql. How would you go through the mysql secure installation? Is is possible or must it all be done manually for each one? is it possible to make each one of those instances a replicate/slave of a different master (thus a backup m