Design And Implementation Of Centralized Water And Electricity Meter Reading Management System Based On Microservice Architecture

With the rapid development of information technology,the concepts of "smarter water" and "smarter energy" have entered people’s lives.The scientific and rational use of information technology to manage water and electricity resources is an effective way to achieve efficient use of resources,and the remote meter reading management system is a typical application.However,at present,the domestic water supply and power supply industry has decentralized management,which results in the inability to share information on water and electricity resources and brings the annoyance of multi-card payment and confusion for residents.At the same time,the monolithic architecture,a commonly used software architecture for the development of meter reading management software,cannot provide a sufficiently high guarantee in system reliability,availability,scalability and maintainability.In view of the above situation,this paper designs and develops a set of centralized water and electricity meter reading management system based on the microservice architecture.This system is expected to overcome the defects of the monolithic architecture software,improve the performance of system availability,reliability,scalability,form a centralized management platform for water and electricity resources that integrates collection,storage,calculation,management,control,and realize effective management of water and electricity resources.The main research content and results of the paper are as follows:(1)Following the idea of microservice,the functional requirements of the centralized water and electricity meter reading management system are divided into multiple relatively independent services to be implemented separately,in order to achieve the decoupling of function and structure.The Web management platform with B/S structure is designed and implemented based on the microservice architecture to meet various management needs for centralized management of water and electricity data.To address the inter-service governance issues of the Web management platform,services such as service registration and discovery center,API gateway,and cross-service method call are developed and implemented based on the secondary development of the Spring Cloud framework.At the same time,the distributed transaction management service is developed to ensure data consistency and correctness in the distributed environment.The ELK technology stack is used to design and implement real-time monitoring of platform running errors,which provides an effective way for the subsequent maintenance personnel of the system to find problems in time.(2)The Netty framework is used to develop the data collection service,which realizes the functions of efficiently receiving,parsing and storing TCP smart water and electricity meter data messages sent from the concentrator,and sending device operation instructions to the concentrator.The Kafka message queue is added between the data collection service and the Web management platform to form an internal loose coupling to improve system scalability and instruction delivery speed and throughput.(3)In terms of data storage,after comprehensively considering the "one service one database" model of microservice architecture,cross-service query speed,and the closeness of business functions,this paper designs the relational database and data table structure to enhance service independence and improve the system availability and reliability.To alleviate the pressure of single-table query,some data tables are sharded horizontally.At the same time,Redis cache database is used to improve system performance.(4)The microservice-architecture-based centralized water and electricity meter reading management system is tested with test tools such as Apache JMeter,Apache Bench and various test methods,and the system built by this paper is analyzed based on the test results and the microservice architecture.