I’m looking to bring my 6 osCommerce shops under one Magento umbrella installation. I’m a bit wary about Magento speed. The shops won’t have tons of traffic, I expect no more than 50 simultaneous shoppers but I’m not sure our dedicated server will be of high enough spec to serve pages in the 2-3 seconds I’ve come to expect.
From reading the various speed concern threads here it seems that the ‘issue’ is that Magento requires a lot of database reads so you need fast disks for excellent I/O throughput. SCSI clusters aren’t cheap so I’m loath to enter an expensive dedicated hosting contract to find out it’s overkill.
So my thinking is as follows.
I’ll upgrade my dedicated server to fast EIDE disks in Raid. Nothing amazing, certainly affordable. Will enable all caching trickery etc. possible.
Now if things start to slow down as traffic grows, I can quickly get a bunch of VPS boxes purely for taking over some SQL queries.
Does Magento have any built-in load balancing features, such as entering multiple database connections?
I’m thinking of sending the read queries (browsing) to the fast disk dedicated server and the write queries (cart and admin stuff) to the VPS for example. Or simply alternate database connections per visitor. Whatever the MySQL load balancing strategy, does Magento allow for this out of the box? Or do I have to set this up in MySQL.
Any feedback on this idea would be very welcome. I need to decide on a server and start migrating!