Replicas

Replica support allows for load balancing of report execution between the master database and the database replicas. You can specify the execution of read-only reports to occur on read-only replicas, while reports that modify the database can be directed to master/read-write replicas.

When a user logs into myDBR, the login is conducted against the database defined in the Environment settings. The user interface runs against the server specified in the Environment settings. Administrators can define, on a per-report basis, against which server the reports are executed. The available choices include:

If the selected replica is marked as read-only in its definition, myDBR disables internal writes to the database. Editable reports will not function when directed to a read-only replica.