{"id":271,"date":"2009-12-04T19:26:52","date_gmt":"2009-12-04T19:26:52","guid":{"rendered":"http:\/\/kedar.nitty-witty.com\/?p=271"},"modified":"2014-06-24T18:58:57","modified_gmt":"2014-06-24T18:58:57","slug":"mysql-master-master-replication-monitor-with-php-code","status":"publish","type":"post","link":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code","title":{"rendered":"MySQL master master replication monitor with php code"},"content":{"rendered":"<p>For monitoring replication we know a lot of tools and codes &#8211; but this one is different because I wrote it \ud83d\ude09<br \/>\nWell this is fairly simple php code for monitoring a master master replication setup.<\/p>\n<p>It requires a single shared login id available on both MySQL servers.<\/p>\n<p>It will display in tabular format following details:<\/p>\n<ul>\n<li>File: Present binary log<\/li>\n<li>Position: Binary log position<\/li>\n<li>Io run: Slave IO Thread Running status<\/li>\n<li>Sql run: SQL Thread Running status<\/li>\n<li>ErrorNum: Error number<\/li>\n<li>ErrorMeg: Error message<\/li>\n<\/ul>\n<p>You can easily stop \/ start each server&#8217;s slave (STOP SLAVE \/ START SLAVE) with a single click.<br \/>\nIt also does provide detailed information of global status variables on same page.<br \/>\nIt is auto refreshes by default every 2 seconds to provide updated status of both MySQL Servers in Replication.<\/p>\n<p>In code you just need to adjust following parameters as per requirement:<\/p>\n<p><em>#host-name &amp; ports for replication servers<\/em><br \/>\n<em>$slave = &#8220;localhost&#8221;;<\/em><br \/>\n<em>$master = &#8220;localhost&#8221;;<\/em><br \/>\n<em>$slaveport=3306;<\/em><br \/>\n<em>$masterport=3307;<\/em><\/p>\n<p><em><\/em><br \/>\n<em>#Refresh rate<\/em><br \/>\n<em>$refreshRate=2;<\/em><\/p>\n<p><em><\/em><br \/>\n<em>#considered a common username password for accessing both servers#<\/em><br \/>\n<em>$username=&#8221;root&#8221;;<\/em><br \/>\n<span style=\"font-family: Consolas, Monaco, 'Courier New', Courier, monospace; line-height: 18px; font-size: 12px; white-space: pre;\">$password=&#8221;kedar&#8221;;<\/span><\/p>\n<p>You can download code here: <a href=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/12\/replication.zip\">mysql-replication-monitor.php<\/a><\/p>\n<p>MySQL Replication Monitor Using PHP:<\/p>\n<p style=\"text-align: center;\"><a title=\"mysql-replication-monitor-php\" href=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/12\/mysql-replication-monitor-php.jpg\" target=\"_blank\"><img decoding=\"async\" class=\"size-medium wp-image-274 aligncenter\" title=\"mysql-replication-monitor-php\" src=\"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/12\/mysql-replication-monitor-php-300x144.jpg\" alt=\"mysql-replication-monitor-php\" width=\"400\" height=\"250\" \/><\/a><\/p>\n<p><script charset=\"utf-8\" type=\"text\/javascript\" src=\"http:\/\/ws.amazon.com\/widgets\/q?ServiceVersion=20070822&#038;MarketPlace=US&#038;ID=V20070822\/US\/httpkedarnitt-20\/8001\/29266fe4-10b4-4f4a-bf7f-c5dc0ffee5a2\"> <\/script> <noscript><a HREF=\"http:\/\/ws.amazon.com\/widgets\/q?ServiceVersion=20070822&#038;MarketPlace=US&#038;ID=V20070822%2FUS%2Fhttpkedarnitt-20%2F8001%2F29266fe4-10b4-4f4a-bf7f-c5dc0ffee5a2&#038;Operation=NoScript\">Amazon.com Widgets<\/a><\/noscript><\/p>\n","protected":false},"excerpt":{"rendered":"For monitoring replication we know a lot of tools and codes &#8211; but this one is different because I wrote it \ud83d\ude09 Well this is fairly simple php code for&hellip;\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[8,378],"tags":[24,427,208,85,209,100,426,119],"class_list":["post-271","post","type-post","status-publish","format-standard","category-mysql","category-mysql-scripts-mysql","tag-code","tag-mysql","tag-mysql-replication-monitoring","tag-php","tag-php-script","tag-replication","tag-technical","tag-tool"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"MySQL master master replication monitor with php code\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Kedar\"\/>\n\t<meta name=\"google-site-verification\" content=\"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA\" \/>\n\t<meta name=\"msvalidate.01\" content=\"116B62074CBCA1BA99B8CCE09CCF2FB8\" \/>\n\t<meta name=\"keywords\" content=\"mysql,monitor,replication monitor,replication,code,mysql replication monitoring,php,php script,technical,tool\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.10\" \/>\n\t\t<meta property=\"og:locale\" content=\"en_US\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Change Is Inevitable | Kedar Vaijanapurkar&#039;s Blog for MySQL, technology and various subjects\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"MySQL master master replication monitor with php code | Change Is Inevitable\" \/>\n\t\t<meta property=\"og:description\" content=\"MySQL master master replication monitor with php code\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2009-12-04T19:26:52+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2014-06-24T18:58:57+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:title\" content=\"MySQL master master replication monitor with php code | Change Is Inevitable\" \/>\n\t\t<meta name=\"twitter:description\" content=\"MySQL master master replication monitor with php code\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#article\",\"name\":\"MySQL master master replication monitor with php code | Change Is Inevitable\",\"headline\":\"MySQL master master replication monitor with php code\",\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/kedar.nitty-witty.com\\\/wp-content\\\/uploads\\\/2009\\\/12\\\/mysql-replication-monitor-php-300x144.jpg\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code\\\/#articleImage\"},\"datePublished\":\"2009-12-04T19:26:52+00:00\",\"dateModified\":\"2014-06-24T18:58:57+00:00\",\"inLanguage\":\"en-US\",\"commentCount\":8,\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#webpage\"},\"articleSection\":\"MySQL, MySQL-Scripts, code, MySQL, mysql replication monitoring, php, php script, replication, Technical, tool\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-scripts-mysql#listItem\",\"name\":\"MySQL-Scripts\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-scripts-mysql#listItem\",\"position\":3,\"name\":\"MySQL-Scripts\",\"item\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-scripts-mysql\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#listItem\",\"name\":\"MySQL master master replication monitor with php code\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#listItem\",\"position\":4,\"name\":\"MySQL master master replication monitor with php code\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/category\\\/mysql\\\/mysql-scripts-mysql#listItem\",\"name\":\"MySQL-Scripts\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin\",\"name\":\"Kedar\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Kedar\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#webpage\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code\",\"name\":\"MySQL master master replication monitor with php code | Change Is Inevitable\",\"description\":\"MySQL master master replication monitor with php code\",\"inLanguage\":\"en-US\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/mysql-master-master-replication-monitor-with-php-code#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/author\\\/admin#author\"},\"datePublished\":\"2009-12-04T19:26:52+00:00\",\"dateModified\":\"2014-06-24T18:58:57+00:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/\",\"name\":\"..::CHANGE is INEVITABLE::..\",\"description\":\"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects\",\"inLanguage\":\"en-US\",\"publisher\":{\"@id\":\"https:\\\/\\\/kedar.nitty-witty.com\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"MySQL master master replication monitor with php code | Change Is Inevitable","description":"MySQL master master replication monitor with php code","canonical_url":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code","robots":"max-image-preview:large","keywords":"mysql,monitor,replication monitor,replication,code,mysql replication monitoring,php,php script,technical,tool","webmasterTools":{"google-site-verification":"_Bu1h5r0PxIC0D2jBVdmYN45RTeG9ogcX85XLkbG1qA","msvalidate.01":"116B62074CBCA1BA99B8CCE09CCF2FB8","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#article","name":"MySQL master master replication monitor with php code | Change Is Inevitable","headline":"MySQL master master replication monitor with php code","author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/kedar.nitty-witty.com\/wp-content\/uploads\/2009\/12\/mysql-replication-monitor-php-300x144.jpg","@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code\/#articleImage"},"datePublished":"2009-12-04T19:26:52+00:00","dateModified":"2014-06-24T18:58:57+00:00","inLanguage":"en-US","commentCount":8,"mainEntityOfPage":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#webpage"},"isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#webpage"},"articleSection":"MySQL, MySQL-Scripts, code, MySQL, mysql replication monitoring, php, php script, replication, Technical, tool"},{"@type":"BreadcrumbList","@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","position":1,"name":"Home","item":"https:\/\/kedar.nitty-witty.com\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","position":2,"name":"MySQL","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-scripts-mysql#listItem","name":"MySQL-Scripts"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-scripts-mysql#listItem","position":3,"name":"MySQL-Scripts","item":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-scripts-mysql","nextItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#listItem","name":"MySQL master master replication monitor with php code"},"previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#listItem","position":4,"name":"MySQL master master replication monitor with php code","previousItem":{"@type":"ListItem","@id":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-scripts-mysql#listItem","name":"MySQL-Scripts"}}]},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"Person","@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author","url":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin","name":"Kedar","image":{"@type":"ImageObject","@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/be1f7021485c325d92cc4c5d961accb9c1af72b1b11281a790f7f4f066ef10d3?s=96&d=mm&r=g","width":96,"height":96,"caption":"Kedar"}},{"@type":"WebPage","@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#webpage","url":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code","name":"MySQL master master replication monitor with php code | Change Is Inevitable","description":"MySQL master master replication monitor with php code","inLanguage":"en-US","isPartOf":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code#breadcrumblist"},"author":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"creator":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/author\/admin#author"},"datePublished":"2009-12-04T19:26:52+00:00","dateModified":"2014-06-24T18:58:57+00:00"},{"@type":"WebSite","@id":"https:\/\/kedar.nitty-witty.com\/blog\/#website","url":"https:\/\/kedar.nitty-witty.com\/blog\/","name":"..::CHANGE is INEVITABLE::..","description":"Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","inLanguage":"en-US","publisher":{"@id":"https:\/\/kedar.nitty-witty.com\/blog\/#person"}}]},"og:locale":"en_US","og:site_name":"Change Is Inevitable | Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects","og:type":"article","og:title":"MySQL master master replication monitor with php code | Change Is Inevitable","og:description":"MySQL master master replication monitor with php code","og:url":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code","article:published_time":"2009-12-04T19:26:52+00:00","article:modified_time":"2014-06-24T18:58:57+00:00","twitter:card":"summary","twitter:title":"MySQL master master replication monitor with php code | Change Is Inevitable","twitter:description":"MySQL master master replication monitor with php code"},"aioseo_meta_data":{"post_id":"271","title":"MySQL master master replication monitor with php code | #site_title","description":"MySQL master master replication monitor with php code","keywords":[{"label":"MySQL","value":"MySQL"},{"label":"monitor","value":"monitor"},{"label":"replication monitor","value":"replication monitor"},{"label":"replication","value":"replication"}],"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":null,"created":"2021-03-24 17:44:00","updated":"2025-08-16 19:01:23","seo_analyzer_scan_date":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\" title=\"Home\">Home<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\" title=\"MySQL\">MySQL<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\t<a href=\"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-scripts-mysql\" title=\"MySQL-Scripts\">MySQL-Scripts<\/a>\n\t\t<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t\t\tMySQL master master replication monitor with php code\n\t\t<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/kedar.nitty-witty.com\/blog"},{"label":"MySQL","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql"},{"label":"MySQL-Scripts","link":"https:\/\/kedar.nitty-witty.com\/blog\/category\/mysql\/mysql-scripts-mysql"},{"label":"MySQL master master replication monitor with php code","link":"https:\/\/kedar.nitty-witty.com\/blog\/mysql-master-master-replication-monitor-with-php-code"}],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/271","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/comments?post=271"}],"version-history":[{"count":3,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/271\/revisions"}],"predecessor-version":[{"id":1602,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/posts\/271\/revisions\/1602"}],"wp:attachment":[{"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/media?parent=271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/categories?post=271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kedar.nitty-witty.com\/blog\/wp-json\/wp\/v2\/tags?post=271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}