{"id":1308,"date":"2009-02-06T00:31:07","date_gmt":"2009-02-06T05:31:07","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=1308"},"modified":"2009-02-06T00:31:07","modified_gmt":"2009-02-06T05:31:07","slug":"incremental-backup-that-uses-mysql","status":"publish","type":"post","link":"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql","title":{"rendered":"Incremental backup that uses MySQL"},"content":{"rendered":"<p>A while back, Ted Ts&#8217;o asked for a <a href=\"http:\/\/thunk.org\/tytso\/blog\/2009\/01\/12\/wanted-incremental-backup-solutions-that-use-a-database\/\">incremental backup solution that used a database<\/a>. It reminded me of the talk at the 2009 MySQL Conference &#038; Expo, titled <a href=\"http:\/\/en.oreilly.com\/mysql2009\/public\/schedule\/detail\/6876\">Build your own MySQL time machine<\/a>.<\/p>\n<p>Chuck and <a href=\"http:\/\/mysqlmusings.blogspot.com\/\">Mats<\/a> will talk about the backup and replication code, and will show off a web interface, that allows you to go back in time, similar to Apple&#8217;s Time Machine in Mac OS X. Its a talk that I most certainly want to attend, as an avid Time Machine user.<\/p>\n<hr \/>\n<p><a href=\"https:\/\/en.oreilly.com\/mysql2009\/public\/register\">Register<\/a> for the MySQL Conference &#038; Expo 2009 before February 16, and you&#8217;ll get an early bird discount (saving $200). April 20-23 2009 will be a rocking few days, see you there.<\/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%20Incremental%20backup%20that%20uses%20MySQL&body=https%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F02%2F06%2Fincremental-backup-that-uses-mysql&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=\"d2604203e9\" data-email-share-track-url=\"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1308\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql?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-1308\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql?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-1308\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql?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>A while back, Ted Ts&#8217;o asked for a incremental backup solution that used a database. It reminded me of the talk at the 2009 MySQL Conference &#038; Expo, titled Build your own MySQL time machine. Chuck and Mats will talk about the backup and replication code, and will show off a web interface, that allows [&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%20Incremental%20backup%20that%20uses%20MySQL&body=https%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2009%2F02%2F06%2Fincremental-backup-that-uses-mysql&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=\"d2604203e9\" data-email-share-track-url=\"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1308\" class=\"share-facebook sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql?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-1308\" class=\"share-linkedin sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql?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-1308\" class=\"share-twitter sd-button share-icon\" href=\"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/06\/incremental-backup-that-uses-mysql?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":"open","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":[710,709,708,711,1775,396],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-l6","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":397,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2006\/04\/27\/the-migration-bof","url_meta":{"origin":1308,"position":0},"title":"The Migration BoF","date":"27\/4\/2006","format":false,"excerpt":"\"No, you can't run a Migration BoF, and it won't make sense without a few of our migration experts,\" he exclaimed with a petulant expression. Well, it turns out the migration BoF was actually quite good at the MySQL UC. It turns out, that everyone attending thought that it was\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":961,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2008\/08\/26\/a-video-of-online-backup","url_meta":{"origin":1308,"position":1},"title":"A video of online backup","date":"26\/8\/2008","format":false,"excerpt":"Robin just wrote a new article, titled A Quick Look at MySQL 6.0's New Backup, and I thought, that maybe you'd like to also see this in presentation\/video format... At OSCON, Giuseppe actually gave a quick talk at the Sun booth, about our online backup. He also showed how to\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":809,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2008\/05\/03\/playing-with-mysqls-online-backup","url_meta":{"origin":1308,"position":2},"title":"Playing with MySQL&#8217;s Online Backup","date":"3\/5\/2008","format":false,"excerpt":"Something that has excited me for a long time with upcoming features in the MySQL Server, is online backup. Since seeing it first being demonstrated by Chuck Bell at the Heidelberg Developers Conference in 2007, I've been enthralled. Now you too, can try online backup. If you've not read the\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1347,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2009\/02\/24\/on-magnolia-and-data-recovery","url_meta":{"origin":1308,"position":3},"title":"On Ma.gnolia, and data recovery","date":"24\/2\/2009","format":false,"excerpt":"There's a good podcast from Chris Messina and Larry Halff, about what really happened at Ma.gnolia. If you're at all interested in what happened (i.e. how did they lose all their bookmark data), don't hesitate to watch the video. I took some quick notes: half a terabyte database file got\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3129,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/09\/rackspace-cloud-high-availability-databases-for-mariadb-mysql-percona-server","url_meta":{"origin":1308,"position":4},"title":"Rackspace Cloud High Availability Databases for MariaDB, MySQL, Percona Server","date":"9\/11\/2015","format":false,"excerpt":"Continuing on with the cloud theme, I think its worth noting that since mid-2014, Rackspace has offered MariaDB (as well as MySQL and\u00a0Percona Server) in the cloud, as part of their Cloud Databases offering. It\u2019s powered by OpenStack. Now there is an additional \u201cHigh Availability instance\u201d being offered \u2013 this\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1638,"url":"https:\/\/www.bytebot.net\/blog\/archives\/2010\/01\/12\/some-mysql-related-links","url_meta":{"origin":1308,"position":5},"title":"Some MySQL-related links","date":"12\/1\/2010","format":false,"excerpt":"Check out how Linden Labs, creators of the popular game Second Life, upgraded their MySQL database. The MySQL they use? Straight out of Debian! Of course, now, they're running with the Percona patchset, against MySQL 5.0.84. Definitely a good read. Its good to see Lars post about contributing to the\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1308"}],"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=1308"}],"version-history":[{"count":1,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1308\/revisions"}],"predecessor-version":[{"id":1309,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1308\/revisions\/1309"}],"wp:attachment":[{"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=1308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=1308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=1308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}