Replication Failover/Failback Flashcards
What does a replication group allow a customer to do?
To specify what to replicate, where to replicate to, and how often. This means specifying which account objects replicate, to which regions or cloud platforms, at customizable scheduled intervals.
What does a failover group allow a customer to do
the replication AND the failover of objects in a group. the objects in a group are replicated with point in time consistency, from a source account to one or more target accounts.
What objects can be replicated
Databases
Integrations (Security, API)
Network Policies
Parameters (account level)
Resource Monitors
Roles
Shares
Users
Warehouses
T/F You can choose to failover all failover groups, or only select failover groups.
True
what does database replication do
enables the storing of read-only replicas of an individual primary database in other Snowflake Accounts in different regions or cloud platforms
What is client redirect
a connection URL that can be used by Snowflake clients to connect to Snowflake. The connection can redirect clients to a different Snowflake account as needed.
With async replicataion secondary replicas will typically lag behind the primary objects by how long
The amount of time you configured the replication schedule to be.
T/F you have to recover reads and writes at the same time
False, you can choose to recover both, or one at a time
When an outage is resolved, what steps are needed to restore normal function
Replication: Refresh the failover group(s) in the Snowflake account in the region where the outage occurred.
Failback: Promote the failover group(s) in the Snowflake account where the outage occurred to again serve as the primary failover group(s).
Client Redirect: Point the connection URL used by clients to the Snowflake account in the region where the outage occurred.
What are the steps to restore Read before Write
Client Redirect: Point the connection URL to a snowflake account that stores your read only replica failover group
Failover (When needed): in the event of a long term outage, promote the secondary failover group in the Snowflake account where your connection URL is pointint to serve as read-write primary failover group
What are the steps to restore Write before Read
Failover: Provide the secondary failover group with critical account objects in a different region to serve as the primary failover group(s), which allows writing to the account objects included in each failover group(s). Once the databases in the group(s) are writable, you can use your ETL processes to prioritze writes and reconcile data
Client Redirect (When Needed): Point the connection URL used by clients to the Snowflake account that stores the new primary failover group(s).
T/F A replication group is Read Only
True
What are Five examples of things that cannot be replicated from one region to another
- Pipes
- Streams
- Tasks
- Stages
- External Tables
Which objects are available to replicate on all editions
Database and Share. Everything else takes a Business Critical Edition or higher
