3 ms·
The mistake is thinking half the system is doing nothing. It’s a bit like saying I’m paying to store my backups offsite but most of the time it’s not really use
by jarym 5y ago
The mistake is thinking half the system is doing nothing. It’s a bit like saying I’m paying to store my backups offsite but most of the time it’s not really used so it’s a waste of money. It just doesn’t hold.
Most SQL problems that most of us have to deal with stem from inadequate indexes and/or poorly written queries. No fancy active-active setup will ever solve those issues.
- jayd16 5y agoIt might be a waste. Think RAID 1 vs RAID 5. There might be plenty of ways were leaving performance on the table.
- jeltz 5y agoWhich one of those leaves performance on the table? One is optimized for performance and the other for disk usage.
- jayd16 5y agoMaybe its a bit tortured of a metaphor, but perhaps with continued research we can find a way to use more of the hardware just like how RAID 5 provides more storage over RAID 1 while still keeping parity. I don't think its foolish to keep asking for more. We still might find it.