MySQL_replication module

269 views
Skip to first unread message

Balazs Pocze

unread,
Jun 19, 2013, 8:17:46 AM6/19/13
to ansible...@googlegroups.com
Hi Guys,

I've finished a module for ansible, it is called as
'mysql_replication' and of course you can manage mysql replication
features with that.
It can operate in different ways, you can check replication master's
status, replication slave's status, you can change replication
parameters, and stop / start slaves. The documentation is speaks for
itself I guess. I hope, it will be merged soon, but before that you
can check/test/use it from here:

https://github.com/banyek/ansible/blob/devel/library/database/mysql_replication

"Some" code was taken from Mark Theunissen's mysqldb module (for
example to connect to db, strip quotes, parse config) thanks for him!

kind regards,
Balazs Pocze



--
If a tree falls in a forest and no one is around to hear it, does it
make a sound?

Michael DeHaan

unread,
Jun 19, 2013, 10:38:54 AM6/19/13
to ansible...@googlegroups.com
Pull request is here -- https://github.com/ansible/ansible/pull/3195 -- were you going to resubmit this or is this one still active?





--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.





--
Michael DeHaan <mic...@ansibleworks.com>
CTO, AnsibleWorks, Inc.
http://www.ansibleworks.com/

Govinda Fichtner

unread,
Aug 1, 2014, 3:04:53 AM8/1/14
to ansible...@googlegroups.com
Would it make sense to have an additional feature that completely removes mysql slave replication from a slave with "reset slave all;" as described here http://www.mysqlperformanceblog.com/2013/04/17/reset-slave-vs-reset-slave-all-disconnecting-a-replication-slave-is-easier-with-mysql-5-5/

Currently it is only possible to stop slave replication with mysql_replication module...

Cheers,

Govinda

Michael DeHaan

unread,
Aug 1, 2014, 7:38:58 AM8/1/14
to ansible...@googlegroups.com
I think pull requests would definitely be considered, though I'd be looking for some folks using this module to weigh in.

Internally, we're more of a Postgres shop, so I'm a bit less the one to comment on applicability.






--
You received this message because you are subscribed to the Google Groups "Ansible Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ansible-proje...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages