Can any one shed some light on how to set this up and the advantages and disadvantages of it.
I've read the manual ... but would kinda need some more clarification and idea's for supporting 4 db's.
i.e. Shared-Nothing (will i need a machine for each db or can i run it on one server???), middle tier (will it be needed) & can I test this on a single Linux Box... and is the clustering vertical scaling or horizontal scaling ...etc.
I have a MySQL server running, the problem I'm trying to solve is:
I have a query that gets sent from a client that takes time to complete, so when other clients send there smaller less time consuming queries they have to wait in a queue till it finishes running the first query. I'd like the other queries to get sent to a different db in order to speed up the process.
Can MySQL accomplish this with clustering? Any idea's of best set up?