Functional Components of the RoleThe role DATA can be installed on one or more database servers. A setup with only one DATA server is only recommended for installations with a low agent count (< 30) and little or no reporting requirements. For non-redundant installations, it is recommended to install a single database master, and a slave database for reporting and statistics. For redundant installations, the DB machines are doubled up as two master-slave pairs, with master-master replication between the two master nodes. Function | Description | Access | Count | Count (redundancy) | Comments |
---|
acd-dbm Primary Master | All routines which write or modify data in the database are executed against the primary DATA master server. | Read and Write | 1 | 2 | In redundant systems, master-master replication with two master databases is used. | acd-dbr Reporting | For the generation of complex reports when queries may take an extremely long time. | Read | 0 or 1 | 1 | In large systems, usually a separate reporting slave is deployed. In redundant systems, acd-dbr and acd-dbs provide redundancy for eachother. | acd-dbs Realtime Statistics
| Generation of real-time statistics (agent home, wallboard and supervisor) in short intervals for the logged in users, supervisors and wallboard users. | Read | 0 or 1 | 1 | In medium systems this database also is used for the reporting role acd-dbr. In redundant systems, acd-dbr and acd-dbs provide redundancy for eachother. | acd-dbc Customer Queries
| If customer access to the databases are required, often a customer specific database instance is installed to prevent accidental damage to the core system. | Read | 0 or 1 | 0 or 1 |
|
Installation Steps |