{"id":3491,"date":"2019-11-10T22:22:41","date_gmt":"2019-11-10T14:22:41","guid":{"rendered":"https:\/\/www.bytebot.net\/blog\/?p=3491"},"modified":"2019-11-10T22:22:41","modified_gmt":"2019-11-10T14:22:41","slug":"database-tab-sweep","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep","title":{"rendered":"Database Tab Sweep"},"content":{"rendered":"<p>I miss a proper database related newsletter for busy people. There&#8217;s so much happening in the space, from tech, to licensing, and even usage. Anyway, quick tab sweep.<\/p>\n<p>Paul Vall\u00e9e (of Pythian fame) has been working on Tehama for sometime, and now he gets to do it full time as a PE firm, bought control of Pythian&#8217;s services business. Pythian has more than 350 employees, and 250 customers, and raised capital before. More at <a href=\"https:\/\/www.theglobeandmail.com\/business\/article-ottawas-pythian-splits-in-two-as-ceo-and-founder-paul-vallee-departs\/\">Ottawa\u2019s Pythian spins out software platform Tehama<\/a>.<\/p>\n<p><a href=\"https:\/\/www.zdnet.com\/article\/database-leaks-data-on-most-of-ecuadors-citizens-including-6-7-million-children\/\">Database leaks data on most of Ecuador&#8217;s citizens, including 6.7 million children<\/a> &#8211; ElasticSearch.<\/p>\n<p>Percona has <a href=\"https:\/\/www.percona.com\/blog\/2019\/09\/17\/percona-distribution-for-postgresql-the-best-enterprise-level-components-from-one-source\/\">launched<\/a> <a href=\"https:\/\/www.percona.com\/software\/postgresql-distribution\">Percona Distribution for PostgreSQL<\/a> 11. This means they have servers for MySQL, MongoDB, and now PostgreSQL. Looks very much like a packaged server with tools from 3rd parties (<a href=\"https:\/\/github.com\/percona\/postgres-packaging\">source<\/a>). <\/p>\n<p>Severalnines has <a href=\"https:\/\/severalnines.com\/database-blog\/announcing-beta-launch-backup-ninja\">launched<\/a> Backup Ninja, an agent-based SaaS service to backup popular databases in the cloud. <a href=\"https:\/\/backup.ninja\/\">Backup.Ninja<\/a> (cool URL) supports MySQL (and variants), MongoDB, PostgreSQL and TimeScale. No pricing available, but it is free for 30 days.<\/p>\n<p><a href=\"https:\/\/www.prisma.io\/blog\/comparison-of-database-models-1iz9u29nwn37\">Comparing Database Types: How Database Types Evolved to Meet Different Needs<\/a><\/p>\n<p><a href=\"https:\/\/pgdash.io\/blog\/postgres-12-generated-columns.html\">New In PostgreSQL 12: Generated Columns<\/a> &#8211; anyone doing a comparison with MariaDB Server or MySQL?<\/p>\n<p><a href=\"https:\/\/aws.amazon.com\/blogs\/aws\/migration-complete-amazons-consumer-business-just-turned-off-its-final-oracle-database\/\">Migration Complete \u2014 Amazon\u2019s Consumer Business Just Turned off its Final Oracle Database<\/a> &#8211; a huge deal as they migrated 75 petabytes of internal data to DynamoDB, Aurora, RDS and Redshift. Amazon, powered by AWS, and a big win for open source (a lot of these services are built-on open source).<\/p>\n<p><a href=\"https:\/\/www.prnewswire.com\/news-releases\/mongodb-and-alibaba-cloud-launch-new-partnership-300947696.html\">MongoDB and Alibaba Cloud Launch New Partnership<\/a> &#8211; I see this as a win for the SSPL relicense. It is far too costly to maintain a drop-in compatible fork, in a single company (Hi <a href=\"https:\/\/aws.amazon.com\/documentdb\/\">Amazon DocumentDB<\/a>!). Maybe if the PostgreSQL layer gets open sourced, there is a chance, but otherwise, all good news for Alibaba and MongoDB. <\/p>\n<p><a href=\"https:\/\/mysqlserverteam.com\/the-mysql-8-0-18-maintenance-release-is-generally-available\/\">MySQL 8.0.18<\/a> brings hash join, <a href=\"https:\/\/mysqlserverteam.com\/mysql-explain-analyze\/\">EXPLAIN ANALYZE<\/a>, and more interestingly, HashiCorp Vault support for <a href=\"https:\/\/mysqlserverteam.com\/mysql-keyring-now-speaks-hashicorp-vault\/\">MySQL Keyring<\/a>. (Percona has an <a href=\"https:\/\/www.percona.com\/doc\/percona-server\/5.7\/management\/data_at_rest_encryption.html\">open source variant<\/a>). <\/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%20Database%20Tab%20Sweep&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2019%2F11%2F10%2Fdatabase-tab-sweep&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=\"dbc6f29d4a\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3491\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep?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-3491\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep?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-3491\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep?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>I miss a proper database related newsletter for busy people. There&#8217;s so much happening in the space, from tech, to licensing, and even usage. Anyway, quick tab sweep. Paul Vall\u00e9e (of Pythian fame) has been working on Tehama for sometime, and now he gets to do it full time as a PE firm, bought control [&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%20Database%20Tab%20Sweep&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2019%2F11%2F10%2Fdatabase-tab-sweep&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=\"dbc6f29d4a\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3491\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep?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-3491\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep?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-3491\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2019\/11\/10\/database-tab-sweep?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":[1836,23],"tags":[710,1958,1413,1775,45,1957],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-Uj","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3222,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/05\/31\/speaking-in-june-2016","url_meta":{"origin":3491,"position":0},"title":"Speaking in June 2016","date":"31\/5\/2016","format":false,"excerpt":"I have a few upcoming speaking engagements in June 2016: Nerdear.la - June 9-10 2016 - Buenos Aires, Argentina - never been to this event but MariaDB Corporation are sponsors and I'm quite excited to be back in Buenos Aires. I'm going to talk about the MySQL ecosystem in 2016.\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3413,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2018\/01\/02\/premier-open-source-database-conference-call-for-papers-closing-january-12-2018","url_meta":{"origin":3491,"position":1},"title":"Premier Open Source Database Conference Call for Papers closing January 12 2018","date":"2\/1\/2018","format":false,"excerpt":"The call for papers for Percona Live Santa Clara 2018 was extended till January 12 2018. This means you still have time to get a submission in. Topics of interest: MySQL, MongoDB, PostgreSQL & other open source databases. Don't forget all the upcoming databases too (there's a long list at\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2920,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2014\/04\/30\/the-importance-of-having-a-working-knowledge-of-your-products","url_meta":{"origin":3491,"position":2},"title":"The importance of having a working knowledge of your products","date":"30\/4\/2014","format":false,"excerpt":"Rob Young is back in the MySQL ecosystem (now working at Percona), but he was previously at MongoDB (formerly known as 10gen), and he made a really interesting observation: 10gen places a huge importance on all employees having a working technical knowledge of its products.\u00a0 I joined 10gen with years\u2026","rel":"","context":"In &quot;General&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3278,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/08\/20\/speaking-in-august-2016","url_meta":{"origin":3491,"position":3},"title":"Speaking in August 2016","date":"20\/8\/2016","format":false,"excerpt":"I know this is a tad late, but there have been some changes, etc. recently, so apologies for the delay of this post. I still hope to meet many of you to chat about MySQL\/Percona Server\/MariaDB Server, MongoDB, open source databases, and open source in general in the remainder of\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3292,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/11\/11\/cfp-for-percona-live-santa-clara-closes-november-13","url_meta":{"origin":3491,"position":4},"title":"CfP for Percona Live Santa Clara closes November 13!","date":"11\/11\/2016","format":false,"excerpt":"At Percona Live Amsterdam recently, the conference expanded beyond just its focus areas of MySQL & its ecosystem and MongoDB to also include PostgreSQL and other open source databases (just look at the recent poll). The event was a sold out success. This will continue for Percona Live Santa Clara\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"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":3491,"position":5},"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":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3491"}],"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=3491"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3491\/revisions"}],"predecessor-version":[{"id":3492,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3491\/revisions\/3492"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=3491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=3491"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=3491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}