Practical Orchestrator, BoF, GitHub and other talks at Percona Live 2017

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 talks

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-ost enjoys 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-ost works 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-ost runs 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!

Related

• 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-ost in 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 orchestrator is not. I’m curious to hear!

See you in Santa Clara!