{"id":7241,"date":"2015-06-05T14:19:34","date_gmt":"2015-06-05T12:19:34","guid":{"rendered":"http:\/\/code.openark.org\/blog\/?p=7241"},"modified":"2015-06-05T14:21:08","modified_gmt":"2015-06-05T12:21:08","slug":"orchestrator-visual-cheatsheet","status":"publish","type":"post","link":"https:\/\/code.openark.org\/blog\/mysql\/orchestrator-visual-cheatsheet","title":{"rendered":"Orchestrator visual cheatsheet"},"content":{"rendered":"

Orchestrator<\/a><\/strong> is growing. Supporting automatic detection of topologies, simple refactoring of topology trees, complex refactoring via Pseudo-GTID, failure detection and automated discovery, it is becoming larger and larger by the day.<\/p>\n

One of the problems with growign projects is hwo to properly document them. Orchestrator enjoys a comprehensive manual<\/a>, but as these get more and more detailed, it is becoming difficult to get oriented and pointed in the right direction. I’ve done my best to advise the simple use cases throughout the manual.<\/p>\n

One thing that is difficult to put into words is topologies. Explaining “failover of an intermediate master S1 that has S2,…,Sn slaves onto a sibling of S1 provided that…” is too verbose. So here’s a quick visual cheatsheet for (current) topology refactoring commands. Refactoring commands are a mere subset of overall orchestrator commands, but they’re great to play with and perfect for visualization.<\/p>\n

The “move” and related commands use normal replication commands (STOP SLAVE; CHANGE MASTER TO; START SLAVE UNTIL;”…).<\/p>\n

The “match” and related commands utilize Pseudo-GTID and use more elaborate MySQL commands (SHOW BINLOG EVENTS, SHOW RELAYLOG EVENTS).<\/p>\n

So without further ado, here’s what each command does (and do run “orchestrator” from the command line to get a man-like explanation of everything, or just go to the manual<\/a>).<\/p>\n

\"orchestrator-cheatsheet-visualized-7\"<\/a>
\n\"orchestrator-cheatsheet-visualized-8\"<\/a>
\n\"orchestrator-cheatsheet-visualized-9\"<\/a>
\n\"orchestrator-cheatsheet-visualized-10\"<\/a>
\n\"orchestrator-cheatsheet-visualized-11\"<\/a>
\n\"orchestrator-cheatsheet-visualized-12\"<\/a>
\n\"orchestrator-cheatsheet-visualized-13\"<\/a>
\n\"orchestrator-cheatsheet-visualized-1\"<\/a>
\n\"orchestrator-cheatsheet-visualized-2\"<\/a>
\n\"orchestrator-cheatsheet-visualized-3\"<\/a>
\n\"orchestrator-cheatsheet-visualized-4\"<\/a>
\n\"orchestrator-cheatsheet-visualized-5\"<\/a>
\n\"orchestrator-cheatsheet-visualized-6\"<\/a>
\n\"orchestrator-cheatsheet-visualized-14\"<\/a>
\n\"orchestrator-cheatsheet-visualized-15\"<\/a>
\n\"orchestrator-cheatsheet-visualized-16\"<\/a>
\n\"orchestrator-cheatsheet-visualized-17\"<\/a>
\n\"orchestrator-cheatsheet-visualized-18\"<\/a><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

Orchestrator is growing. Supporting automatic detection of topologies, simple refactoring of topology trees, complex refactoring via Pseudo-GTID, failure detection and automated discovery, it is becoming larger and larger by the day. One of the problems with growign projects is hwo to properly document them. Orchestrator enjoys a comprehensive manual, but as these get more and […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2}},"categories":[5],"tags":[108,8],"class_list":["post-7241","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-orchestrator","tag-replication"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p2bZZp-1SN","_links":{"self":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/7241","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/comments?post=7241"}],"version-history":[{"count":8,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/7241\/revisions"}],"predecessor-version":[{"id":7268,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/posts\/7241\/revisions\/7268"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/media?parent=7241"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/categories?post=7241"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/code.openark.org\/blog\/wp-json\/wp\/v2\/tags?post=7241"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}