1

I'm managing an Amazon Aurora account. Somebody set it up months ago. The service has TWO instances (same AZ): - project - project-eu-central-1b

Same class (db.t2.small), but different "Replication Role". First is Reader and the second is Writer. The service has only one cluster:project-cluster-1

I wouldn't like paying twice if I need only one instance but I'm not sure if Aurora actually needs two instances (W and R) to work or it was a bad initial setup.

Can I use one instance for reading/writing and "move permissions" on MySQL-side? I'm also interested in "Reserved instances". In actual scenario I think I need to buy two reserved instances, right?

Thanks.

1

Yes, you are paying twice for the instances, but only once for the storage, because they share a single Aurora cluster storage volume (there is only one volume per cluster), which is part of why replication is nearly instantaneous.

You can remove the reader instance, as long as you understand that this will slow down recovery if the lone remaining instance fails -- Aurora will have to spin up a new one, instead of automatically promoting the reader to become a writer, which is what it would otherwise do if the current writer fails.

  • Hmm ok. In case of removing Reader, Spinning up a new one is automatic or should I "restart" the failed instance manually? Do you also know how slow is it? We're talking about more seconds/minutes or hours? Tnks – Davide Mar 30 '18 at 10:08
  • It should be automatic, and it should be "minutes" (as opposed to "seconds" with a running reader available to promote). – Michael - sqlbot Mar 30 '18 at 10:37
  • Note that Aurora for MySQL has a few administrative directives that feature some oddly-satisfyingly syntax, like mysql> ALTER SYSTEM CRASH INSTANCE; which does what it sounds like it does... docs.aws.amazon.com/AmazonRDS/latest/UserGuide/… These can't fully perform all failure scenarios, but I thought this might be of some interest, if you haven't seen it. – Michael - sqlbot Mar 30 '18 at 16:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.