Hi, U can see below, http://www.codeproject.com/Articles/715550/SQL-Server-Replication-Step-by-Step
Cheer up! regards, Nori > Yes... about MSSQL.. (im trying with log shipping) > > Regards > Sreeraj R S > > On Wed, Nov 18, 2015 at 5:55 AM, Eric Broch <[email protected]> wrote: > > > The question was about MSSQL not MySQL > > > > > > On 11/17/2015 4:59 PM, Havrla wrote: > > > 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] > > > > > > > > > --------------------------------------------------------------------- > > 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]
