GaussDB vs. HeidiSQL vs. MySQL Migration Toolkit vs. PostgreSQL Data Access Components Comparison Chart

GaussDB (for MySQL) is a next generation MySQL-compatible, enterprise-class distributed database service. It uses a decoupled compute and storage architecture and data functions virtualization (DFV) storage that auto-scales up to 128 TB per DB instance. There is virtually no risk of data loss. It supports millions of QPS throughputs and cross-AZ deployment, combining the performance and reliability of commercial databases with the flexibility of open source databases. By decoupling compute and storage, connecting them through RDMA, and using a "log as database" architecture, you can get seven times the performance of open-source databases. To scale read capacity and performance, you can add up to 15 read replicas for a primary node within minutes. GaussDB(for MySQL) is fully compatible with MySQL. You can easily migrate your MySQL databases to GaussDB(for MySQL) without reconstructing existing applications and without sharding.

MySQL Migration Toolkit is a software pack to convert any data source to MySQL and vice versa. The product has high performance because it does not use ODBC or any other middleware software. Command line support allows to script, automation and scheduling the conversion process. MySQL Migration Toolkit allows users to do the indirect conversion and get more control over the process. Following this way, the program converts data into a local MySQL dump file instead of moving it to MySQL server directly. This dump file contains MySQL statements to create all tables and to fill them with the data. Click here to learn how to import dump file into MySQL database. Once you stored conversion settings into your profile you can run the program in Quick Launch mode. Just launch Windows Explorer and double-click on the profile description file with left mouse button. It will launch the appropriate conversion process loading necessary settings from the specified profile.