Add a slave?

[Phil Smy]

Hi...we want to add a slave mysql instance to our setup. I'm a bit concerned about how this would be done 'blind' through rubber. Has anyone done this and if so, what exactly do we do?

[Kevin Menard]

Hi Phil,

Are you currently using the vanilla "mysql" role or are you using the "mysql_cluster" role. If the former, you should just be able to add a new machine with the "mysql_slave" role. I'll admit it's been quite some time since I've done this, having really only run PostgreSQL in my last few production deployments. But, reading through the source that seems to be it.

If you already have a slave present, you'll need to update the generated rubber config to account for the new slave's server_id. If this is your first slave, the generated Rubber config should be sufficient (master gets server_id 1 and the slave gets server_id 2).

Bootstrapping the machine with the mysql_slave role should take care of configuring replication:

https://github.com/rubber/rubber/blob/a320260009c28ad5b5744942375d4cb64ff78ae7/templates/mysql/config/rubber/deploy-mysql.rb#L53-L108

So, the steps would be (from memory -- I don't have a MySQL cluster to test against at the moment):

$ ALIAS=new_machine cap rubber:create

$ ALIAS=new_machine ROLES=mysql_slave cap rubber:roles:add
$ ALIAS=new_machine cap rubber:bootstrap

$ cap deploy

Please let me know if you have any other questions.

--

Kevin

On Fri, May 19, 2017, at 01:51, Phil Smy wrote:

Hi...we want to add a slave mysql instance to our setup. I'm a bit concerned about how this would be done 'blind' through rubber. Has anyone done this and if so, what exactly do we do?

--

You received this message because you are subscribed to the Google Groups "rubber" group.

To unsubscribe from this group and stop receiving emails from it, send an email to rubber-ec2+...@googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

[Kevin Menard]

Oops. That should be:

$ FILTER=new_machine cap rubber:bootstrap

--

Kevin