My website is driven by mysql db, nowadays, the db has grown more than 100G. Each time I feel headache when upgrading the server. My vendor suggests using a SAN instead directly attached internal disk, meanwhile, they advise SAN is faster and safer than disk.
I have no experience on SAN, I'd appreciate any experienced advise on whether SAN is better solution for storing db? Thanks.