As the key point of this solution, the core back-end Sybase database of store sales management system should run continuously and uninterruptedly to guarantee high availability of the system.With careful screening and with consideration to client's existing resources, Rose Datasystems recommends the business continuity product that is based on data mirroring technology. That is to build a mirrored active/standby solution by the sales management systems’back-end Sybase databases of eight urban stores that have vast passenger flow, to realize business continuity.

Overall architecture description

Hardware platform of each store may not be the same. Some store may need to add one server as the standby server of Sybase database, and some store can use the front-end application server as the standby server, to make full use of hardware resources. When software and hardware environment are ready, user can start to build active/standby cluster based on data mirroring technology with the solution of Rose.

Implementation

Here we take a store as example to elaborate it.

Normally, user can select one of the two servers as Sybase's active server. It will provide external service through active IP, and the data generated by active server is written into its own local disk. At thesame time, Rose solution will transmit the changed data that is captured in real time to standby server through network, to realize that data on two servers is consistent. On this basis, if the activeserver encounters a failure (sever going down; application system fault; or network fault, etc), the protected application cannot continue providing service. Then, under the premise of data consistency, via Rose solution, active server would switch Sybase database to standby server to let it continue providing service, and guarantee that production and management system would run continuously.