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] > >
