Configuring relational data services Flashcards
What three things can you configure for an Azure database for PostgreSQL? Give a summary of each.
Parameters. (Not all native parameters are supported or available)
Extensions. (Not all native Postgres extensions are supported)
Read replicas - you can configure up five read-replicas to improve performance and scale read-intensive workloads. (Each read replica incurs a cost for the provisioned compute.)
What two things can you configure for an Azure database for MySQL? Give a summary of each.
Parameters. (Not all parameters can be adjusted)
Read replicas - you can configure up five read-replicas to improve performance and scale read-intensive workloads. (Each read replica incurs a cost for the provisioned compute.)
What can you configure for read-replicas?
Where they’re replicated to (for non-basic servers).
How are read-replicas updated?
Asynchronously with the master server.
What would you use read-replicas for?
Read-intensive workloads like BI and analytics.
What wouldn’t you use read-replicas for?
Write-intensive workloads.