Decision to migrate database from MySQL to PostgreSQL is hard to make but it may bring a lot of benefits since PostgreSQL has a lot of advanced features compared to MySQL.
To make the database migration safe and clean, it is recommended to shut down the MySQL server for the timeframe of data transfer. Therefore, the most crucial challenge of MySQL to PostgreSQL migration is reducing downtime of the source MySQL database and avoiding unacceptable system overhead at the same time.
To achieve this goal, MySQL to PostgreSQL converter combines the most efficient low-level techniques of reading and writing data with efficient algorithm of multi-threading database migration. It does not use generic APIs like ODBC or another middleware, instead the program integrates the following native libraries for reading and writing the data:
To further improve MySQL to PostgreSQL converter's performance, software engineers of Intelligent Converters have designed and developed multi-threading database migration algorithm. It is activated for medium and large size tables having more than 100,000 rows. The main feature of the implemented algorithm is capability to set up all parameters automatically based on hardware platform. For instance, number of rows per transaction is calculated depending on available memory while the number of simultaneous threads is set up based on number of physical CPU cores.
Implementation of the specified algorithm increased performance of MySQL to PostgreSQL converter in more than 4 times. Recent benchmarks indicate improvement of database migration speed from 120 MB per minute to more than 500MB per minute (after algorithm implementation) on Intel(R) Core(TM) i7-12650H 2.30 GHz system with 32GB RAM.
Database migration from MySQL to PostgreSQL can be a complex task, especially for large scale data in heterogeneous IT environments. However, it can be done effectively using suitable high performance tools like MySQL to PostgreSQL converter produced by Intelligent Converters. This product helps to reduce cost of database migration project and ensure accuracy of the migrated data.