The invention discloses a data synchronous loading method based on a
database log. The method includes the steps that a data synchronous loading
system is provided, wherein the
system comprises a log
streaming data analysis module, a data sending module, a data receiving and caching module, a data
adaptation and
recovery module and a data loading module, the log
streaming data analysis module and the data sending module are arranged in a source-side
database, the data receiving and caching module, the data
adaptation and
recovery module and the data loading module are arranged in a target-side
database, the log
streaming data analysis module is connected with the data sending module, the data sending module is connected with the data receiving and caching module, and the data receiving and caching module is connected with the data
adaptation and
recovery module and the data loading module; a log file generated in the database operation process is analyzed to obtain data operation motion, then data is sent to the target side in a network sending mode, and a corresponding analysis mode is selected to load the data according to the type of the target-side database. Thus, the purpose of different-
database backup is achieved, the influence on a
service system in the
database backup process is effectively reduced, the flexibility of data
backup is improved, and the reliability and consistency of the loaded data are improved.