Research and design of database for distributed bridge data acquisition system

In this paper, it is focused on the method about the distributional database backup system. The system consists of MySQL database backup system in the data gathering station and a client application procedure for MySQL database in monitor center. Under the condition of not increasing the equipment cost, the system can resolve the problem of the lost gathering data in the long time running gathering system, whose data backup always uses the single database system. According to the industrial machine hardware configuration and the sensor data characteristic, the distributional database essential entity model is established. The effective index and the backup strategy are designed by the actual demand and the practice. And the dual cycle buffer and multithread database interface solves the hard disk I/O speed bottleneck. The problem of the network transmission pressure that is caught by the great data capacity is relaxed by the data compression algorithm.