{"id":1131,"date":"2008-07-01T09:48:07","date_gmt":"2008-06-30T23:48:07","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=1131"},"modified":"2013-12-18T08:47:27","modified_gmt":"2013-12-17T22:47:27","slug":"mysql-encrypted-online-backup-preview-1","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/01\/mysql-encrypted-online-backup-preview-1\/","title":{"rendered":"MySQL Encrypted Online Backup Preview 1"},"content":{"rendered":"<p>I&#8217;ve just pushed to launchpad, a set of patches that implement AES encryption support for MySQL Online Backup. You will need to build &#8211;with-ssl to get support for encrypted online backup.<\/p>\n<p>Encrypted backup files have no recognisable header &#8211; they&#8217;re just a stream of random bytes. Encryption and compression also works, and when you encrypt, you should also use compression (compress first, then encrypt).<\/p>\n<p>Source tree: <a href=\"https:\/\/code.launchpad.net\/~stewart\/mysql-server\/stew-encrypted-backup-preview1\">https:\/\/code.launchpad.net\/~stewart-flamingspork\/mysql-server\/stew-encrypted-backup-preview1<\/a><\/p>\n<p>Bzr command:              <tt>bzr branch lp:~stewart-flamingspork\/mysql-server\/stew-encrypted-backup-preview1<\/tt><\/p>\n<p>Thread on internals@ with patchset: <a href=\"http:\/\/lists.mysql.com\/internals\/35759\">http:\/\/lists.mysql.com\/internals\/35759<\/a><\/p>\n<p>Build instructions: be sure to .\/configure &#8211;with-ssl<\/p>\n<p>Example usage:<\/p>\n<ul>\n<li>BACKUP DATABASE test TO &#8216;test.ba&#8217; ENCRYPTION_ALGORITHM=aes PASSWORD=&#8217;pants&#8217;;<\/li>\n<li>BACKUP DATABASE test TO &#8216;test1.ba&#8217; WITH COMPRESSION COMPRESSION_ALGORITHM=gzip ENCRYPTION_ALGORITHM=aes PASSWORD=&#8217;pants&#8217;;<\/li>\n<li>RESTORE FROM &#8216;test.ba&#8217; ENCRYPTION_ALGORITHM=aes PASSWORD=&#8217;pants&#8217;;<\/li>\n<li>RESTORE FROM &#8216;test1.ba&#8217; ENCRYPTION_ALGORITHM=aes PASSWORD=&#8217;pants&#8217;;<\/li>\n<\/ul>\n<p><strong>UPDATE: <\/strong>preview1 is no more, preview2 is now out, contains extra stuff (see next blog post)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve just pushed to launchpad, a set of patches that implement AES encryption support for MySQL Online Backup. You will need to build &#8211;with-ssl to get support for encrypted online backup. Encrypted backup files have no recognisable header &#8211; they&#8217;re &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2008\/07\/01\/mysql-encrypted-online-backup-preview-1\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","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_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":[1],"tags":[],"class_list":["post-1131","post","type-post","status-publish","format-standard","hentry","category-general"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-if","jetpack-related-posts":[{"id":1133,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/01\/encrypted-online-backup-preview-2-des-and-aes\/","url_meta":{"origin":1131,"position":0},"title":"Encrypted Online Backup Preview 2 (DES and AES)","author":"Stewart Smith","date":"2008-07-01","format":false,"excerpt":"New preview includes: 3DES support AES support with 128 (default), 192 or 256 bit keysize bzr branch lp:~stewart-flamingspork\/mysql-server\/stew-encrypted-backup-preview2 (you can pull this directly into the previous preview1 branch, it's just 2 extra patches). Examples: BACKUP DATABASE test to 'test.ba' ENCRYPTION_ALGORITHM=3des PASSWORD='pants'; RESTORE FROM 'test.ba' ENCRYPTION_ALGORITHM=3des PASSWORD='pants'; BACKUP DATABASE test to\u2026","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1145,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/10\/wl4271-encrypted-online-backup-preview-3\/","url_meta":{"origin":1131,"position":1},"title":"WL4271 Encrypted Online Backup: Preview 3","author":"Stewart Smith","date":"2008-07-10","format":false,"excerpt":"\u00e2\u20ac\u0153WL4271 Encrypted Online Backup: Preview 3\u00e2\u20ac\u009d branch in Launchpad Now with Windows support. Many thanks to Chuck Bell for helping get the code going on Windows. We can however, all sit around dumbfounded as to how Windows has so little of a POSIX like layer and yet doesn't define ENOTSUP.\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1111,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/05\/27\/encrypted-online-backup-design-thoughts-ask-the-lazyweb\/","url_meta":{"origin":1131,"position":2},"title":"Encrypted Online Backup (design, thoughts, ask-the-lazyweb)","author":"Stewart Smith","date":"2008-05-27","format":false,"excerpt":"So after a ever so temporary but loud moment of insanity[1] having a decision made which I very strongly disagreed with (wanting to release online encrypted backup as closed source), we're back in the world of freedom and the MySQL Server is (and will be) free and open source software\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1153,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/18\/mysql-online-backup-with-encryption-preview-release\/","url_meta":{"origin":1131,"position":3},"title":"MySQL Online Backup with Encryption Preview Release","author":"Stewart Smith","date":"2008-07-18","format":false,"excerpt":"Head on over to the OnlineBackup - MySQL Forge Wiki and your able to get a built preview release with Encryption support. I welcome and encourage feedback!OnlineBackup - MySQL Forge Wiki","rel":"","context":"In &quot;General&quot;","block_context":{"text":"General","link":"https:\/\/www.flamingspork.com\/blog\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2468,"url":"https:\/\/www.flamingspork.com\/blog\/2012\/03\/09\/sessions-at-the-percona-live-mysql-conference-that-interest-me\/","url_meta":{"origin":1131,"position":4},"title":"Sessions at the Percona Live MySQL Conference that interest me","author":"Stewart Smith","date":"2012-03-09","format":false,"excerpt":"For the past many years, there's been a conference in April, at the Santa Clara Convention Centre where the topic has been MySQL and the surrounding ecosystem. The first year I went, I gave a talk on the new features in MySQL Cluster 5.1 to a overflowing room of attendees.\u2026","rel":"","context":"In &quot;mysql&quot;","block_context":{"text":"mysql","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/mysql\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2406,"url":"https:\/\/www.flamingspork.com\/blog\/2011\/10\/03\/speaking-at-percona-live-london-2011-on-drizzle\/","url_meta":{"origin":1131,"position":5},"title":"Speaking at Percona Live London 2011 (on Drizzle!)","author":"Stewart Smith","date":"2011-10-03","format":false,"excerpt":"Both Henrik and myself will be at Percona Live London 2011 in late October speaking on the wonderful Drizzle database server. Other speakers at the conference will be talking about a wide range of topics surrounding the MySQL ecosystem including performance monitoring, backup, search, scaling and data recovery. P.S. I\u2026","rel":"","context":"In &quot;drizzle&quot;","block_context":{"text":"drizzle","link":"https:\/\/www.flamingspork.com\/blog\/category\/work-et-al\/drizzle-work-et-al\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/comments?post=1131"}],"version-history":[{"count":1,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1131\/revisions"}],"predecessor-version":[{"id":3587,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1131\/revisions\/3587"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=1131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=1131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=1131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}