{"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":"http:\/\/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<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MySQL%20Creatively%20in%20a%20Sandbox%20by%20Giuseppe%20Maxia&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2012%2F02%2F05%2Fmysql-creatively-in-a-sandbox-by-giuseppe-maxia&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"d034243e72\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2292\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-2292\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-2292\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","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<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20MySQL%20Creatively%20in%20a%20Sandbox%20by%20Giuseppe%20Maxia&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2012%2F02%2F05%2Fmysql-creatively-in-a-sandbox-by-giuseppe-maxia&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"d034243e72\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-2292\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-2292\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-2292\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[1332,604,1089],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-AY","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":2262,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/building-simple-complex-replication-clusters-with-tungsten-replicator-by-giuseppe-maxia","url_meta":{"origin":2292,"position":0},"title":"Building simple &#038; complex replication clusters with Tungsten Replicator by Giuseppe Maxia","date":"5\/2\/2012","format":false,"excerpt":"Giuseppe Maxia of Continuent. MySQL replication is single threaded. Multi-master replication is complex with MySQL. Circular replication works but is very fragile. Once you've achieved the feat, how do you avoid conflicts? The lack of global transaction ID today also means you may have slaves that may not be synchronized\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1576,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2009\/08\/23\/mysql-labs","url_meta":{"origin":2292,"position":1},"title":"MySQL Labs","date":"23\/8\/2009","format":false,"excerpt":"Who remembers snaps? This is the place to go, when you wanted nightly source code snapshots of stuff that comes out of MySQL AbSun Microsystems build systems, that is related to the MySQL product line. There you can get all the snapshots for GA releases, as well as archives; (albeit\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1689,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2010\/02\/23\/recently-in-mariadb-1","url_meta":{"origin":2292,"position":2},"title":"Recently in MariaDB #1","date":"23\/2\/2010","format":false,"excerpt":"The aims of this kind of blog post is simple - I want to help keep the masses informed as to what's happening with MariaDB, as a whole. There is a community growing, and MariaDB is a community project, not necessarily a Monty Program Ab baby (and we're clear on\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":375,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/03\/05\/mysql-51-ipod-nano-giveaway-winner-1","url_meta":{"origin":2292,"position":3},"title":"MySQL 5.1 iPod Nano giveaway, winner #1","date":"5\/3\/2006","format":false,"excerpt":"Congratulations to Giuseppe Maxia, who's won himself an iPod Nano! Giuseppe has been actively submitting bug reports for MySQL 5.1, plus he's got an interesting blog (syndicated at Planet MySQL), mentioning new features that are available in MySQL 5.1. Of interest, is your performance related post on Partitioning. To add\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":716,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/02\/14\/mysql-miniconf-videos-from-linuxconfau-2008","url_meta":{"origin":2292,"position":4},"title":"MySQL Miniconf videos, from linux.conf.au 2008","date":"14\/2\/2008","format":false,"excerpt":"If you couldn't make the MySQL MiniConf at linux.conf.au 2008, no worries - there's recorded video!Upcoming MySQL Features (Stewart Smith) - focused on the future, as opposed to what's available right now\/soonMySQL Indexing Methods (Jonathon Coombes) AND MySQL Optimisation by Design (Arjen Lentz)- the slides are viewable from the video,\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1579,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2009\/08\/27\/sharding-for-the-masses-introducing-the-spider-storage-engine","url_meta":{"origin":2292,"position":5},"title":"Sharding for the masses: Introducing the SPIDER storage engine (OpenSQLCamp @ FrOSCon)","date":"27\/8\/2009","format":false,"excerpt":"This is the Sharding for the masses: Introducing the SPIDER storage engine by Giuseppe Maxia, given at OpenSQLCamp, at FrOSCon, in August 2009. These are somewhat live notes, and the slides are available too. Sharding for the massesView more documents from Giuseppe Maxia. Why sharding? Scaling, of course. The MySQL\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2292"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=2292"}],"version-history":[{"count":2,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2292\/revisions"}],"predecessor-version":[{"id":2294,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/2292\/revisions\/2294"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=2292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=2292"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=2292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}