> I have a app that runs on MySQL and php. It has
> out grown it's current configuation of being on
> one box. I plan to get another box to share the
> load and act as a failover.
If you can, often the best way to do this is to try to get PHP to connect to a different server for intensive queries (such as full text searches and so on), and use replication to keep this box in sync. This box can also be a hot-failover. This will gain you extra time on your current box. Of course you should optimise your current setup as much as possible first!
MySQL cluster *tends* to have a lower performance for most queries that involve table scans (which is most queries in a typical PHP/MYSQL web app) at the moment due to the amount of traffic that has to get shifted around between storage and SQL nos at least in 4.1 and to a lesser extent in 5.0 to answer each query.
Something that often works if the only aim is to increase performance is to "cross replicate" [ A <--> B ] two servers and then use ldirectord/heartbeat to distribute the load between the two servers. There are problems with this approach and you will find much more detail on the problems (and solutions) in the replication forum or you are very welcome to email me directly.
With all best wishes,
Alex Davies
alex@davz.net
Alex Davies
http://www.davz.net |
alex@davz.net