{"id":1145,"date":"2008-07-10T18:07:06","date_gmt":"2008-07-10T08:07:06","guid":{"rendered":"http:\/\/www.flamingspork.com\/blog\/?p=1145"},"modified":"2013-12-18T08:47:42","modified_gmt":"2013-12-17T22:47:42","slug":"wl4271-encrypted-online-backup-preview-3","status":"publish","type":"post","link":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/10\/wl4271-encrypted-online-backup-preview-3\/","title":{"rendered":"WL4271 Encrypted Online Backup: Preview 3"},"content":{"rendered":"<p><a href=\"https:\/\/code.launchpad.net\/~stewart\/mysql-server\/mysql-6.0-backup-encrypted-preview3\">\u00e2\u20ac\u0153WL4271 Encrypted Online Backup: Preview 3\u00e2\u20ac\u009d branch in Launchpad<\/a><\/p>\n<p>Now with Windows support. Many thanks to Chuck Bell for helping get the code going on Windows.<\/p>\n<p>We can however, all sit around dumbfounded as to how Windows has so little of a POSIX like layer and yet doesn&#8217;t define ENOTSUP.<\/p>\n<p>As a refresher, this tree implements:<\/p>\n<ul>\n<li>Encryption for MySQL Online backup<\/li>\n<li>Algorithms and keysizes supported:\n<ul>\n<li>3DES<\/li>\n<li>AES (128, 192 and 256bit)<\/li>\n<\/ul>\n<\/li>\n<li>World peace<\/li>\n<\/ul>\n<p>(world peace not included)<\/p>\n<p><strong>UPDATE:<\/strong> If you&#8217;re wondering why the branch isn&#8217;t there, it&#8217;s <strong>still<\/strong> pushing to launchpad. Yes, that&#8217;s <strong>over 7 hours<\/strong> to push a branch. ick. Can&#8217;t be too much longer, surely. I cannot wait until lp uses shared repos.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\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 &hellip; <a href=\"https:\/\/www.flamingspork.com\/blog\/2008\/07\/10\/wl4271-encrypted-online-backup-preview-3\/\">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":[14],"tags":[117,628],"class_list":["post-1145","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-backup","tag-mysql"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p5a6n8-it","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":1145,"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":1131,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/07\/01\/mysql-encrypted-online-backup-preview-1\/","url_meta":{"origin":1145,"position":1},"title":"MySQL Encrypted Online Backup Preview 1","author":"Stewart Smith","date":"2008-07-01","format":false,"excerpt":"I've just pushed to launchpad, a set of patches that implement AES encryption support for MySQL Online Backup. You will need to build --with-ssl to get support for encrypted online backup. Encrypted backup files have no recognisable header - they're just a stream of random bytes. Encryption and compression also\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":1175,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/08\/21\/mysql-cluster-64-windows-tree-branch-in-launchpad\/","url_meta":{"origin":1145,"position":2},"title":"\u00e2\u20ac\u0153MySQL Cluster 6.4 Windows tree\u00e2\u20ac\u009d branch in Launchpad","author":"Stewart Smith","date":"2008-08-21","format":false,"excerpt":"\u00e2\u20ac\u0153MySQL Cluster 6.4 Windows tree\u00e2\u20ac\u009d branch in Launchpad That's right folks, I'm pushing up patches for MySQL Cluster on Windows. This tree is incomplete, and no promises on when enough will be pushed for it to even compile on Windows. Tree is updated when launchpad pulls from our internal tree.","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":1177,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/08\/22\/ndb_mgmexe-builds-and-works-in-mysql-51-telco-64-win\/","url_meta":{"origin":1145,"position":3},"title":"ndb_mgm.exe builds (and works) in mysql-5.1-telco-6.4-win","author":"Stewart Smith","date":"2008-08-22","format":false,"excerpt":"\u00e2\u20ac\u0153MySQL Cluster 6.4 Windows tree\u00e2\u20ac\u009d branch in Launchpad (which really should have the -fail suffix... but anyway) In what will (soon) be mirrored to launchpad, all but 17 targets (yeah, working on that... but it's out of 130 or something) build. Not only that, I've used the management client (ndb_mgm.exe)\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":1145,"position":4},"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":1111,"url":"https:\/\/www.flamingspork.com\/blog\/2008\/05\/27\/encrypted-online-backup-design-thoughts-ask-the-lazyweb\/","url_meta":{"origin":1145,"position":5},"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":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1145","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=1145"}],"version-history":[{"count":2,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1145\/revisions"}],"predecessor-version":[{"id":3589,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/posts\/1145\/revisions\/3589"}],"wp:attachment":[{"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/media?parent=1145"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/categories?post=1145"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.flamingspork.com\/blog\/wp-json\/wp\/v2\/tags?post=1145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}