← Back to team overview

maria-discuss team mailing list archive

New Question: SQL Server replication to Maria DB



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.

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?


To view or answer this question please visit: http://mariadb.com/kb/en/sql-server-replication-to-maria-db/

Follow ups