Define read-only replication and its uses

Define read-only replication and its uses.

Read only replication creates local copy of table data originating from one or more remote master tables. An application can query the data in a read-only table snapshot, but cannot insert, update, or delete rows in the snapshot of the data.


- Can be treated as back ups of original.
- For faster query performance, read only replication is used.
Read-only replication and snapshots
Replication is the process of copying database into one or more databases to make a system distributed......
Steps executed during SQL statement processing
Steps in Processing SQL Statements - Prepare statement, Bind placeholders, Execute statement, Describe select-list items, Define output variables, Fetch and process data..
Steps executed during a typical transaction
A transaction contains one or more SQL statements, It is an atomic unit...
Post your comment