Environment configuration for importing sqlserver data to the mysql database

Some time ago, I tried to port the sqlserver database to the mysql database. The solution was that the perl language reads sqlserver for the corresponding type conversion data and writes the data to the mysql execution end and the acceptor end at a speed of 10 million entries. it takes about five minutes for the table to be imported, which solves the problem of garbled code and other problems.

Some time ago, I attempted to port the sqlserver database to the mysql database. The solution was to read sqlserver from the perl language for corresponding type conversion data processing, and write the data to the mysql two execution terminals and one receiving end at a speed of 10 million. the table with the number of levels is imported in about five minutes, which solves the problem of garbled characters and other problems. It takes 3 GB of data library time.

Some time ago, I tried SQL ServerDataLibrary to mysqlDataLibrary

The solution is to use perl to read sqlserver for corresponding type conversion.DataWrite Data to mysql after processing

Two executors and one receiver

The final import speed is 10 million-level tables, which are completed in about 5 minutes. The garbled code and other problems are solved.

3GDataThe Database took half an hour.

15g takes 5 hours

The process is as follows:

FirstEnvironmentOfConfigurationAnd plug-in installation.

First, the acceptor

In a linux system

Install mysql

If the geographic coordinate field geo exists, mysql must use a version later than 5.5.

CentOS6.4 install mysql5.6.14

Then, configure the execution terminal (you can install it on the host of another linux system or on the host of mysql)

Because here we willDataDatabase tables are divided into several parts for runningDataTherefore, if the bottleneck of SQL Server reading and network speed is reached, the more executor computers, the faster the speed.

Install perl on CentOS

Install DBDmysql using PerlDataLibrary

Perl connects to SQLServer through unixODBC

Finally, install handlersocket (because handlersocket has installation steps on both the acceptor and the acceptor)

HandlerSocket introduction and installation and uninstallation