MySQL clustering?

[Aerodyne]

Hi all,

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.

All tips and suggestions are appreciated.

Thanks in advance.

MySQL 4.1.7
Linux OS

 

[Bastien]

get high performance mysql, a great book that talks about this...there are also white papers at

http://www.mysql.com/products/cluster/

Bastien

Cat, the other other white meat

 

[Aerodyne]

Hello,

Thanks for your reply Bastien... I've read some chapters from the High performance MySQL book... but still it's a bit vague to me.

Okay...

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?

Thanks In Advance.

 

[Bastien]

if thats the issue, you may want to look at replication istead. replicate the server and run all the select queries on the replication (slave) server...that frees up the main db server to handle insert, update, deletes...

Bastien

Cat, the other other white meat