The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

SQL Server replication to Maria DB

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

Answer Answered by Daniel Black in this comment.

Hi, I am new to Maria DB and have no past experience with MySQL.

Why are you changing then?

I am trying to create replication between SQL Server 2005 and Maria DB 10.0.14

You can only replication between the right MySQL/MariaDB versions where the master is a lower or equal version. Replication from SQL Server can't be done natively.

Import speed? - see http://hashmysql.org/wiki/InnoDB_Import_Speed

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.