Slony-I Documentation
[http://slony.info/ Slony-I Docs]
Difference Between a Slony-I Replica and a Warm Standby Server
1. Scope: per-table vs whole database
2. Availability: available vs standby
Replication Lag Requirement
From Phil's notes:
1. Access to quicklook data:
- For Ops at LMSAL should be with lag of few minutes from real time. For NOAA, JSC, Air Force, etc., can be c. 5-10 minutes probably.
2. Clone for web access:
- This can have a lag of 10s of minutes, maybe hour or more. Except for quicklook images movies of certain series. I wonder if we prepare some data for general purpose wide access via web and move that to a web server that does not have the full database access. That could be done in parallel with a full access clone of drms that has a lag and is used for searches of archived data for export.
3. Remote replicas:
Locations of Remote Replicas
0. LM
1. MSSL
2. Germany
3. SAO
4. India
Test Tasks
1. Log shipping
2. What happens when DB server goes down and when DB server reboots
3. How to add tables to replication set while slon daemon is running?
3. Replica DB maintenance? e.g., rebuild index, vacuum, etc.
4. How to copy table schema and role information
5. Is there a way to subscribe to part of a series?