FAQ's |
| |
|
| |
| |
1. What is data replication?
|
Data replication is feature provides by DBMS vendors to transparently propagate updates(INSERT, UPDATE, DELETE) from one CSQL instance to another instance running on the network. |
| |
|
| |
| 2. When should I use data replication? |
| Replication is used to provide high availability for your application. With replication, applications can fall back to the standby node in case of master node failure instantaneously. It can also be used for scale out applications by distributing load |
| |
|
| |
| 3. Does CSQL supports more than 2 nodes in replication? |
| Yes. CSQL is tested with 16 sites in replication quorum. |
| |
|
| |
| 4. Can I replicate tables which are cached ? |
| Replication can work on both local tables(tables present only in CSQL MMDB) and cached tables(tables cached in MMDB from target database). |
| |
|
| |
| 5. Does CSQL support read scale-out architecture like MySQL ? |
| Yes. CSQL supports single master - multiple slave architecture, in which application can spread the read load on the slave nodes. |
| |
|
| |
| 6. What is synchronous and asynchronous replication? |
| Synchronous refers to the replication mode, in which updates applied to both source site and destination site during the transaction. But in case of asynchronous mode, updates are queued and applied later. |
| |
|
| |
| |
