usama3zafar:
Howdy! What type of load balancer do we use for MySQL connections (specifically to WRITE) ?
I know about Read Replicas but they will be used for read-only right? The App Load Balancer will only use HTTP/S while Network and Classic Load Balancer will use other.
Im specifically looking for an answer that is more implemented in real life/efficient. Thanks in advance!!
Alistair Mackay:
Due to the way RDBMS works, you can only have one write instance. That is the instance that “owns” the files of the database. RDBMS does not permit multiple writers.
To spread load, you need to send all INSERT DELETE UPDATE and any DML (create table etc) to the single write instance. You can send SELECT to load balanced read replicas.
AWS creates a load balanced endpoint automatically for RDS read replicas, so no ALB/NLB needs to be deployed.
Trung Tran:
Can’t agree more!
usama3zafar:
Thanks guys!