{"id":3203,"date":"2024-05-10T00:21:46","date_gmt":"2024-05-10T03:21:46","guid":{"rendered":"https:\/\/wearebigcheese.com\/sin-categorizar\/mysql-multi-master-replication-on-amazon-rds\/"},"modified":"2024-12-30T12:09:45","modified_gmt":"2024-12-30T15:09:45","slug":"mysql-multi-master-replication-on-amazon-rds","status":"publish","type":"post","link":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/","title":{"rendered":"MYSQL MULTI-MASTER REPLICATION ON AMAZON RDS"},"content":{"rendered":"\n<div id=\"wp-block-themeisle-blocks-advanced-columns-318945e8\" class=\"wp-block-themeisle-blocks-advanced-columns alignwide has-1-columns has-desktop-equal-layout has-tablet-equal-layout has-mobile-equal-layout has-vertical-unset\"><div class=\"wp-block-themeisle-blocks-advanced-columns-overlay\"><\/div><div class=\"innerblocks-wrap\">\n<div id=\"wp-block-themeisle-blocks-advanced-column-ef252ccd\" class=\"wp-block-themeisle-blocks-advanced-column\">\n<div id=\"wp-block-themeisle-blocks-advanced-columns-8867c506\" class=\"wp-block-themeisle-blocks-advanced-columns has-2-columns has-desktop-equal-layout has-tablet-equal-layout has-mobile-collapsedRows-layout has-vertical-unset\"><div class=\"wp-block-themeisle-blocks-advanced-columns-overlay\"><\/div><div class=\"innerblocks-wrap\">\n<div id=\"wp-block-themeisle-blocks-advanced-column-6735d73b\" class=\"wp-block-themeisle-blocks-advanced-column\">\n<h2 class=\"wp-block-heading\">MYSQL MULTI-MASTER REPLICATION ON AMAZON RDS<\/h2>\n<\/div>\n\n\n\n<div id=\"wp-block-themeisle-blocks-advanced-column-f331a471\" class=\"wp-block-themeisle-blocks-advanced-column\">\n<div class=\"wp-block-columns is-not-stacked-on-mobile datos-post is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-vertically-aligned-top is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Category \/<\/strong><\/p>\n\n\n<div class=\"taxonomy-category has-link-color wp-elements-e903c577c561db4b39aee2e1f34eac0d wp-block-post-terms has-text-color has-nv-dark-bg-color\"><a href=\"https:\/\/wearebigcheese.com\/en\/category\/amazon-rds-en\/\" rel=\"tag\">AMAZON RDS<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/wearebigcheese.com\/en\/category\/aws-en\/\" rel=\"tag\">AWS<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/wearebigcheese.com\/en\/category\/aws-experts-en\/\" rel=\"tag\">AWS experts<\/a><span class=\"wp-block-post-terms__separator\">, <\/span><a href=\"https:\/\/wearebigcheese.com\/en\/category\/blog-en\/\" rel=\"tag\">Blog<\/a><\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Date \/<\/strong><\/p>\n\n\n<div class=\"wp-block-post-date\"><time datetime=\"2024-05-10T00:21:46-03:00\">10 May, 2024<\/time><\/div><\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>By \/<\/strong><\/p>\n\n\n<div class=\"wp-block-post-author-name\">BigCheese<\/div><\/div>\n<\/div>\n<\/div>\n<\/div><\/div>\n<\/div>\n<\/div><\/div>\n\n<div id=\"wp-block-themeisle-blocks-advanced-columns-36cb83b9\" class=\"wp-block-themeisle-blocks-advanced-columns alignwide has-2-columns has-desktop-equal-layout has-tablet-collapsedRows-layout has-mobile-collapsedRows-layout has-vertical-unset\"><div class=\"wp-block-themeisle-blocks-advanced-columns-overlay\"><\/div><div class=\"innerblocks-wrap\">\n<div id=\"wp-block-themeisle-blocks-advanced-column-d57e4ee2\" class=\"wp-block-themeisle-blocks-advanced-column social-media\"><div class=\"wp-block-themeisle-blocks-sharing-icons\" id=\"wp-block-themeisle-blocks-sharing-icons-a2c041ec\"><div class=\"social-icons-wrap\"><a class=\"social-icon is-facebook\" aria-label=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer\/sharer.php?u=https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/posts\/3203&#038;title=MYSQL%20MULTI-MASTER%20REPLICATION%20ON%20AMAZON%20RDS\" target=\"_blank\"><svg aria-hidden=\"true\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\"><!--!Font Awesome Free 6.6.0 by @fontawesome - https:\/\/fontawesome.com License - https:\/\/fontawesome.com\/license\/free Copyright 2024 Fonticons, Inc.--><path d=\"M512 256C512 114.6 397.4 0 256 0S0 114.6 0 256C0 376 82.7 476.8 194.2 504.5V334.2H141.4V256h52.8V222.3c0-87.1 39.4-127.5 125-127.5c16.2 0 44.2 3.2 55.7 6.4V172c-6-.6-16.5-1-29.6-1c-42 0-58.2 15.9-58.2 57.2V256h83.6l-14.4 78.2H287V510.1C413.8 494.8 512 386.9 512 256h0z\"\/><\/svg><span class=\"v-line\"><\/span>Facebook<\/a><a class=\"social-icon is-twitter\" aria-label=\"Share on X\" href=\"http:\/\/x.com\/share?url=https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/posts\/3203&#038;text=MYSQL%20MULTI-MASTER%20REPLICATION%20ON%20AMAZON%20RDS\" target=\"_blank\"><svg aria-hidden=\"true\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\"><!--!Font Awesome Free 6.6.0 by @fontawesome - https:\/\/fontawesome.com License - https:\/\/fontawesome.com\/license\/free Copyright 2024 Fonticons, Inc.--><path d=\"M389.2 48h70.6L305.6 224.2 487 464H345L233.7 318.6 106.5 464H35.8L200.7 275.5 26.8 48H172.4L272.9 180.9 389.2 48zM364.4 421.8h39.1L151.1 88h-42L364.4 421.8z\"\/><\/svg><\/a><a class=\"social-icon is-linkedin\" aria-label=\"Share on LinkedIn\" href=\"https:\/\/www.linkedin.com\/shareArticle?mini=true&#038;url=https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/posts\/3203&#038;title=MYSQL%20MULTI-MASTER%20REPLICATION%20ON%20AMAZON%20RDS\" target=\"_blank\"><svg aria-hidden=\"true\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 448 512\"><!--!Font Awesome Free 6.6.0 by @fontawesome - https:\/\/fontawesome.com License - https:\/\/fontawesome.com\/license\/free Copyright 2024 Fonticons, Inc.--><path d=\"M100.3 448H7.4V148.9h92.9zM53.8 108.1C24.1 108.1 0 83.5 0 53.8a53.8 53.8 0 0 1 107.6 0c0 29.7-24.1 54.3-53.8 54.3zM447.9 448h-92.7V302.4c0-34.7-.7-79.2-48.3-79.2-48.3 0-55.7 37.7-55.7 76.7V448h-92.8V148.9h89.1v40.8h1.3c12.4-23.5 42.7-48.3 87.9-48.3 94 0 111.3 61.9 111.3 142.3V448z\"\/><\/svg><span class=\"v-line\"><\/span>Linkedin<\/a><a class=\"social-icon is-whatsapp\" aria-label=\"Share on WhatsApp\" href=\"https:\/\/api.whatsapp.com\/send?text=https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/posts\/3203\" target=\"_blank\"><svg aria-hidden=\"true\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 448 512\"><!--!Font Awesome Free 6.6.0 by @fontawesome - https:\/\/fontawesome.com License - https:\/\/fontawesome.com\/license\/free Copyright 2024 Fonticons, Inc.--><path d=\"M380.9 97.1C339 55.1 283.2 32 223.9 32c-122.4 0-222 99.6-222 222 0 39.1 10.2 77.3 29.6 111L0 480l117.7-30.9c32.4 17.7 68.9 27 106.1 27h.1c122.3 0 224.1-99.6 224.1-222 0-59.3-25.2-115-67.1-157zm-157 341.6c-33.2 0-65.7-8.9-94-25.7l-6.7-4-69.8 18.3L72 359.2l-4.4-7c-18.5-29.4-28.2-63.3-28.2-98.2 0-101.7 82.8-184.5 184.6-184.5 49.3 0 95.6 19.2 130.4 54.1 34.8 34.9 56.2 81.2 56.1 130.5 0 101.8-84.9 184.6-186.6 184.6zm101.2-138.2c-5.5-2.8-32.8-16.2-37.9-18-5.1-1.9-8.8-2.8-12.5 2.8-3.7 5.6-14.3 18-17.6 21.8-3.2 3.7-6.5 4.2-12 1.4-32.6-16.3-54-29.1-75.5-66-5.7-9.8 5.7-9.1 16.3-30.3 1.8-3.7 .9-6.9-.5-9.7-1.4-2.8-12.5-30.1-17.1-41.2-4.5-10.8-9.1-9.3-12.5-9.5-3.2-.2-6.9-.2-10.6-.2-3.7 0-9.7 1.4-14.8 6.9-5.1 5.6-19.4 19-19.4 46.3 0 27.3 19.9 53.7 22.6 57.4 2.8 3.7 39.1 59.7 94.8 83.8 35.2 15.2 49 16.5 66.6 13.9 10.7-1.6 32.8-13.4 37.4-26.4 4.6-13 4.6-24.1 3.2-26.4-1.3-2.5-5-3.9-10.5-6.6z\"\/><\/svg><span class=\"v-line\"><\/span>WhatsApp<\/a><\/div><\/div><style type=\"text\/css\">#wp-block-themeisle-blocks-sharing-icons-a2c041ec .is-facebook {--icon-bg-color: var(--nv-secondary-accent);--text-color: var(--nv-dark-bg);}#wp-block-themeisle-blocks-sharing-icons-a2c041ec .is-twitter {--icon-bg-color: var(--nv-secondary-accent);--text-color: var(--nv-dark-bg);}#wp-block-themeisle-blocks-sharing-icons-a2c041ec .is-linkedin {--icon-bg-color: var(--nv-secondary-accent);--text-color: var(--nv-dark-bg);}#wp-block-themeisle-blocks-sharing-icons-a2c041ec .is-reddit {--icon-bg-color: var(--nv-secondary-accent);--text-color: var(--nv-dark-bg);}#wp-block-themeisle-blocks-sharing-icons-a2c041ec .is-whatsapp {--icon-bg-color: var(--nv-secondary-accent);--text-color: var(--nv-dark-bg);}#wp-block-themeisle-blocks-sharing-icons-a2c041ec {--icons-gap: 10px;--border-radius: 50px;}<\/style>\n\n\n<div class=\"wp-block-buttons is-layout-flex wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button has-custom-font-size has-small-font-size\" id=\"copy-button\"><a class=\"wp-block-button__link has-nv-dark-bg-color has-neve-link-color-background-color has-text-color has-background has-link-color wp-element-button\">? Link  <\/a><\/div>\n<\/div>\n<\/div>\n\n\n\n<div id=\"wp-block-themeisle-blocks-advanced-column-d73d3ae5\" class=\"wp-block-themeisle-blocks-advanced-column contenido-post\">\n<p>One great feature of modern relational databases is the ability to replicate changes automatically from one database server to another. This has many use cases, from having a backup that is ready to jump as a production server, to having a fresh copy of your data out of the online database for heavy load queries. In a project for <a href=\"http:\/\/www.anii.org.uy\/\">ANII<\/a>, we did some nice tricks over MySQL replication to meet project requirements and complexities that we would like to share.<\/p>\n\n\n\n<p>MySQL uses the binary logs to keep track of<br\/>which data is already replicated, and which one is not.<\/p>\n\n\n\n<p>The first thing we faced is that all those MySQL servers were hosted on <a href=\"https:\/\/aws.amazon.com\/documentation\/rds\/\">Amazon RDS<\/a>. This is no big thing, until you want to start messing with MySQL configurations and an inaccessible mysql.conf. Now a days (with latest versions of AWS RDS) more and more configurations are available trough <a href=\"http:\/\/docs.aws.amazon.com\/AmazonRDS\/latest\/UserGuide\/USER_WorkingWithParamGroups.html\">parameter groups<\/a>, so most configs are doable.<\/p>\n\n\n\n<p>The next thing (a big one), is that our client wanted to replicate from several servers (called masters in the replication world) to only one server replica (called slave). If you think it for a moment, it makes sense: send all servers data to one replica server so you can have in one place all you need to do your analytics, and for sure save some money. This is great, until you come to realize that MySQL replication only allows one master per replica (for example, one master can have several replicas, but not the other way around).<\/p>\n\n\n\n<p>This was a major requirement for <a href=\"https:\/\/www.bigcheese.uy\/case-anii.html\">ANII<\/a>, so we needed to find a way to do this. Luckily, we found several <a href=\"https:\/\/dba.stackexchange.com\/questions\/12178\/one-slave-multiple-masters-mysql\">posts<\/a> that explain that you can set a master and start replicating, and after a while, stop and point the slave to another master, and start replicating that one. But before start each replication, we needed to tell the slave at which point of the binary logs did he stop the last time he was working with that master, so he can resume without losing anything. Tricky, isn&#8217;t it?<\/p>\n\n\n\n<p>So, in the case you have 2 master servers and 1 slave:<br\/>&#8211; Master M1<br\/>&#8211; Master M2<br\/>&#8211; Slave S1<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>You need to:<br\/><\/strong>1) S1 sets M1 as the source of replication<br\/>2) Set the logs to the point you left M1 last time you replicated<br\/>3) Start replication<br\/>4) Run replication for a little while<br\/>5) Stop replication and save the log status<br\/>6) S1 sets M2 as the source of replication<br\/>7) Set the logs to the point you left M2 last time you replicated<br\/>8) Start replication<br\/>9) Run replication for a little while<br\/>10) Stop replication<br\/>11) Go back to step 1<\/li>\n<\/ul>\n\n\n\n<p>Sounds easy!<\/p>\n\n\n\n<p>Check out our <a href=\"https:\/\/www.bigcheese.uy\/case-anii.html\">Success Case of ANII<\/a><\/p>\n\n\n\n<p>We are <a href=\"https:\/\/www.bigcheese.uy\/\">BigCheese<\/a>, an engineering in-house team.<\/p>\n<\/div>\n<\/div><\/div>\n\n<div id=\"wp-block-themeisle-blocks-advanced-columns-16e28121\" class=\"wp-block-themeisle-blocks-advanced-columns alignwide has-2-columns has-desktop-equal-layout has-tablet-equal-layout has-mobile-equal-layout has-vertical-unset prev-next\"><div class=\"wp-block-themeisle-blocks-advanced-columns-overlay\"><\/div><div class=\"innerblocks-wrap\">\n<div id=\"wp-block-themeisle-blocks-advanced-column-e7076530\" class=\"wp-block-themeisle-blocks-advanced-column\"><\/div>\n\n\n\n<div id=\"wp-block-themeisle-blocks-advanced-column-aabe3ad9\" class=\"wp-block-themeisle-blocks-advanced-column\"><\/div>\n<\/div><\/div>\n\n<div id=\"wp-block-themeisle-blocks-advanced-columns-47ed1020\" class=\"wp-block-themeisle-blocks-advanced-columns alignfull has-1-columns has-desktop-equal-layout has-tablet-equal-layout has-mobile-equal-layout has-vertical-unset grilla-portfolio blog\"><div class=\"wp-block-themeisle-blocks-advanced-columns-overlay\"><\/div><div class=\"innerblocks-wrap\">\n<div id=\"wp-block-themeisle-blocks-advanced-column-ba93bed6\" class=\"wp-block-themeisle-blocks-advanced-column\">\n<div id=\"wp-block-themeisle-blocks-advanced-columns-8419fd54\" class=\"wp-block-themeisle-blocks-advanced-columns alignwide has-1-columns has-desktop-equal-layout has-tablet-equal-layout has-mobile-equal-layout has-vertical-unset grilla-portfolio blog\"><div class=\"wp-block-themeisle-blocks-advanced-columns-overlay\"><\/div><div class=\"innerblocks-wrap\">\n<div id=\"wp-block-themeisle-blocks-advanced-column-e5cbb502\" class=\"wp-block-themeisle-blocks-advanced-column grilla-portfolio\">\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<h3 class=\"wp-block-heading has-text-align-center\">Related news<\/h3>\n<\/div>\n<\/div>\n\n\n<div class=\"pt-cv-wrapper\"><h1 class='pt-cv-heading-container heading1' data-blockid='ffab30e1h7'><span class='pt-cv-heading'>  <\/span><\/h1><div class=\"pt-cv-view pt-cv-pinterest pt-cv-colsys pt-cv-border pt-cv-no-bb pt-cv-pgregular\" id=\"pt-cv-view-ffab30e1h7\"><div data-id=\"pt-cv-page-1\" class=\"pt-cv-page\" data-cvc=\"3\"><div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"4624\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/an-approach-to-sagemaker-unified-studio\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"131\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2025\/01\/Screenshot-2025-01-24-at-4.36.29\u202fPM-300x131.png\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"A closer look at AWS SageMaker Unified Studio\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-en\/' title='AWS' class='pt-cv-tax-aws-en'>AWS<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/sin-categorizar\/' title='Sin categorizar' class='pt-cv-tax-sin-categorizar'>Sin categorizar<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/an-approach-to-sagemaker-unified-studio\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">A closer look at AWS SageMaker Unified Studio<\/a><\/h4><\/div><\/div>\n<div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"4578\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/recap-aws-reinvent-2024-innovations-to-transform-the-future\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"261\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/12\/Screenshot-2024-12-23-at-4.20.54\u202fPM-2-300x261.png\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"Recap AWS re:Invent 2024: the Think Big panacea.\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-en\/' title='AWS' class='pt-cv-tax-aws-en'>AWS<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/cloud-en\/' title='Cloud' class='pt-cv-tax-cloud-en'>Cloud<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/sin-categorizar\/' title='Sin categorizar' class='pt-cv-tax-sin-categorizar'>Sin categorizar<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/recap-aws-reinvent-2024-innovations-to-transform-the-future\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">Recap AWS re:Invent 2024: the Think Big panacea.<\/a><\/h4><\/div><\/div>\n<div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"3187\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/good-infrastructure-practices-in-aws-introducing-the-aws-well-architected-framework-waf\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"300\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/05\/6-pilares-devops-4-300x300.png\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"Pilares devops\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-experts-en\/' title='AWS experts' class='pt-cv-tax-aws-experts-en'>AWS experts<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/devops-en\/' title='DevOps' class='pt-cv-tax-devops-en'>DevOps<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/good-infrastructure-practices-in-aws-introducing-the-aws-well-architected-framework-waf\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">Good infrastructure practices in AWS. Introducing the AWS Well-Architected Framework (WAF).<\/a><\/h4><\/div><\/div>\n<div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"4249\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/bigcheese-becomes-the-first-aws-premier-partner-in-uruguay\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"280\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/09\/AWS-Premier-Partner-BigCheese-300x280.png\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"BigCheese becomes the first AWS Premier Partner in Uruguay\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-certification-en\/' title='AWS certification' class='pt-cv-tax-aws-certification-en'>AWS certification<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/sin-categorizar\/' title='Sin categorizar' class='pt-cv-tax-sin-categorizar'>Sin categorizar<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/bigcheese-becomes-the-first-aws-premier-partner-in-uruguay\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">BigCheese becomes the first AWS Premier Partner in Uruguay<\/a><\/h4><\/div><\/div>\n<div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"3249\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/think-big-start-small\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"223\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/05\/Screenshot-2024-04-05-at-14.57.18-300x223.png\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"Think Big Start Small\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-egineer-en\/' title='AWS Egineer' class='pt-cv-tax-aws-egineer-en'>AWS Egineer<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-experts-en\/' title='AWS experts' class='pt-cv-tax-aws-experts-en'>AWS experts<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/devops-en\/' title='DevOps' class='pt-cv-tax-devops-en'>DevOps<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/infrastructure\/' title='Infrastructure' class='pt-cv-tax-infrastructure'>Infrastructure<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/think-big-start-small\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">Think Big, Start Small<\/a><\/h4><\/div><\/div>\n<div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"3244\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/inception-workshop-for-budgeting-a-project\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"126\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc2-300x126.jpg\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"Inception workshop for budgeting a project\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/design-thinking-en\/' title='Design Thinking' class='pt-cv-tax-design-thinking-en'>Design Thinking<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/inception-workshop-for-budgeting-a-project\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">Inception workshop for budgeting a project<\/a><\/h4><\/div><\/div>\n<div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"3205\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/how-to-encourage-the-self-organization-of-remote-teams\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"271\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/05\/pasted-image-0-5-300x271.png\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"Organizacion de equipos\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-en\/' title='AWS' class='pt-cv-tax-aws-en'>AWS<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/team-work-en\/' title='Team Work' class='pt-cv-tax-team-work-en'>Team Work<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/how-to-encourage-the-self-organization-of-remote-teams\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">How to encourage the self-organization of remote teams?<\/a><\/h4><\/div><\/div>\n<div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"3188\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/cost-optimization-in-aws-cloud\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"214\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/05\/Screen-Shot-2021-07-29-at-11.21.23-300x214.png\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"AWS Cloud\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-certification-en\/' title='AWS certification' class='pt-cv-tax-aws-certification-en'>AWS certification<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-cloud-en\/' title='AWS Cloud' class='pt-cv-tax-aws-cloud-en'>AWS Cloud<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-experts-en\/' title='AWS experts' class='pt-cv-tax-aws-experts-en'>AWS experts<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/infrastructure\/' title='Infrastructure' class='pt-cv-tax-infrastructure'>Infrastructure<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/cost-optimization-in-aws-cloud\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">Cost optimization in AWS Cloud<\/a><\/h4><\/div><\/div>\n<div class=\"col-md-4 col-sm-4 col-xs-12 pt-cv-content-item pt-cv-1-col\"  data-pid=\"3221\"><div class='pt-cv-pinmas'><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/the-open-banking-paradigm-in-uruguay-and-its-current-status\/\" class=\"_self pt-cv-href-thumbnail pt-cv-thumb-default cvplbd cvp-responsive-image img-none\" target=\"_self\" data-iw=\"300\" data-ih=\"300\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"224\" src=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/05\/Open-Banking-Uruguay-1024x764-1-300x224.png\" class=\"pt-cv-thumbnail img-none skip-lazy \" alt=\"Open Banking Uruguay 1\" \/><\/a>\n<div class=\"pt-cv-taxoterm above_title\"><a href='https:\/\/wearebigcheese.com\/en\/category\/aws-cloud-en\/' title='AWS Cloud' class='pt-cv-tax-aws-cloud-en'>AWS Cloud<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/blog-en\/' title='Blog' class='pt-cv-tax-blog-en'>Blog<\/a><a href='https:\/\/wearebigcheese.com\/en\/category\/financial-services-en\/' title='Financial Services' class='pt-cv-tax-financial-services-en'>Financial Services<\/a><\/div>\n<h4 class=\"pt-cv-title\"><a href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/the-open-banking-paradigm-in-uruguay-and-its-current-status\/\" class=\"_self cvplbd\" target=\"_self\" data-iw=\"300\" data-ih=\"300\">The Open Banking paradigm in Uruguay and its current status<\/a><\/h4><\/div><\/div><\/div><\/div><\/div>\t\t\t<style type=\"text\/css\" id=\"pt-cv-inline-style-bd95b15y03\">#pt-cv-view-ffab30e1h7  .pt-cv-pinmas   { background-color: rgba(151,140,225,0) !important; border-width: 0px 0px 0px 0px !important; border-style: solid !important; border-color: #978ce1 !important; }\n#pt-cv-view-ffab30e1h7 .pt-cv-thumbnail, #pt-cv-view-ffab30e1h7  .cvp-responsive-image[style*=background-image] { border-style: none }\n#pt-cv-view-ffab30e1h7 .pt-cv-thumbnail, #pt-cv-view-ffab30e1h7  .cvp-responsive-image[style*=background-image] { border-radius: 30px 30px 30px 30px }\n#pt-cv-view-ffab30e1h7 .pt-cv-taxoterm * { font-family: 'Montserrat', Arial, serif !important; color: #978ce1 !important; }\n#pt-cv-view-ffab30e1h7 .pt-cv-title a, #pt-cv-view-ffab30e1h7  .panel-title { font-family: 'Montserrat', Arial, serif !important; font-size: 30px !important; line-height: 1.3 !important; color: #4c4c4c !important; }\n@media (min-width: 768px) and (max-width: 991px) {#pt-cv-view-ffab30e1h7 .pt-cv-title a, #pt-cv-view-ffab30e1h7  .panel-title { font-size: 25px !important }}\n@media (max-width: 767px) {#pt-cv-view-ffab30e1h7 .pt-cv-title a, #pt-cv-view-ffab30e1h7  .panel-title { font-size: 20px !important }}\n#pt-cv-view-ffab30e1h7  .pt-cv-title a:hover, #pt-cv-view-ffab30e1h7  .panel-title:hover   { font-family: 'Montserrat', Arial, serif !important; }\n#pt-cv-view-ffab30e1h7 .pt-cv-readmore  { font-family: 'Montserrat', Arial, serif !important; font-size: 14px !important; line-height: 1.3 !important; color: #978ce1 !important; background-color: rgba(0,174,239,0) !important; border-style: none !important; }\n@media (max-width: 767px) {#pt-cv-view-ffab30e1h7 .pt-cv-readmore  { font-size: 11px !important }}\n#pt-cv-view-ffab30e1h7 .pt-cv-readmore:hover  { font-family: 'Montserrat', Arial, serif !important; color: rgba(151,140,225,0.86) !important; background-color: rgba(0,174,239,0) !important; text-decoration: underline !important; }\n#pt-cv-view-ffab30e1h7  + .pt-cv-pagination-wrapper .pt-cv-more-inactive , #pt-cv-view-ffab30e1h7  + .pt-cv-pagination-wrapper .pagination a, .pt-cv-pagination[data-sid='ffab30e1h7'] a { border-radius: 100px 100px 100px 100px !important; }\n#pt-cv-view-ffab30e1h7  + .pt-cv-pagination-wrapper .pt-cv-more , #pt-cv-view-ffab30e1h7  + .pt-cv-pagination-wrapper .pagination .active a, .pt-cv-pagination[data-sid='ffab30e1h7'] .active a { color: #212121 !important; background-color: #eeecea !important; border-radius: 100px 100px 100px 100px !important; }\n.cvp-live-filter[data-sid='ffab30e1h7'] .cvp-label   { font-family: 'Montserrat', Arial, serif !important; color: #212121 !important; background-color: rgba(15,15,15,0) !important; padding: 5px 10px !important; margin-bottom: 5px !important; }\n.cvp-live-filter[data-sid='ffab30e1h7'] input[type='text'], .cvp-live-filter[data-sid='ffab30e1h7'] div > label, .cvp-live-filter[data-sid='ffab30e1h7'] select, .cvp-live-filter[data-sid='ffab30e1h7'] .irs-from, .cvp-live-filter[data-sid='ffab30e1h7'] .irs-to   { font-family: 'Montserrat', Arial, serif !important; color: #191919 !important; }\n.cvp-live-filter[data-sid='ffab30e1h7'] input[type=radio]:checked~div   { color: #191414 !important; background-color: #978ce1 !important; }\n.cvp-live-submit   { font-family: 'Montserrat', Arial, serif !important; }\n.cvp-live-reset   { font-family: 'Montserrat', Arial, serif !important; }\n#pt-cv-view-ffab30e1h7 .cvp-responsive-image[style*=\"background-image\"] { width: 300px; max-height: 300px; overflow: hidden; aspect-ratio: 1 }\n#pt-cv-view-ffab30e1h7 .cvp-responsive-image img { max-width: 300px; max-height: 300px; aspect-ratio: 1 }<\/style>\r\n\t\t\t<link href='\/\/fonts.googleapis.com\/css?family=Montserrat' rel='stylesheet' type='text\/css'><\/div>\n<\/div><\/div>\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":2716,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[111,92,104,91],"tags":[],"class_list":["post-3203","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-amazon-rds-en","category-aws-en","category-aws-experts-en","category-blog-en"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MYSQL Multi-Master Replication | BigCheese Blog<\/title>\n<meta name=\"description\" content=\"Explore benefits &amp; implementation of MySQL multi-master replication. Enhance data availability. We are BigCheese\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MYSQL Multi-Master Replication | BigCheese Blog\" \/>\n<meta property=\"og:description\" content=\"Explore benefits &amp; implementation of MySQL multi-master replication. Enhance data availability. We are BigCheese\" \/>\n<meta property=\"og:url\" content=\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/\" \/>\n<meta property=\"og:site_name\" content=\"BigCheese, AWS Premier Partner\" \/>\n<meta property=\"article:published_time\" content=\"2024-05-10T03:21:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-30T15:09:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"806\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"BigCheese\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"BigCheese\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/\"},\"author\":{\"name\":\"BigCheese\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/#\/schema\/person\/a79057c45de489251cde9adca3e59ae9\"},\"headline\":\"MYSQL MULTI-MASTER REPLICATION ON AMAZON RDS\",\"datePublished\":\"2024-05-10T03:21:46+00:00\",\"dateModified\":\"2024-12-30T15:09:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/\"},\"wordCount\":468,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg\",\"articleSection\":[\"AMAZON RDS\",\"AWS\",\"AWS experts\",\"Blog\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/\",\"url\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/\",\"name\":\"MYSQL Multi-Master Replication | BigCheese Blog\",\"isPartOf\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg\",\"datePublished\":\"2024-05-10T03:21:46+00:00\",\"dateModified\":\"2024-12-30T15:09:45+00:00\",\"description\":\"Explore benefits & implementation of MySQL multi-master replication. Enhance data availability. We are BigCheese\",\"breadcrumb\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#primaryimage\",\"url\":\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg\",\"contentUrl\":\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg\",\"width\":1920,\"height\":806},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/wearebigcheese.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MYSQL MULTI-MASTER REPLICATION ON AMAZON RDS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/#website\",\"url\":\"https:\/\/wearebigcheese.com\/en\/\",\"name\":\"BigCheese, AWS Premier Partner\",\"description\":\"Think Big, Start Small\",\"publisher\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/#organization\"},\"alternateName\":\"BigCheese - AWS Premier Partner\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/wearebigcheese.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/#organization\",\"name\":\"BigCheese, AWS Premier Partner\",\"alternateName\":\"BigCheese\",\"url\":\"https:\/\/wearebigcheese.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2025\/03\/Logotipo-horizontal-Negro-1.png\",\"contentUrl\":\"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2025\/03\/Logotipo-horizontal-Negro-1.png\",\"width\":278,\"height\":58,\"caption\":\"BigCheese, AWS Premier Partner\"},\"image\":{\"@id\":\"https:\/\/wearebigcheese.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.instagram.com\/wearebigcheese\/\",\"https:\/\/www.linkedin.com\/company\/wearebigcheese\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/#\/schema\/person\/a79057c45de489251cde9adca3e59ae9\",\"name\":\"BigCheese\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/wearebigcheese.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/3d085ce4ef2ee87423f822746b3ddb3583bdbc20ce4f8f8a0af316e57db3645d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/3d085ce4ef2ee87423f822746b3ddb3583bdbc20ce4f8f8a0af316e57db3645d?s=96&d=mm&r=g\",\"caption\":\"BigCheese\"},\"sameAs\":[\"https:\/\/newweb-test.bigcheese.uy\"],\"url\":\"https:\/\/wearebigcheese.com\/en\/author\/bigcheese\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MYSQL Multi-Master Replication | BigCheese Blog","description":"Explore benefits & implementation of MySQL multi-master replication. Enhance data availability. We are BigCheese","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/","og_locale":"en_US","og_type":"article","og_title":"MYSQL Multi-Master Replication | BigCheese Blog","og_description":"Explore benefits & implementation of MySQL multi-master replication. Enhance data availability. We are BigCheese","og_url":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/","og_site_name":"BigCheese, AWS Premier Partner","article_published_time":"2024-05-10T03:21:46+00:00","article_modified_time":"2024-12-30T15:09:45+00:00","og_image":[{"width":1920,"height":806,"url":"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg","type":"image\/jpeg"}],"author":"BigCheese","twitter_card":"summary_large_image","twitter_misc":{"Written by":"BigCheese","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#article","isPartOf":{"@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/"},"author":{"name":"BigCheese","@id":"https:\/\/wearebigcheese.com\/en\/#\/schema\/person\/a79057c45de489251cde9adca3e59ae9"},"headline":"MYSQL MULTI-MASTER REPLICATION ON AMAZON RDS","datePublished":"2024-05-10T03:21:46+00:00","dateModified":"2024-12-30T15:09:45+00:00","mainEntityOfPage":{"@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/"},"wordCount":468,"commentCount":0,"publisher":{"@id":"https:\/\/wearebigcheese.com\/en\/#organization"},"image":{"@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#primaryimage"},"thumbnailUrl":"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg","articleSection":["AMAZON RDS","AWS","AWS experts","Blog"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/","url":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/","name":"MYSQL Multi-Master Replication | BigCheese Blog","isPartOf":{"@id":"https:\/\/wearebigcheese.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#primaryimage"},"image":{"@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#primaryimage"},"thumbnailUrl":"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg","datePublished":"2024-05-10T03:21:46+00:00","dateModified":"2024-12-30T15:09:45+00:00","description":"Explore benefits & implementation of MySQL multi-master replication. Enhance data availability. We are BigCheese","breadcrumb":{"@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#primaryimage","url":"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg","contentUrl":"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2024\/04\/opc4.jpg","width":1920,"height":806},{"@type":"BreadcrumbList","@id":"https:\/\/wearebigcheese.com\/en\/blog-en\/mysql-multi-master-replication-on-amazon-rds\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/wearebigcheese.com\/en\/"},{"@type":"ListItem","position":2,"name":"MYSQL MULTI-MASTER REPLICATION ON AMAZON RDS"}]},{"@type":"WebSite","@id":"https:\/\/wearebigcheese.com\/en\/#website","url":"https:\/\/wearebigcheese.com\/en\/","name":"BigCheese, AWS Premier Partner","description":"Think Big, Start Small","publisher":{"@id":"https:\/\/wearebigcheese.com\/en\/#organization"},"alternateName":"BigCheese - AWS Premier Partner","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/wearebigcheese.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/wearebigcheese.com\/en\/#organization","name":"BigCheese, AWS Premier Partner","alternateName":"BigCheese","url":"https:\/\/wearebigcheese.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wearebigcheese.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2025\/03\/Logotipo-horizontal-Negro-1.png","contentUrl":"https:\/\/wearebigcheese.com\/wp-content\/uploads\/2025\/03\/Logotipo-horizontal-Negro-1.png","width":278,"height":58,"caption":"BigCheese, AWS Premier Partner"},"image":{"@id":"https:\/\/wearebigcheese.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.instagram.com\/wearebigcheese\/","https:\/\/www.linkedin.com\/company\/wearebigcheese\/"]},{"@type":"Person","@id":"https:\/\/wearebigcheese.com\/en\/#\/schema\/person\/a79057c45de489251cde9adca3e59ae9","name":"BigCheese","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/wearebigcheese.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/3d085ce4ef2ee87423f822746b3ddb3583bdbc20ce4f8f8a0af316e57db3645d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3d085ce4ef2ee87423f822746b3ddb3583bdbc20ce4f8f8a0af316e57db3645d?s=96&d=mm&r=g","caption":"BigCheese"},"sameAs":["https:\/\/newweb-test.bigcheese.uy"],"url":"https:\/\/wearebigcheese.com\/en\/author\/bigcheese\/"}]}},"_links":{"self":[{"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/posts\/3203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/comments?post=3203"}],"version-history":[{"count":3,"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/posts\/3203\/revisions"}],"predecessor-version":[{"id":3486,"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/posts\/3203\/revisions\/3486"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/media\/2716"}],"wp:attachment":[{"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/media?parent=3203"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/categories?post=3203"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wearebigcheese.com\/en\/wp-json\/wp\/v2\/tags?post=3203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}