MySQL - Master to master replication without downtime in Live productionMySQL master binlog...

Why do single electrical receptacles exist?

How to know if I am a 'Real Developer'

What is formjacking?

Spells that would be effective against a Modern Day army but would NOT destroy a fantasy one

What are some good alternatives to Whisper for blockchain messaging?

Is it possible to detect 100% of SQLi with a simple regex?

A cancellation property for permutations?

3D buried view in Tikz

Are all power cords made equal?

Can I legally make a website about boycotting a certain company?

Figuring out size of Device Drivers and where they are loaded in High Memory

Do the speed limit reductions due to pollution also apply to electric cars in France?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

How many copper coins fit inside a cubic foot?

Is the tritone (A4 / d5) still banned in Roman Catholic music?

bash aliases do not expand even with shopt expand_aliases

Draw triangle with text in vertices/edges

Isn't a semicolon (';') needed after a function declaration in C++?

Buying a "Used" Router

When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?

What does an unprocessed RAW file look like?

How can I differentiate duration vs starting time

Now...where was I?

Why is it that Bernie Sanders always called a "socialist"?



MySQL - Master to master replication without downtime in Live production


MySQL master binlog corruptionpt-table-checksum help requiredadding another table to existing MySQL replication scenarioMix of Cyclic and Chained MySQL replication - What do you do with “log-slave-updates”..?MySQL master/slave replication… structure not being replicatedMySQL Replication - Master Master - Single Master writeError 1236 From Master After Restored ReplicationMySQL replication seems to work but no data is transferredMysql multisource replication : on slave map masters dbname to something like mastername-originaldbnameMaster-slave + master-master replication at the same time













3















I want to setup 2 node master-master replication. Im aware of the point of failiures in this replication. Its a huge database around 1.5TB.
Heavy OLTP is going on. But its mandatory to implement right now.



I have 2 servers.



 1. Master1 
2. Master2


Initially what I did is,



Master1:




  • Make changes my.cnf for replication.


  • Take mysqldump with --master-data=2 (For getting exact binlog
    position)



Master2:




  • Restore dump to Master2.


  • Make changes on my.cnf.


  • set replication to Master1 (Change master='Master1').


  • Start Slave.




Now Master1 is replicating to Master2.




Then I need to replicate the Master2 to Master1.
Just take the binlog position and set replication on Master1 will work, but the problem is binog file and position is changing frequently.
So before execute the Change master command on Master1 the binog get changed.



How can I achive this without downtime.










share|improve this question



























    3















    I want to setup 2 node master-master replication. Im aware of the point of failiures in this replication. Its a huge database around 1.5TB.
    Heavy OLTP is going on. But its mandatory to implement right now.



    I have 2 servers.



     1. Master1 
    2. Master2


    Initially what I did is,



    Master1:




    • Make changes my.cnf for replication.


    • Take mysqldump with --master-data=2 (For getting exact binlog
      position)



    Master2:




    • Restore dump to Master2.


    • Make changes on my.cnf.


    • set replication to Master1 (Change master='Master1').


    • Start Slave.




    Now Master1 is replicating to Master2.




    Then I need to replicate the Master2 to Master1.
    Just take the binlog position and set replication on Master1 will work, but the problem is binog file and position is changing frequently.
    So before execute the Change master command on Master1 the binog get changed.



    How can I achive this without downtime.










    share|improve this question

























      3












      3








      3








      I want to setup 2 node master-master replication. Im aware of the point of failiures in this replication. Its a huge database around 1.5TB.
      Heavy OLTP is going on. But its mandatory to implement right now.



      I have 2 servers.



       1. Master1 
      2. Master2


      Initially what I did is,



      Master1:




      • Make changes my.cnf for replication.


      • Take mysqldump with --master-data=2 (For getting exact binlog
        position)



      Master2:




      • Restore dump to Master2.


      • Make changes on my.cnf.


      • set replication to Master1 (Change master='Master1').


      • Start Slave.




      Now Master1 is replicating to Master2.




      Then I need to replicate the Master2 to Master1.
      Just take the binlog position and set replication on Master1 will work, but the problem is binog file and position is changing frequently.
      So before execute the Change master command on Master1 the binog get changed.



      How can I achive this without downtime.










      share|improve this question














      I want to setup 2 node master-master replication. Im aware of the point of failiures in this replication. Its a huge database around 1.5TB.
      Heavy OLTP is going on. But its mandatory to implement right now.



      I have 2 servers.



       1. Master1 
      2. Master2


      Initially what I did is,



      Master1:




      • Make changes my.cnf for replication.


      • Take mysqldump with --master-data=2 (For getting exact binlog
        position)



      Master2:




      • Restore dump to Master2.


      • Make changes on my.cnf.


      • set replication to Master1 (Change master='Master1').


      • Start Slave.




      Now Master1 is replicating to Master2.




      Then I need to replicate the Master2 to Master1.
      Just take the binlog position and set replication on Master1 will work, but the problem is binog file and position is changing frequently.
      So before execute the Change master command on Master1 the binog get changed.



      How can I achive this without downtime.







      mysql replication multi-master master-master-replication






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Apr 6 '17 at 18:59









      BhuvaneshBhuvanesh

      802427




      802427






















          2 Answers
          2






          active

          oldest

          votes


















          2














          I am glad you were able to mysqldump 1.5TB database. You are sure patient.



          Now for the reality check. You will some downtime for reboots and pausing.



          No need to mysqldump anymore.



          STEP 01



          Did you put this line in /etc/my.cnf on both Master1 and Master2 ?



          log-slave-updates


          If you not sure, run this on both Master1 and Master



          select @@global.log_slave_updates;


          If you get this on both Master1 and Master2



          mysql> select @@global.log_slave_updates;
          +----------------------------+
          | @@global.log_slave_updates |
          +----------------------------+
          | 1 |
          +----------------------------+
          1 row in set (0.00 sec)


          then goto STEP 02.



          This needs to be in /etc/my.cnf on both Master1 and Master2.



          If you did not, please add it and restart mysqld on both Master1 and Master2.



          STEP 02



          Did you enable binary logging on Master2 ?



          You should have a line in Master1's /etc/my.cnf like this



          log-bin = ....


          Please make sure Master2 has it.



          If you are not sure if it has it, login to MySQL on Master2 and run



          mysql> show binary logs;


          If it echoes



          mysql> show binary logs;
          ERROR 1381 (HY000): You are not using binary logging


          Then, add that log-bin line to /etc/my.cnf in Master2 and restart mysql in Master2.



          Once log-slave-updates and log-bin have been enabled on both Master1 and Master2, you are ready to setup replication in the other direction



          STEP 03



          On Master2



          STOP SLAVE;
          FLUSH TABLES;
          FLUSH LOGS;
          SHOW BINARY LOGS;


          STEP 04



          On Master1



          CHANGE MASTER TO
          MASTER_HOST='IP or Hostname of Master2',
          MASTER_PORT=3306,
          MASTER_USER='...',
          MASTER_PASSWORD='...',
          MASTER_LOG_FILE='First Binary Log On Master2',
          MASTER_LOG_POS=4
          ;
          SHOW SLAVE STATUSG


          STEP 05



          Test Connectivity from Master1 to Master2



          On Master1



          START SLAVE IO_THREAD;
          DO SLEEP(10);
          SHOW SLAVE STATUSG


          Look for Slave_IO_Running. It should be 'Yes'.



          Run SHOW SLAVE STATUSG like 3-5 times. Relay_Log_Space should be increasing.



          STEP 06



          Start processing SQL from Relay Logs



          Run this on Master1



          START SLAVE SQL_THREAD;
          DO SLEEP(10);
          SHOW SLAVE STATUSG


          Look for Slave_SQL_Running. It should be 'Yes'.



          Look for Seconds_Behind_Master. It should be 0. If it greater than 0, keep running SHOW SLAVE STATUSG until Seconds_Behind_Master is 0.






          share|improve this answer
























          • Thanks, Is any other way to setup initial replication without mysqldump? its taking more time and resource.

            – Bhuvanesh
            Apr 7 '17 at 4:21











          • Step 4 must be changed to CHANGE MASTER in newer versions.

            – Rick James
            Apr 7 '17 at 5:43



















          0














          As I'm not able to comment yet I need to write a new answer. I would like to add to the 6 steps of @RolandoMySQLDBA that the CHANGE MASTER TO command did not work for me. As the last command of STEP 03 you should run



          SHOW MASTER STATUS;


          instead of



          SHOW BINARY LOGS;


          and use the respective output as MASTER_LOG_FILE and MASTER_LOG_POS in the CHANGE MASTER TO command of STEP 04.






          share|improve this answer








          New contributor




          dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
          Check out our Code of Conduct.




















            Your Answer








            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "182"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f169357%2fmysql-master-to-master-replication-without-downtime-in-live-production%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            2














            I am glad you were able to mysqldump 1.5TB database. You are sure patient.



            Now for the reality check. You will some downtime for reboots and pausing.



            No need to mysqldump anymore.



            STEP 01



            Did you put this line in /etc/my.cnf on both Master1 and Master2 ?



            log-slave-updates


            If you not sure, run this on both Master1 and Master



            select @@global.log_slave_updates;


            If you get this on both Master1 and Master2



            mysql> select @@global.log_slave_updates;
            +----------------------------+
            | @@global.log_slave_updates |
            +----------------------------+
            | 1 |
            +----------------------------+
            1 row in set (0.00 sec)


            then goto STEP 02.



            This needs to be in /etc/my.cnf on both Master1 and Master2.



            If you did not, please add it and restart mysqld on both Master1 and Master2.



            STEP 02



            Did you enable binary logging on Master2 ?



            You should have a line in Master1's /etc/my.cnf like this



            log-bin = ....


            Please make sure Master2 has it.



            If you are not sure if it has it, login to MySQL on Master2 and run



            mysql> show binary logs;


            If it echoes



            mysql> show binary logs;
            ERROR 1381 (HY000): You are not using binary logging


            Then, add that log-bin line to /etc/my.cnf in Master2 and restart mysql in Master2.



            Once log-slave-updates and log-bin have been enabled on both Master1 and Master2, you are ready to setup replication in the other direction



            STEP 03



            On Master2



            STOP SLAVE;
            FLUSH TABLES;
            FLUSH LOGS;
            SHOW BINARY LOGS;


            STEP 04



            On Master1



            CHANGE MASTER TO
            MASTER_HOST='IP or Hostname of Master2',
            MASTER_PORT=3306,
            MASTER_USER='...',
            MASTER_PASSWORD='...',
            MASTER_LOG_FILE='First Binary Log On Master2',
            MASTER_LOG_POS=4
            ;
            SHOW SLAVE STATUSG


            STEP 05



            Test Connectivity from Master1 to Master2



            On Master1



            START SLAVE IO_THREAD;
            DO SLEEP(10);
            SHOW SLAVE STATUSG


            Look for Slave_IO_Running. It should be 'Yes'.



            Run SHOW SLAVE STATUSG like 3-5 times. Relay_Log_Space should be increasing.



            STEP 06



            Start processing SQL from Relay Logs



            Run this on Master1



            START SLAVE SQL_THREAD;
            DO SLEEP(10);
            SHOW SLAVE STATUSG


            Look for Slave_SQL_Running. It should be 'Yes'.



            Look for Seconds_Behind_Master. It should be 0. If it greater than 0, keep running SHOW SLAVE STATUSG until Seconds_Behind_Master is 0.






            share|improve this answer
























            • Thanks, Is any other way to setup initial replication without mysqldump? its taking more time and resource.

              – Bhuvanesh
              Apr 7 '17 at 4:21











            • Step 4 must be changed to CHANGE MASTER in newer versions.

              – Rick James
              Apr 7 '17 at 5:43
















            2














            I am glad you were able to mysqldump 1.5TB database. You are sure patient.



            Now for the reality check. You will some downtime for reboots and pausing.



            No need to mysqldump anymore.



            STEP 01



            Did you put this line in /etc/my.cnf on both Master1 and Master2 ?



            log-slave-updates


            If you not sure, run this on both Master1 and Master



            select @@global.log_slave_updates;


            If you get this on both Master1 and Master2



            mysql> select @@global.log_slave_updates;
            +----------------------------+
            | @@global.log_slave_updates |
            +----------------------------+
            | 1 |
            +----------------------------+
            1 row in set (0.00 sec)


            then goto STEP 02.



            This needs to be in /etc/my.cnf on both Master1 and Master2.



            If you did not, please add it and restart mysqld on both Master1 and Master2.



            STEP 02



            Did you enable binary logging on Master2 ?



            You should have a line in Master1's /etc/my.cnf like this



            log-bin = ....


            Please make sure Master2 has it.



            If you are not sure if it has it, login to MySQL on Master2 and run



            mysql> show binary logs;


            If it echoes



            mysql> show binary logs;
            ERROR 1381 (HY000): You are not using binary logging


            Then, add that log-bin line to /etc/my.cnf in Master2 and restart mysql in Master2.



            Once log-slave-updates and log-bin have been enabled on both Master1 and Master2, you are ready to setup replication in the other direction



            STEP 03



            On Master2



            STOP SLAVE;
            FLUSH TABLES;
            FLUSH LOGS;
            SHOW BINARY LOGS;


            STEP 04



            On Master1



            CHANGE MASTER TO
            MASTER_HOST='IP or Hostname of Master2',
            MASTER_PORT=3306,
            MASTER_USER='...',
            MASTER_PASSWORD='...',
            MASTER_LOG_FILE='First Binary Log On Master2',
            MASTER_LOG_POS=4
            ;
            SHOW SLAVE STATUSG


            STEP 05



            Test Connectivity from Master1 to Master2



            On Master1



            START SLAVE IO_THREAD;
            DO SLEEP(10);
            SHOW SLAVE STATUSG


            Look for Slave_IO_Running. It should be 'Yes'.



            Run SHOW SLAVE STATUSG like 3-5 times. Relay_Log_Space should be increasing.



            STEP 06



            Start processing SQL from Relay Logs



            Run this on Master1



            START SLAVE SQL_THREAD;
            DO SLEEP(10);
            SHOW SLAVE STATUSG


            Look for Slave_SQL_Running. It should be 'Yes'.



            Look for Seconds_Behind_Master. It should be 0. If it greater than 0, keep running SHOW SLAVE STATUSG until Seconds_Behind_Master is 0.






            share|improve this answer
























            • Thanks, Is any other way to setup initial replication without mysqldump? its taking more time and resource.

              – Bhuvanesh
              Apr 7 '17 at 4:21











            • Step 4 must be changed to CHANGE MASTER in newer versions.

              – Rick James
              Apr 7 '17 at 5:43














            2












            2








            2







            I am glad you were able to mysqldump 1.5TB database. You are sure patient.



            Now for the reality check. You will some downtime for reboots and pausing.



            No need to mysqldump anymore.



            STEP 01



            Did you put this line in /etc/my.cnf on both Master1 and Master2 ?



            log-slave-updates


            If you not sure, run this on both Master1 and Master



            select @@global.log_slave_updates;


            If you get this on both Master1 and Master2



            mysql> select @@global.log_slave_updates;
            +----------------------------+
            | @@global.log_slave_updates |
            +----------------------------+
            | 1 |
            +----------------------------+
            1 row in set (0.00 sec)


            then goto STEP 02.



            This needs to be in /etc/my.cnf on both Master1 and Master2.



            If you did not, please add it and restart mysqld on both Master1 and Master2.



            STEP 02



            Did you enable binary logging on Master2 ?



            You should have a line in Master1's /etc/my.cnf like this



            log-bin = ....


            Please make sure Master2 has it.



            If you are not sure if it has it, login to MySQL on Master2 and run



            mysql> show binary logs;


            If it echoes



            mysql> show binary logs;
            ERROR 1381 (HY000): You are not using binary logging


            Then, add that log-bin line to /etc/my.cnf in Master2 and restart mysql in Master2.



            Once log-slave-updates and log-bin have been enabled on both Master1 and Master2, you are ready to setup replication in the other direction



            STEP 03



            On Master2



            STOP SLAVE;
            FLUSH TABLES;
            FLUSH LOGS;
            SHOW BINARY LOGS;


            STEP 04



            On Master1



            CHANGE MASTER TO
            MASTER_HOST='IP or Hostname of Master2',
            MASTER_PORT=3306,
            MASTER_USER='...',
            MASTER_PASSWORD='...',
            MASTER_LOG_FILE='First Binary Log On Master2',
            MASTER_LOG_POS=4
            ;
            SHOW SLAVE STATUSG


            STEP 05



            Test Connectivity from Master1 to Master2



            On Master1



            START SLAVE IO_THREAD;
            DO SLEEP(10);
            SHOW SLAVE STATUSG


            Look for Slave_IO_Running. It should be 'Yes'.



            Run SHOW SLAVE STATUSG like 3-5 times. Relay_Log_Space should be increasing.



            STEP 06



            Start processing SQL from Relay Logs



            Run this on Master1



            START SLAVE SQL_THREAD;
            DO SLEEP(10);
            SHOW SLAVE STATUSG


            Look for Slave_SQL_Running. It should be 'Yes'.



            Look for Seconds_Behind_Master. It should be 0. If it greater than 0, keep running SHOW SLAVE STATUSG until Seconds_Behind_Master is 0.






            share|improve this answer













            I am glad you were able to mysqldump 1.5TB database. You are sure patient.



            Now for the reality check. You will some downtime for reboots and pausing.



            No need to mysqldump anymore.



            STEP 01



            Did you put this line in /etc/my.cnf on both Master1 and Master2 ?



            log-slave-updates


            If you not sure, run this on both Master1 and Master



            select @@global.log_slave_updates;


            If you get this on both Master1 and Master2



            mysql> select @@global.log_slave_updates;
            +----------------------------+
            | @@global.log_slave_updates |
            +----------------------------+
            | 1 |
            +----------------------------+
            1 row in set (0.00 sec)


            then goto STEP 02.



            This needs to be in /etc/my.cnf on both Master1 and Master2.



            If you did not, please add it and restart mysqld on both Master1 and Master2.



            STEP 02



            Did you enable binary logging on Master2 ?



            You should have a line in Master1's /etc/my.cnf like this



            log-bin = ....


            Please make sure Master2 has it.



            If you are not sure if it has it, login to MySQL on Master2 and run



            mysql> show binary logs;


            If it echoes



            mysql> show binary logs;
            ERROR 1381 (HY000): You are not using binary logging


            Then, add that log-bin line to /etc/my.cnf in Master2 and restart mysql in Master2.



            Once log-slave-updates and log-bin have been enabled on both Master1 and Master2, you are ready to setup replication in the other direction



            STEP 03



            On Master2



            STOP SLAVE;
            FLUSH TABLES;
            FLUSH LOGS;
            SHOW BINARY LOGS;


            STEP 04



            On Master1



            CHANGE MASTER TO
            MASTER_HOST='IP or Hostname of Master2',
            MASTER_PORT=3306,
            MASTER_USER='...',
            MASTER_PASSWORD='...',
            MASTER_LOG_FILE='First Binary Log On Master2',
            MASTER_LOG_POS=4
            ;
            SHOW SLAVE STATUSG


            STEP 05



            Test Connectivity from Master1 to Master2



            On Master1



            START SLAVE IO_THREAD;
            DO SLEEP(10);
            SHOW SLAVE STATUSG


            Look for Slave_IO_Running. It should be 'Yes'.



            Run SHOW SLAVE STATUSG like 3-5 times. Relay_Log_Space should be increasing.



            STEP 06



            Start processing SQL from Relay Logs



            Run this on Master1



            START SLAVE SQL_THREAD;
            DO SLEEP(10);
            SHOW SLAVE STATUSG


            Look for Slave_SQL_Running. It should be 'Yes'.



            Look for Seconds_Behind_Master. It should be 0. If it greater than 0, keep running SHOW SLAVE STATUSG until Seconds_Behind_Master is 0.







            share|improve this answer












            share|improve this answer



            share|improve this answer










            answered Apr 6 '17 at 21:51









            RolandoMySQLDBARolandoMySQLDBA

            142k24223379




            142k24223379













            • Thanks, Is any other way to setup initial replication without mysqldump? its taking more time and resource.

              – Bhuvanesh
              Apr 7 '17 at 4:21











            • Step 4 must be changed to CHANGE MASTER in newer versions.

              – Rick James
              Apr 7 '17 at 5:43



















            • Thanks, Is any other way to setup initial replication without mysqldump? its taking more time and resource.

              – Bhuvanesh
              Apr 7 '17 at 4:21











            • Step 4 must be changed to CHANGE MASTER in newer versions.

              – Rick James
              Apr 7 '17 at 5:43

















            Thanks, Is any other way to setup initial replication without mysqldump? its taking more time and resource.

            – Bhuvanesh
            Apr 7 '17 at 4:21





            Thanks, Is any other way to setup initial replication without mysqldump? its taking more time and resource.

            – Bhuvanesh
            Apr 7 '17 at 4:21













            Step 4 must be changed to CHANGE MASTER in newer versions.

            – Rick James
            Apr 7 '17 at 5:43





            Step 4 must be changed to CHANGE MASTER in newer versions.

            – Rick James
            Apr 7 '17 at 5:43













            0














            As I'm not able to comment yet I need to write a new answer. I would like to add to the 6 steps of @RolandoMySQLDBA that the CHANGE MASTER TO command did not work for me. As the last command of STEP 03 you should run



            SHOW MASTER STATUS;


            instead of



            SHOW BINARY LOGS;


            and use the respective output as MASTER_LOG_FILE and MASTER_LOG_POS in the CHANGE MASTER TO command of STEP 04.






            share|improve this answer








            New contributor




            dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
            Check out our Code of Conduct.

























              0














              As I'm not able to comment yet I need to write a new answer. I would like to add to the 6 steps of @RolandoMySQLDBA that the CHANGE MASTER TO command did not work for me. As the last command of STEP 03 you should run



              SHOW MASTER STATUS;


              instead of



              SHOW BINARY LOGS;


              and use the respective output as MASTER_LOG_FILE and MASTER_LOG_POS in the CHANGE MASTER TO command of STEP 04.






              share|improve this answer








              New contributor




              dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
              Check out our Code of Conduct.























                0












                0








                0







                As I'm not able to comment yet I need to write a new answer. I would like to add to the 6 steps of @RolandoMySQLDBA that the CHANGE MASTER TO command did not work for me. As the last command of STEP 03 you should run



                SHOW MASTER STATUS;


                instead of



                SHOW BINARY LOGS;


                and use the respective output as MASTER_LOG_FILE and MASTER_LOG_POS in the CHANGE MASTER TO command of STEP 04.






                share|improve this answer








                New contributor




                dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                Check out our Code of Conduct.










                As I'm not able to comment yet I need to write a new answer. I would like to add to the 6 steps of @RolandoMySQLDBA that the CHANGE MASTER TO command did not work for me. As the last command of STEP 03 you should run



                SHOW MASTER STATUS;


                instead of



                SHOW BINARY LOGS;


                and use the respective output as MASTER_LOG_FILE and MASTER_LOG_POS in the CHANGE MASTER TO command of STEP 04.







                share|improve this answer








                New contributor




                dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                Check out our Code of Conduct.









                share|improve this answer



                share|improve this answer






                New contributor




                dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                Check out our Code of Conduct.









                answered 10 mins ago









                dirkaholicdirkaholic

                12




                12




                New contributor




                dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                Check out our Code of Conduct.





                New contributor





                dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                Check out our Code of Conduct.






                dirkaholic is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
                Check out our Code of Conduct.






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Database Administrators Stack Exchange!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f169357%2fmysql-master-to-master-replication-without-downtime-in-live-production%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Szabolcs (Ungheria) Altri progetti | Menu di navigazione48°10′14.56″N 21°29′33.14″E /...

                    Discografia di Klaus Schulze Indice Album in studio | Album dal vivo | Singoli | Antologie | Colonne...

                    How to make inet_server_addr() return localhost in spite of ::1/128RETURN NEXT in Postgres FunctionConnect to...