{"id":3397,"date":"2017-10-12T13:13:01","date_gmt":"2017-10-12T05:13:01","guid":{"rendered":"https:\/\/www.bytebot.net\/blog\/?p=3397"},"modified":"2017-10-12T13:13:01","modified_gmt":"2017-10-12T05:13:01","slug":"not-all-cloud-instances-are-created-equal","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal","title":{"rendered":"Not all cloud instances are created equal"},"content":{"rendered":"<p>You know how anecdotally we say, &#8220;in the cloud, bad nodes exist&#8221; so you should always get a baseline? <\/p>\n<p>Today I ran a query (repeatedly) on <code>sqlite3<\/code>, and on two instances, I got time measured as:<\/p>\n<pre><code>Run Time: real 13.405 user 13.243332 sys 0.046667\nRun Time: real 10.989 user 10.963332 sys 0.010000\n<\/code><\/pre>\n<p>This naturally skewed results I initially got for something related to MySQL\/MariaDB benchmarking. It really was such that while I had 2 instances, in the same region\/AZ, I had one &#8220;good&#8221; node and one &#8220;bad&#8221; node.<\/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%20Not%20all%20cloud%20instances%20are%20created%20equal&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2017%2F10%2F12%2Fnot-all-cloud-instances-are-created-equal&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=\"4f59c36bff\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3397\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal?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-3397\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal?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-3397\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal?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>You know how anecdotally we say, &#8220;in the cloud, bad nodes exist&#8221; so you should always get a baseline? Today I ran a query (repeatedly) on sqlite3, and on two instances, I got time measured as: Run Time: real 13.405 user 13.243332 sys 0.046667 Run Time: real 10.989 user 10.963332 sys 0.010000 This naturally skewed [&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%20Not%20all%20cloud%20instances%20are%20created%20equal&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2017%2F10%2F12%2Fnot-all-cloud-instances-are-created-equal&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=\"4f59c36bff\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-3397\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal?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-3397\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal?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-3397\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2017\/10\/12\/not-all-cloud-instances-are-created-equal?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":[1503],"tags":[1911,353,1910],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-SN","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":3129,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2015\/11\/09\/rackspace-cloud-high-availability-databases-for-mariadb-mysql-percona-server","url_meta":{"origin":3397,"position":0},"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":1026,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/16\/learn2scale-whats-up-with-malaysian-news-sites-will-the-cloud-work-for-them","url_meta":{"origin":3397,"position":1},"title":"learn2scale &#8211; what&#8217;s up with Malaysian news sites? Will the cloud work for them?","date":"16\/9\/2008","format":false,"excerpt":"Seriously kids, what's with the lack of scalability? I've never seen CNN or the NYTimes go down on \"trimmed\" versions. Is it a question of bandwidth? Is it lack of hardware? Take for example, Malaysiakini (the first alternative news source in Malaysia, with a subscription model built around it). It\u2026","rel":"","context":"In &quot;General&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":440,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2006\/11\/02\/core-data-and-mysql-as-a-data-store","url_meta":{"origin":3397,"position":2},"title":"Core Data and MySQL as a data store?","date":"2\/11\/2006","format":false,"excerpt":"I've been thinking a lot about Core Data recently. It supports SQLite out of the box, and its rather scalable and fast. Main reason being sqlite3 is included on every desktop and server of OS X that has shipped since 10.4 (Tiger). It got me thinking about using MySQL as\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3182,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/02\/29\/amazon-rds-updates-february-2016","url_meta":{"origin":3397,"position":3},"title":"Amazon RDS updates February 2016","date":"29\/2\/2016","format":false,"excerpt":"I think one of the big announcements that came out from the Amazon Web Services world in October 2015 was the fact that you could spin up instances of MariaDB Server on it. You would get MariaDB Server 10.0.17. As of this writing, you are still getting that (the MySQL\u2026","rel":"","context":"In &quot;MariaDB&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":769,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/04\/10\/a-slice-of-wednesday-5-must-see-talks","url_meta":{"origin":3397,"position":4},"title":"A slice of Wednesday &#8211; 5 must-see talks","date":"10\/4\/2008","format":false,"excerpt":"A session at the MySQL Conference 2008 that I'd have loved to attend, would have been the Adopting and Adapting OSS at Shinsei Bank. As a case study, Shinsei Bank in Japan is a great MySQL customer and use case - they're a bank. A pretty large bank... Sadly, the\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":260,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2005\/01\/08\/fc3ppc-review-at-ppcnerds-specifixppc","url_meta":{"origin":3397,"position":5},"title":"FC3\/ppc review at ppcnerds; specifix\/ppc","date":"8\/1\/2005","format":false,"excerpt":"Seems the FC-3\/ppc test tree got a little review at ppcnerds. Just a few minor\/quick comments. You can extract boot.iso from the CD1 - just loop mount it. Installation is best done via NFS, as the guide tells you to. Otherwise, its a case of paperclip eject and if you\u2026","rel":"","context":"In &quot;General&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\/3397"}],"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=3397"}],"version-history":[{"count":1,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3397\/revisions"}],"predecessor-version":[{"id":3398,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/3397\/revisions\/3398"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=3397"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=3397"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=3397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}