Comments on: Win a free Percona Live 2013 pass — unveiling riddle hints https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints Blog by Shlomi Noach Wed, 13 Feb 2013 08:48:07 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Andrew Moore https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints/comment-page-1#comment-179012 Wed, 13 Feb 2013 08:48:07 +0000 https://shlomi-noach.github.io/blog/?p=6069#comment-179012 Thanks Shlomi! Please don’t be shy with new MySQL riddles! Keep them coming. Maybe we can share some in Santa Clara?

]]>
By: shlomi https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints/comment-page-1#comment-178357 Tue, 12 Feb 2013 05:47:05 +0000 https://shlomi-noach.github.io/blog/?p=6069#comment-178357 Answer & winner are now available in text

]]>
By: moshe https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints/comment-page-1#comment-178198 Tue, 12 Feb 2013 00:07:07 +0000 https://shlomi-noach.github.io/blog/?p=6069#comment-178198 nice !

]]>
By: shlomi https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints/comment-page-1#comment-178027 Mon, 11 Feb 2013 17:49:13 +0000 https://shlomi-noach.github.io/blog/?p=6069#comment-178027 @Ben,
The image also comes first on search for “not entirely subtle hint” and for “not entirely subtle hint common_schema”, so no black voodoo is at hand!

]]>
By: shlomi https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints/comment-page-1#comment-178012 Mon, 11 Feb 2013 17:13:49 +0000 https://shlomi-noach.github.io/blog/?p=6069#comment-178012 @Ben,

“… because the “not entirely subtle” image of the hotel playground comes up as the top image in a google search for “not entirely subtle sandbox hint” …”

HA! This is hilarious! Spooky

Will publish the complete answer by tomorrow morning (my timezone);
Meanwhile, in a couple hours I will publish hint #3, which will remove all doubt about the answer, just so other people can choose to try their hand.

]]>
By: Ben https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints/comment-page-1#comment-178007 Mon, 11 Feb 2013 17:05:43 +0000 https://shlomi-noach.github.io/blog/?p=6069#comment-178007 I’m going to go with MySQL Sandbox, because the “not entirely subtle” image of the hotel playground comes up as the top image in a google search for “not entirely subtle sandbox hint” 😛

I believe Andrew got there with the full explanation first but I’ll go with;
Who will open your present, = I’ll go with present being a loose reference to prompt, and the fact sandbox will “open” with ./use
Make you play pleasant, = lets you test in isolation without affecting anything / anyone else.
Tidy your mess, = sbtool -o delete
Do the same for all else? = works equally well for all MySQL variants e.g. MariaDB, Percona Server

]]>
By: Andrew Moore https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints/comment-page-1#comment-177864 Mon, 11 Feb 2013 11:12:28 +0000 https://shlomi-noach.github.io/blog/?p=6069#comment-177864 Who will open your present,
Make you play pleasant,
Tidy your mess,
Do the same for all else?

Okay, my initial shot was Query Optimizer but it’s a flawed answer which made me rethink.

I was also thinking that it could be the mysqld, it opens a connection (present == your presence on the server),
makes you play pleasant by parsing your query. If you’re not playing pleasant it will throw syntax errors.
Once parsed it passes your request to the query optimizer and it will ‘tidy your mess’ based on cost weight (explain extended::show warnings),
This is true of all connections.

But now I’ve seen the hints,
MySQL Sandbox – Will open your present or tar archive and bootstrap an instance,
Can effortlessly create environments for testing technologies such as M>S,MM and Circular replication (makes your play pleasant),
Master controls allows you to ‘tidy your mess’ when you’re finished, take down instances etc.
Does the same for all else…Percona Server, MariaDB, Oracle MySQL.

Maybe I’m bending this riddle into an answer.
Maybe there is no spoon.

😉

]]>
By: Hrvoje https://shlomi-noach.github.io/blog/mysql/win-a-free-percona-live-2013-pass-unveiling-riddle-hints/comment-page-1#comment-177817 Mon, 11 Feb 2013 09:10:18 +0000 https://shlomi-noach.github.io/blog/?p=6069#comment-177817 MySQL sandbox

]]>