Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
What is the most efficient redundant database solution?
I need a way to install a database server which is completely redundant and allows new databases to be added live with no downtime.
That last part is the real challenge as solutions such as master-master replication as shown in Digital Ocean's Mysql master-master replication work perfectly with previously known databases. This approach simply does not allow to add new databases without downtime.
2 Answers
- juliepelletierLv 74 years ago
After much reading and verification, I found that there are actually no mature (production ready) solutions to distribute write operations except the MySQL master-master solution mentioned in the question (which is far from efficient for significant loads).
The best solution I came up with is to use MongoDB which natively supports partitioning and redundancy. Its only limitation in regards to my question being that a data set can only be written on a single node at a time, but because of its automatic fail-over, this remains more efficient than the MySQL solution which has other limitations that prompted this question.
- Anonymous4 years ago
Maybe Yahoo will read the Best Answer and implement it. They need to do something with all the access problems this site has.