I recent started employment with a company which has a lot of mysql
servers (100+ is my best estimate so far) and have all of their
database servers, masters and slaves alike, using one of 2 SANs for
data storage. They servers are connected to dedicated switches with
fibre to to SANs and the SANs themselves seem to be well configured
However, it seems preposterous to me that all those very busy
databases should, by design, have a common bottleneck and share a
single point of failure. I am not deeply knowledgeable about SANs or
their performance characteristics; my reaction thus far is pretty much
intuition but I help can't but picture the simple analogue of single
disk or a RAID 10 with synchronized spindles frantically thrashing
back and forth to respond to tens of thousands of queries per second.
Would anyone care to comment? Is my concern justified or am I merely confused?
- michael dykman
- All models are wrong. Some models are useful.