MySQL Forums
Forum List  »  NDB clusters

Re: use for data analysis
Posted by: John Parnefjord
Date: November 27, 2006 04:46AM

Thanks for your answer!

Regarding the interconnect speed I will use a gigbit switch on a private network.

One of the major issues are complex queries that are to be run to update values in the database. At the moment, in an ordinary MySQL setup, they take days to complete. But that will only run as one thread.

Then we have the OLTP question which we believe will peak at around 300-400 simultaneous users and this is an PHP application using Apache2 as an frontend.

A solution is to separate the analysis and the OLTP on separate installations, one mysql-cluster and one ordinary mysql server, and then use replication between the databases.

// John

Options: ReplyQuote


Subject
Views
Written By
Posted
1589
November 25, 2006 03:44AM
993
November 26, 2006 11:05PM
Re: use for data analysis
997
November 27, 2006 04:46AM
924
November 27, 2006 06:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.