Comments on How To Set Up Database Replication In MySQL On Ubuntu 9.10

How To Set Up Database Replication In MySQL On Ubuntu 9.10 This tutorial describes how to set up database replication in MySQL. MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

4 Comment(s)

Add comment

Please register in our forum first to comment.

Comments

By: Guy Patterson

Does the replication provide any sort of encryption? In other words, if DB server1 is in a Texas datacenter, and DB server2 is in Seattle, and replication is occurring over the WAN, is that data transferred in the clear?

 Thanks,

 Guy

www.nullamatix.com

By: LenZ

Hi Guy,

 yes, the MySQL Client/Server Protocol is not encrypted by default. However, you can configure MySQL to either use SSL (see http://dev.mysql.com/doc/refman/5.1/en/replication-solutions-ssl.html), or you could set up an SSH tunnel or any other encryption tunnel or VPN solution.

 Bye,

    LenZ

By: Anonymous

Hi

Every one Pls give me the solution,

When i test my slave server using this command,

>show slave status \G;

IT has display all outoput's

But,


Last_IO_Error: error connecting to master [email protected]

Two servers are pinging and Master is perfectly correct

But not working

mysql> show slave status\G;
*************************** 1. row ***************************
               Slave_IO_State: Connecting to master
                  Master_Host: 127.0.0.1
                  Master_User: root
                  Master_Port: 9306
                Connect_Retry: 1
              Master_Log_File:
          Read_Master_Log_Pos: 4
               Relay_Log_File: slave-relay-bin.000001
                Relay_Log_Pos: 4
        Relay_Master_Log_File:
             Slave_IO_Running: No
            Slave_SQL_Running: Yes
              Replicate_Do_DB:
          Replicate_Ignore_DB:
           Replicate_Do_Table:
       Replicate_Ignore_Table:
      Replicate_Wild_Do_Table:
  Replicate_Wild_Ignore_Table:
                   Last_Errno: 0
                   Last_Error:
                 Skip_Counter: 0
          Exec_Master_Log_Pos: 0
              Relay_Log_Space: 106
              Until_Condition: None
               Until_Log_File:
                Until_Log_Pos: 0
           Master_SSL_Allowed: No
           Master_SSL_CA_File:
           Master_SSL_CA_Path:
              Master_SSL_Cert:
            Master_SSL_Cipher:
               Master_SSL_Key:
        Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
                Last_IO_Errno: 2003
                Last_IO_Error: error connecting to master '[email protected]:9306' -
retry-time: 1  retries: 10
               Last_SQL_Errno: 0
               Last_SQL_Error:

By: fury