Functional Components of the Role
The 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 |