Introduction

Purpose and scope

Unify standby database configuration in PortaBilling and PortaBilling Oracularius products. Prevent replication issues as result of incorrect system configuration.

Ticket NumberTT#283909
Target Build
MR49-0
Affected ComponentsConfigurator, Database
Document Start Date2015-04-30

Collaborators

Business Department

Development Department

Testing and Support Departments

Definitions, acronyms and abbreviation

Site - Geo location of one or more physical servers, as defined in Site Redundancy solution.

References

  1. TT#283909#txn-13507520
  2. https://docs.portaone.com/DevelDocs/Specifications/GeoRedundancy
  3. http://portaone.com/portaswitch/redundancy/

Overview

Project goal is to sort out common replication issue that appears as result of improper standby database server configuration on different sites.

For the moment recommended MySQL standby db configuration is:

  • for Main site      : sip schema replication configured
  • for Remote site : sip schema replication must not be configured

Therefore change of server site, where db is configured, requires replication reconfiguration which is usually missed

Specifications

Create "Business requirements" Create "Software requirements" Create "Design requirements"

Testing plan

Prepared by QA. The main goal  is to check Business and Software Requirements. This chapter should be prepared as separate document.

Feature integration guide

It is auxiliary maintenance description which carries information about how to deploy and configure developed solution, its limitation and usage particularities. This chapter should be prepared as separate document.