[Maria-discuss] New Question: SQL Server replication to Maria DB
Hello, A new question has been asked in "MariaDB Community" by zeeshan_amin. Please answer it at http://mariadb.com/kb/en/sql-server-replication-to-maria-db/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Hi, I am new to Maria DB and have no past experience with MySQL. I am trying to create replication between SQL Server 2005 and Maria DB 10.0.14 Publication has 2 tables with close to 24 million rows, and taking a long time to load data into Maria DB. There is no other user connected to MariaDB, Looking at the workbench, i see InnoDB Buffer usage close to 87%, key Efficiency 100%, and Traffic 35KB/sec. as per current speed 2million rows an hour, its going to take 12 hours to load 24 million rows. Any help in making this load faster? Regards Zee -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/sql-server-replication-to-maria-db/
It would be much faster to use bcp to dump the data, and load it into mariadb using the 'LOAD DATA INFILE' command. You can use freebcp from the mariadb server to get data from mssql. Rich
participants (2)
-
AskMonty KB
-
Richard Bensley