基于存储过程的主从服务器数据库同步的实现

摘要

The database system is the foundations of the information system, In order to ensure the information system with high usability and the consistency of the data, the master and backup server database synchronization was need. According to the actual need, this paper explorated a master and backup server database synchronous method based on store procedure. Firstly, it introduced store procedure. And then, an example is presented for demonstrating how to use store procedure to realize the master and backup server database synchronization. For some particular system, it had practical significance.%数据库系统是信息系统的基础,为了保证信息系统的高可用性,需要对主从服务器数据库进行同步,保证数据的一致性,本文根据实际需求摸索一种基于存储过程的主从服务器数据库同步方法,首先介绍存储过程,然后用实例说明如何利用存储过程实现主从服务器数据库同步,该方法对于特定系统具有一定的应用指导意义.