数据库读写分离技术在能源管理上传系统中的设计及应用  

Design And Application Of Database Read-Write Separation Technology In Energy Management Upload System

作　　者：黄青 刘满 鄢星波 Huang Qing;Liu Man;Yan Xingbo

机构地区：[1]万洲电气襄阳研发中心

出　　处：《变频器世界》2022年第12期82-84,共3页The World of Inverters

摘　　要：保障能源管理上传系统的高效可用,构建基于数据库读写分离的系统框架,实现能源使用数据上传共享。通过数据库复制软件扩展会出多个用来提供读操作应用的复制库,将数据的统计查询、报表应用、数据上传等需求从主数据库中分离出来,构建数据库读写分离新框架。数据库读写分离技术提高了能源管理上传系统的高效性、安全性、保障了企业能源管理分析主要业务的正常开展,同时又实现了数据的上传共享。本文将对能源管理上传系统的数据库读写分离设计进行详细介绍。Ensure the efficient availability of the energy management upload system,build a system framework based on the separation of database reading and writing,and realize the upload and sharing of energy use data.Through the expansion of database replication software,multiple replication libraries will be created to provide read operation applications,separating the statistical query,report application,data upload and other requirements of data from the main database,and building a new framework for database read-write separation.The database read-write separation tech no logy improves the efficie ncy and security of the en ergy man ageme nt upload system,ensures the n ormal development of the main business of enterprise energy management analysis,and realizes the upload and sharing of data at the same time.This paper will introduce the design of database read-write separation of energy management upload system in detail.

关 键 词：读写分离 系统架构 数据库复制 

分 类 号：TP392[自动化与计算机技术—计算机应用技术]