• Saturday , 23 September 2017

MySQL 5.6 Replication Utilities Tutorial

Code Canyon



MySQL Replication Utilities Tutorial. Learn how to use MySQL 5.6 and the MySQL Utilities to setup, monitor and manage your MySQL replication topology.

Original source

3d Ocean

Related Posts

6 Comments

  1. Dallas Bluth
    August 21, 2017 at 12:39

    What about the config file parameters that need to be setup before the replication can begin?

  2. Gayan Lakshan
    August 21, 2017 at 12:39

    how to get(open) "bill@utils1:~mysql" and "bill@utils2:~mysql" 
    please help.

  3. peace angel
    August 21, 2017 at 12:39

    Nice one 

  4. Rob Silver
    August 21, 2017 at 12:39

    I liked it but though it oversimplified some things. For example the instructor used the root user a lot  which in practical practice is a huge security  no no.
    Also the example did not explain how different configurations or states of the slaves would be effected. For example  can I assume as I have that this tool replicates every database and every table or replicable Storage Engines ?
    What would happen if I was missing any  tables in each of the databases would that effectively copy over just the updates and inserts from the time replication begins or would it synchronize each and all tables??

    For example   if I were replicating a single database innoworld  and I only had City table in my slaves and  all tables in my master what would happen? Would those first checks have failed  or would  the tables be copied to sync up the tables?
    My first thought is no syncing up of tables I must have all the tables defined and only transactions starting when the slaves are started are handled.
    Still it would be good to understand how the failover  utility works internally  which it presumably  does by  keeping track of all the information you shared in those preceding commands. Still those file position issues appear to be handled – where are they handled in the actual mysqlreplicate command?
    Is that where  the master.info  information is essentially handled?
    and the CHANGE TO MASTER commands automatically created and executed in each slave using the original master?

  5. Ojee2
    August 21, 2017 at 12:39

    I think this demo is really confusing with the same names for each server and different ports.

  6. Ivan Tu
    August 21, 2017 at 12:39

    Great demo, thanks Andrew

Leave A Comment

You must be logged in to post a comment.