{"id":2292,"date":"2012-02-05T08:57:47","date_gmt":"2012-02-05T13:57:47","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=2292"},"modified":"2012-02-05T08:57:52","modified_gmt":"2012-02-05T13:57:52","slug":"mysql-creatively-in-a-sandbox-by-giuseppe-maxia","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia","title":{"rendered":"MySQL Creatively in a Sandbox by Giuseppe Maxia"},"content":{"rendered":"<p><a href=\"http:\/\/datacharmer.blogspot.com\/\">Giuseppe Maxia<\/a> of <a href=\"http:\/\/continuent.com\/\">Continuent<\/a> and long time creator of <a href=\"http:\/\/mysqlsandbox.net\/\">MySQL Sandbox<\/a>.<\/p>\n<p>Only works on Unix-like servers. Works with MySQL, Percona &amp; MariaDB servers. MySQL server has the data directory, the port and the socket &#8211; you can&#8217;t share these.<\/p>\n<p>To use it: make_sandbox foo.tar.gz. Then just do .\/use.<\/p>\n<p>$SANDBOX_HOME is ~\/sandboxes. You can also create ~\/opt\/mysql\/ and if you have MySQL 5.0.91 binary in that directory, you can just do &#8220;sb 5.1.91&#8221;.<\/p>\n<p>Sandbox has features to start replication systems as well. You can have varying master\/slave setups with varying versions as well (good idea to test from MySQL -&gt; MariaDB master-&gt;slave for migration).<\/p>\n<p>You can now also play with tungsten-sandbox, which is a great way to start playing with Tungsten Replicator (see <a href=\"http:\/\/code.google.com\/p\/tungsten-toolbox\/wiki\/TungstenSandbox\">documentation<\/a> and <a href=\"http:\/\/code.google.com\/p\/tungsten-toolbox\/\">tungsten-toolbox<\/a>). There is apparently also a MySQL Cluster sandbox tool that someone is working on.<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Giuseppe Maxia of Continuent and long time creator of MySQL Sandbox. Only works on Unix-like servers. Works with MySQL, Percona &amp; MariaDB servers. MySQL server has the data directory, the port and the socket &#8211; you can&#8217;t share these. To use it: make_sandbox foo.tar.gz. Then just do .\/use. $SANDBOX_HOME is ~\/sandboxes. You can also create [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[23],"tags":[1332,604,1089],"class_list":["post-2292","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-fosdem","tag-giuseppe-maxia","tag-mysql-sandbox"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/p4vJD-AY","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2292"}],"version-history":[{"count":2,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2292\/revisions"}],"predecessor-version":[{"id":2294,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2292\/revisions\/2294"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}