{"id":12790,"date":"2010-07-23T16:03:40","date_gmt":"2010-07-23T14:03:40","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=12790"},"modified":"2010-07-23T16:03:40","modified_gmt":"2010-07-23T14:03:40","slug":"on-scalability-of-mysql","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2010\/07\/23\/on-scalability-of-mysql\/","title":{"rendered":"On scalability of MySQL"},"content":{"rendered":"\n

Anyone who says that MySQL is not scalable has no idea. \u00a0Facebook is one of the examples for a large deployment of MySQL<\/a>:<\/p>\n

How big is Facebook\u2019s Internet infrastructure? Facebook VP of Technology Jeff Rothschild provided some details in a panel at the recent MySQL user conference. Rothschild says Facebook is now running 10,000 servers, including 1,800 MySQL servers that are overseen by just two database administrators<\/strong>.<\/p><\/blockquote>\n

Facebook recently surpassed 500,000,000 users – half a billion!<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n

Anyone who says that MySQL is not scalable has no idea. \u00a0Facebook is one of the examples for a large deployment of MySQL: How big is Facebook\u2019s Internet infrastructure? Facebook VP of Technology Jeff Rothschild provided some details in a panel at the recent MySQL user conference. Rothschild says Facebook is now running 10,000 servers, … Continue reading On scalability of MySQL<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_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},"_links_to":"","_links_to_target":""},"categories":[1,133,62],"tags":[1559,2271,3066,1281],"keyring_services":[],"class_list":["post-12790","post","type-post","status-publish","format-standard","hentry","category-general","category-sysadmin","category-technology","tag-databases","tag-facebook","tag-mysql","tag-scalability"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":28625,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/06\/11\/why-uber-engineering-switched-from-postgres-to-mysql\/","url_meta":{"origin":12790,"position":0},"title":"Why Uber Engineering Switched from Postgres to MySQL","author":"Leonid Mamchenkov","date":"June 11, 2018","format":false,"excerpt":"\"Why Uber Engineering Switched from Postgres to MySQL\" is an interesting study with plenty of technical detail of how MySQL was a better choice than PostgreSQL for the very demanding growth of Uber.\u00a0 These kinds of issues are probably way out of scope for any \"regular Joe\" application, but the\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/06\/MySQL-indexes-500x243.png?resize=350%2C200&ssl=1","width":350,"height":200},"classes":[]},{"id":16834,"url":"https:\/\/mamchenkov.net\/wordpress\/2012\/10\/12\/fixing-mysql-error-cannot-load-from-mysql-proc-the-table-is-probably-corrupted\/","url_meta":{"origin":12790,"position":1},"title":"Fixing MySQL error “Cannot load from mysql.proc. The table is probably corrupted”","author":"Leonid Mamchenkov","date":"October 12, 2012","format":"link","excerpt":"Fixing MySQL error \"Cannot load from mysql.proc. The table is probably corrupted\" After a recent upgrade of some of my CentOS 6.3 servers to MySQL 5.5 from the Remi repository, I started noticing errors like this one in the logs, especially during backups: MySQL: SHOW FUNCTION STATUS WHERE Db =\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":10424,"url":"https:\/\/mamchenkov.net\/wordpress\/2006\/08\/25\/guy-kawasaki-interviews-marten-mikos-ceo-of-mysql\/","url_meta":{"origin":12790,"position":2},"title":"Guy Kawasaki interviews Marten Mikos, CEO of MySQL","author":"Leonid Mamchenkov","date":"August 25, 2006","format":false,"excerpt":"As usual, Guy Kawasaki does an excellent job with his Ten Questions with series. This time he talks to Marten Mikos, CEO of MySQL. Even though the interview is short, there are so many things I'd like to quote. Really. Here they are. I'll try to limit myself. You better\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":23757,"url":"https:\/\/mamchenkov.net\/wordpress\/2015\/03\/24\/mysql-in-star-topology\/","url_meta":{"origin":12790,"position":3},"title":"MySQL in star topology","author":"Leonid Mamchenkov","date":"March 24, 2015","format":"link","excerpt":"MySQL in star topology","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":24,"url":"https:\/\/mamchenkov.net\/wordpress\/2002\/03\/08\/mysql-password-recovery\/","url_meta":{"origin":12790,"position":4},"title":"MySQL password recovery","author":"Leonid Mamchenkov","date":"March 8, 2002","format":false,"excerpt":"It often happens so that administrator's password for MySQL is lost or forgotten. The easiest way to fix the problem is to open \/var\/lib\/mysql\/mysql\/user.MYD in hex editor and replace the encrypted string near \"localhost root\" with spaces. Then mysql service should be restarted, and that's it.","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":27380,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/03\/02\/mysql-8-is-coming\/","url_meta":{"origin":12790,"position":5},"title":"MySQL 8 is coming","author":"Leonid Mamchenkov","date":"March 2, 2017","format":false,"excerpt":"OpenSource.com covers the upcoming release of the MySQL 8. What happened to 6 & 7? Years ago, before the Sun Microsystems purchase of MySQL AB, there was a version of MySQL with the number 6. Sadly, it was a bit ambitious and the change of ownership left it to wither.\u2026","rel":"","context":"In "All"","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/12790","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/comments?post=12790"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/12790\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=12790"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=12790"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=12790"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=12790"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}