3 ms·
Amazon's 'replication' is not mysql replication though, it is a drbd block level replication and can not be used for scaling reads like normal mysql slaves can
by ezmobius 17y ago
Amazon's 'replication' is not mysql replication though, it is a drbd block level replication and can not be used for scaling reads like normal mysql slaves can be used.
- jdunck 17y agoWhy can't DRBD be used for scaling reads?
- ezmobius 17y agoIt can but you will not have access to the secondary drbd'd system on the rds service, it is strictly for ha and not for read scaling.
- spidaman 17y agoThe app I've been working on doesn't use replicas for read scaling, just cache-money (ergo, activerecord). We're partitioning for write scaling but no slaves (well, we're doing master/master replication but not for read capacity). After having had to contend with replication lag, lots of instances spinning and related headaches for years I'm pretty convinced that scaling reads with binlogs is in my past for good; it's way more expensive than having a good write-through cache.