Analysis Flashcards

1
Q

Offloading Database Workload – AWS RDS Read Replication

A

Read replicas can be used to offload work from the main database

    • Writes go to the source instance;
    • Reads go to the read replica(s);
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

how AWS RDS Read Replication works?

A

replication to read replicas is made asynchronously(not at the same time);
data is written to the source instance, and then replicated to the read replica(s)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

RDS Read Replication vs Multi-AZ failover deployments

A

– read replicas are built primarily for performance and offloading work.
– multi-AZ deployments are used for high availability and durability
– multi-AZ deployments give us synchronous replication instead of asynchronous.
– multi-AZ deployments are only used to perform a failover, they are idle the rest of the time.
– read replicas are used to serve legitimate traffic
it is often beneficial to use both of these as complements.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

pre-warming volume from a snapshot

A

by reading from every single block

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Potential Networking Issues

A

one of the primary network bottlenecks comes from EC2 instances

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Potential causes for bottlenecks

A

Instances are in different AZ, regions, or continents
BC2 instance sizes
not using enhanced networking features.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

check network performance

A

with iperf3

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

VPCs

A

VPC peering to create a reliable connection

– No single point of failure for communication or bandwidth bottlenecks.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Bandwidth limitations on your VPN to your AWS VPC

A

use AWS Direct connect

    • dedicated network connection
    • Sets up a private connection
    • Can reduce costs in some situations
    • supports port speeds of 1Gbps and 10 Gbps
    • Speeds of 50 Mbps, 100Mbps, 200Mbps, …and 500 Mbps can be ordered through an APN Partner supporting AWS Direct Connect.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

troubleshooting Auto Scaling Issues

A
    • use the wrong subnet
    • availability is no longer available or supported
    • security group does not exist
    • key pair associated does not exist
    • auto scaling configuration is not working correctly
    • instance type specification is not supported in that availability zone
    • auto scaling service is not enabled on the account.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly