{"id":23757,"date":"2015-03-24T11:04:24","date_gmt":"2015-03-24T09:04:24","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=23757"},"modified":"2015-03-24T11:04:24","modified_gmt":"2015-03-24T09:04:24","slug":"mysql-in-star-topology","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2015\/03\/24\/mysql-in-star-topology\/","title":{"rendered":"MySQL in star topology"},"content":{"rendered":"<!-- google_ad_section_start -->\n<p><a href=\"http:\/\/stackoverflow.com\/questions\/5273043\/mysql-in-star-topology\">MySQL in star topology<\/a><\/p>\n<!-- google_ad_section_end -->\n","protected":false},"excerpt":{"rendered":"<!-- google_ad_section_start -->\n<p>MySQL in star topology<\/p>\n<!-- google_ad_section_end -->\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"link","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":"MySQL in star topology #MySQL #database #SysAdmin","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"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,3066],"keyring_services":[],"class_list":["post-23757","post","type-post","status-publish","format-link","hentry","category-general","category-sysadmin","category-technology","tag-databases","tag-mysql","post_format-post-format-link"],"aioseo_notices":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":12790,"url":"https:\/\/mamchenkov.net\/wordpress\/2010\/07\/23\/on-scalability-of-mysql\/","url_meta":{"origin":23757,"position":0},"title":"On scalability of MySQL","author":"Leonid Mamchenkov","date":"July 23, 2010","format":false,"excerpt":"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\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28287,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/12\/20\/mysql-optimize-repair-and-analyze\/","url_meta":{"origin":23757,"position":1},"title":"MySQL optimize, repair, and analyze","author":"Leonid Mamchenkov","date":"December 20, 2017","format":false,"excerpt":"Years ago I had the following script running as a cron job, but then I lost it somewhere.\u00a0 It took me a few minutes to find it again, but just in case I need it in the future, I'm saving it here. Found it here this time.","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":29062,"url":"https:\/\/mamchenkov.net\/wordpress\/2018\/12\/10\/mysql-high-availability-at-github\/","url_meta":{"origin":23757,"position":2},"title":"MySQL High Availability at GitHub","author":"Leonid Mamchenkov","date":"December 10, 2018","format":false,"excerpt":"Shlomi Noach, GitHub's Senior Infrastructure Engineer, shares some details on both the current and future high availability setup of MySQL databases at GitHub. This is probably way too far out for most people using MySQL for their web applications.\u00a0 But it does highlight the technical complexity of running high load\u2026","rel":"","context":"In &quot;All&quot;","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\/12\/mysql-ha-solution-at-github.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/mamchenkov.net\/wordpress\/wp-content\/uploads\/2018\/12\/mysql-ha-solution-at-github.png?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":27380,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/03\/02\/mysql-8-is-coming\/","url_meta":{"origin":23757,"position":3},"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 &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":28186,"url":"https:\/\/mamchenkov.net\/wordpress\/2017\/11\/06\/mysql-vs-mariadb-reality-check\/","url_meta":{"origin":23757,"position":4},"title":"MySQL vs. MariaDB: Reality Check","author":"Leonid Mamchenkov","date":"November 6, 2017","format":false,"excerpt":"Percona Database Performance Blog runs this post -\u00a0MySQL vs. MariaDB: Reality Check - comparing the MySQL, MariaDB and the Percona Server for MySQL.\u00a0 I think that most people using MySQL or MariaDB today consider them to be pretty much identical (a fork for legal reasons or something along those lines).\u00a0\u2026","rel":"","context":"In &quot;All&quot;","block_context":{"text":"All","link":"https:\/\/mamchenkov.net\/wordpress\/category\/general\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14884,"url":"https:\/\/mamchenkov.net\/wordpress\/2011\/05\/16\/mysql-prompt\/","url_meta":{"origin":23757,"position":5},"title":"MySQL prompt","author":"Leonid Mamchenkov","date":"May 16, 2011","format":false,"excerpt":"I've been using MySQL for quite a few years by now, but only today I learned that it is possible to define MySQL prompt. \u00a0As per this blog post, all it takes is a couple of lines in .my.cnf file with something like: That alone will help to prevent a\u2026","rel":"","context":"In &quot;All&quot;","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\/23757","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=23757"}],"version-history":[{"count":0,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/posts\/23757\/revisions"}],"wp:attachment":[{"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/media?parent=23757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/categories?post=23757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/tags?post=23757"},{"taxonomy":"keyring_services","embeddable":true,"href":"https:\/\/mamchenkov.net\/wordpress\/wp-json\/wp\/v2\/keyring_services?post=23757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}