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)
Comments
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
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
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:
You need to look at these:
http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
http://dev.mysql.com/doc/refman/5.0/en/replication.html
Good luck