The application relates to the technical field of
database migration, and discloses a method for migrating a
database without stopping, and the specific steps comprise the following steps: S40, establishing data bidirectional synchronization of new and old databases; S41, detecting the
data synchronization speed and quality of the new and old databases, if the detection is passed, the next step is performed, and if the detection is not passed, the migration is stopped, and the operation is ended. The method for migrating a
database without stopping, through which
data migration is performed, strictly follows an industry database master-slave synchronization scheme in
data synchronization, the
correctness and integrity of the data are guaranteed, bidirectional synchronization also provides a convenient channel for subsequent
rollback; with the aid of a MySQL Binlog characteristic, a high-efficiency method for inquiring
data synchronization progress is derived,
millisecond-level switching of a new database is supported, the influence on the running business is very small or even zero, and the user is not aware, so that data can be migrated without stopping.