No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


AMI Smart Meter Reading Solution V200R010C10 Planning and Design Guide

This document describes the overall and detailed design of functions and services in the AMI Smart Meter Reading Solution.
Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Database Reliability Design

Database Reliability Design

The AMI solution supports Oracle and MySQL databases. Deployment solutions of different databases are different and the implementation of reliability is also different.

Oracle Database Reliability Design

Application systems use Oracle 11g databases and support Oracle Real Application Cluster (RAC). Oracle RAC implements reliability. Oracle RAC consists of two computers with the same configuration and one shared storage device, and has powerful database processing capability and event processing performance. It supports all types of application systems, provides high reliability, and allows servers to be added to improve performance.

The active/Standby Oracle database switchover is implemented through Oracle RAC. Each Oracle database server requires at least three network interfaces, among which two interfaces have the public IP address and private IP address configured respectively and another one is used to manage the shared disk array. The active and standby databases still need to be configured with a virtual IP address (VIP) and a virtual Single Client Access Name (SCAN) IP address. Different IP addresses are used to implement communication of different service functions. For functions and planning of IP addresses, see Database Parameter Plan.

The active and standby Oracle databases share the same disk array, and all data is stored in the same disk array. That is, the two Oracle databases share data to ensure data integrity and accuracy and minimize the data backup time. The active and standby Oracle database servers automatically detect the server and database running status of each other. When the active database server or active Oracle database fails, the standby one is used. Application systems use the VIP of Oracle databases to connect to Oracle databases. Additionally, the active and standby CISs, EPMS cluster, EEM cluster, and DCP cluster each correspond to an instance in Oracle databases. Therefore, these application systems are unaware of the active/standby Oracle database switchover.

MySQL Reliability Design

MySQL HA is deployed to ensure database reliability. MySQL HA uses the active/standby mode. All operations of the active MySQL database are logged, and the standby MySQL database reads logs of the active MySQL database and writes them into its relay logs. In addition, all operations of the active MySQL database are performed on the standby MySQL database to implement data synchronization.

MySQL HA uses master-slave replication to ensure that the same data is backed up on different databases and data of active and standby MySQL databases is consistent when they copy data. When an exception of the active MySQL database is detected, the standby MySQL database becomes the active one and all services are switched to the standby MySQL database. The MySQL database continues to provide database services for application systems. After the original active MySQL database recovers, it replicates data of the current active MySQL database to synchronize data. All services are automatically switched to the original active MySQL database, the original active MySQL database becomes the active one, and the current active MySQL database becomes the standby one.

MySQL HA uses Keepalived to detect the status of each database and perform an active/standby switchover. Keepalived detects MySQL services in real time based on VRRP. The active and standby MySQL need to be configured with a VIP. The VIP always corresponds to the active MySQL database. When Keepalived detects an exception on the active MySQL database, the VIP is switched to the standby MySQL database and all services are also switched to the standby MySQL database. Application systems use the VIP to connect to MySQL databases, so they are unaware of the active/standby switchover.

Updated: 2019-03-07

Document ID: EDOC1100069579

Views: 6178

Downloads: 11

Average rating:
This Document Applies to these Products
Related Version
Related Documents
Previous Next