Next week I will be presenting Practical Orchestrator at Percona Live, Santa Clara.
As opposed to previous
orchestrator talks I gave, and which were either high level or algorithmic talks, Practical Orchestrator will be, well... practical.
The objective for this talk is that attendees leave the classroom with a good grasp of
orchestrator's powers, and know how to set up
orchestrator in their environment.
We will walk through discovery, refactoring, recovery, HA. I will walk through the most important configuration settings, share advice on what makes a good deployment, and tell you how we and others run
orchestrator. We'll present a few scripting/automation examples. We will literally set up
orchestrator on my computer.
It's a 50 minute talk and it will be fast paced!
ProxySQL & Orchestrator BoF
ProxySQL is all the rage, and throughout the past 18 months René Cannaò and myself discussed a few times the potential for integration between ProxySQL and Orchestrator. We've also received several requests from the community.
We will run a BoF, a very informal session where we openly discuss our thoughts on possible integration, what makes sense and what doesn't, and above all else would love to hear the attendees' thoughts. We might come out of this session with some plan to pick low hanging fruit, who knows?
The current link to the BoF sessions is this. It seems terribly broken, and hopefully I'll replace it later on.
GitHub engineers will further present these talks:
- gh-ost: triggerless, painless, trusted online schema migrations
Jonah Berquist, 25 April - 2:20 PM - 3:10 PM @ Ballroom D
This is the "classic" introduction to gh-ost, our very own open source schema migration tool.
gh-ostenjoys good traction and adoption. For us, it made a significant impact on our development cycle and on our availability and reliability. We hear similar stories from users. This talk will explain how
gh-ostworks and why it works for us and others so much better. Also: superpowers.
- Automating Schema Changes using gh-ost
Tom Krouper, 27 April - 12:50 PM - 1:40 PM @ Ballroom D
What's the greater picture?
gh-ostruns the migration, but what's the migration cycle? How do our engineers design the change, get this to run, verify it doesn't break our environment? What automation do we have in place? Expect very interesting and definitely not trivial issues.
- Practical JSON in MySQL 5.7 and beyond
Ike Walker, 27 April - 3:00 PM - 3:50 PM @ Ballroom A
Ike will review the JSON data type along with most recent changes, virtual columns, operational concerns and more. I'm looking forward to a great review!
- Experiences using gh-ost in a multi-tier topology
Ivan Groenewold, Valerie Parham-Thompson, Pythian, 26 April - 5:00 PM - 5:25 PM @ Ballroom C
Don't take it from us. Pythian are running
gh-ostin production, and on completely different environments than us. I'm absolutely curious to hear about their experience and findings.
- High Availability in GCE
Carmen Mason, Allan Mason, 26 April - 3:30 PM - 4:20 PM @ Ballroom D
This is a story on the road to MySQL HA on Google Cloud Engine. It ends up with MHA picked as the HA solution while
orchestratoris not. I'm curious to hear!
See you in Santa Clara!