4 ms·
Would it be a good idea to store Mysql db on EFS to be shared among load-balanced instances?
by vizzah 12y ago
Would it be a good idea to store Mysql db on EFS to be shared among load-balanced instances?
- simonw 12y agoNo, absolutely not. See the warning on http://dev.mysql.com/doc/refman/5.0/en/multiple-data-directories.html http://dev.mysql.com/doc/refman/5.0/en/multiple-data-directo...
- nkozyra 12y agoAs simonw points out, it produces a real problem with regard to MySQL and the way it handles its data source(s) in general, but more importantly, it's wholly unnecessary. The right way to do that (in AWS world) would be RDS accessible to all instances in the security group. This yields locking control to the application level and not the file system. For obvious reasons this makes a lot of sense. There are of course non-ACID / NoSQL solutions for which this might be an acceptable practice, but in general I'd say it's fraught with peril.
- rev_bird 12y agoThis idea got shot down pretty quick, but I love that it was asked. Coming up with potentially disastrous sideways use-cases for new toys is a favorite pastime of mine.