Hi, Mysql data sync is better ver 5.5.25 later. If you want to use best that I recommend mariaDB-10.0.X something. Mysql-5.6 is deferent. Google had decided change to mariaDB-10.x.x from mysql-5.1.x
regards, Nori > Helooo > > MYSQL1 > [root@tonda ~]# cat /etc/my.cnf > [client] > password = xxxxxx > default-character-set = utf8 > > > > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > user=mysql > # Disabling symbolic-links is recommended to prevent assorted security risks > symbolic-links = 0 > > server-id = 30 > replicate-same-server-id = 0 > auto_increment_increment = 10 > auto_increment_offset = 3 > log-bin = mysql-bin > log-slave-updates > expire_logs_days = 300 > max_binlog_size = 500M > #master-connect-retry = 60 > log_bin_trust_function_creators = 1 > > [mysqld_safe] > #log-error=/var/log/mysqld.log > #pid-file=/var/run/mysqld/mysqld.pid > [root@tonda ~]# > > MariaDB [(none)]> show slave status\G > *************************** 1. row *************************** > Slave_IO_State: Waiting for master to send event > Master_Host: 10.27.24.8 > Master_User: repl > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: mysql-bin.000136 > Read_Master_Log_Pos: 405721721 > Relay_Log_File: tonda-relay-bin.000032 > Relay_Log_Pos: 529 > Relay_Master_Log_File: mysql-bin.000136 > Slave_IO_Running: Yes > 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: 405721721 > Relay_Log_Space: 823 > 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: 0 > Master_SSL_Verify_Server_Cert: No > Last_IO_Errno: 0 > Last_IO_Error: > Last_SQL_Errno: 0 > Last_SQL_Error: > Replicate_Ignore_Server_Ids: > Master_Server_Id: 20 > 1 row in set (0.00 sec) > > MariaDB [(none)]> > > > > > [root@tonda ~]# echo "show databases" | mysql |wc -l > 40 > [root@tonda ~]# > > > ############################################################### > > MYSQL2 > [root@franta ~]# cat /etc/my.cnf > [client] > password = xxxxxx > default-character-set = utf8 > > > > [mysqld] > datadir=/var/lib/mysql > socket=/var/lib/mysql/mysql.sock > user=mysql > # Disabling symbolic-links is recommended to prevent assorted security risks > symbolic-links = 0 > > server-id = 20 > replicate-same-server-id = 0 > auto_increment_increment = 10 > auto_increment_offset = 2 > log-bin = mysql-bin > log-slave-updates > expire_logs_days = 300 > max_binlog_size = 500M > #master-connect-retry = 60 > log_bin_trust_function_creators = 1 > > [mysqld_safe] > #log-error=/var/log/mysqld.log > #pid-file=/var/run/mysqld/mysqld.pid > [root@franta ~]# > > MariaDB [(none)]> show slave status \G > *************************** 1. row *************************** > Slave_IO_State: Waiting for master to send event > Master_Host: 10.27.24.1 > Master_User: repl > Master_Port: 3306 > Connect_Retry: 60 > Master_Log_File: mysql-bin.000137 > Read_Master_Log_Pos: 88127390 > Relay_Log_File: franta-relay-bin.000059 > Relay_Log_Pos: 72485067 > Relay_Master_Log_File: mysql-bin.000137 > Slave_IO_Running: Yes > 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: 88127390 > Relay_Log_Space: 88128253 > 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: 0 > Master_SSL_Verify_Server_Cert: No > Last_IO_Errno: 0 > Last_IO_Error: > Last_SQL_Errno: 0 > Last_SQL_Error: > Replicate_Ignore_Server_Ids: > Master_Server_Id: 30 > 1 row in set (0.00 sec) > > MariaDB [(none)]> > > > > [root@franta ~]# echo "show databases" | mysql |wc -l > 40 > [root@franta ~]# > > > read: > https://www.digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-replication > > > Havrla > > > Dne 17.11.2015 15:27, Sree Raj napsal(a): > > Dear Friends, > > > > How to sync two databases in MS SQL. > > > > > > > > Regards > > Sreeraj R S > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- NoriyukiHayashi<[email protected]> ibisMailで送信！ --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
