Jason Zhao <[email protected]> napisał: >Hello guys, > >I'm new to Ansible. Could anyone please help me with my question? > >I'm trying to automate the entire process of setting up a 2-node PXC. >All >the package installation and file configuration work have already been >automated using ansible. But I'm stuck in the last steps.
I'll describe how I'd go about it. This assumes you are running one play over all the hosts, and that there's a group called mysql_cluster. It also assumes that the first host in that group actually works. >Here are the remaining steps: > >1. Use '/etc/init.d/mysql bootstrap-pxc' to bootstrap the cluster from >node1, keep the mysql instance on node2 shut. - service: name=mysql state=stopped - shell: /etc/init.d/mysql bootstrap-pxc # don't use play_hosts nor run_once here - they don't act like we want when used with serial when: inventory_hostname == groups.mysql_cluster[0] register: create_cluster - name: Make sure no host continues if bootstrap failed assert: not (hostvars[groups.mysql_cluster [0]].create_cluster) | failed >2. Connect to mysql on node1 and create accounts for xtrabackup See the shell task in 1. for a way to only act on node1 >3. Use '/etc/init.d/mysql start' to start the mysql instance on node2 >and >it will join the cluster automatically. - service: name=mysql state=started # you can just run that everywhere, as mysql is already started on node1 anyway >I would like to know if Ansible can control the command execution >orders >between different nodes. The question is actually not specific to PXC, >but >applies to other cluster applications where order matters. > >Thanks, >Jason -- Wysłane za pomocą K-9 Mail. -- 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 [email protected]. To post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/ansible-project/cdda1a68-e473-45f0-8cb4-70820f9c131a%40email.android.com. For more options, visit https://groups.google.com/d/optout.
