Transactions over multiple server

Asked by Franco Riggi on 2011-05-02

Hello

I am looking for a database solution with allow to run transactions over multiple servers and also which keep all the servers synchronised. I have already tested MySQL cluster but it doesn't reach the performances required for several reasons.
I am wondering if Drizzle can be the solution

Regards
Franco

Question information

Language:
English Edit question
Status:
Solved
For:
Drizzle Edit question
Assignee:
No assignee Edit question
Solved by:
Clint Byrum
Solved:
2011-05-04
Last query:
2011-05-04
Last reply:
2011-05-02
Best Clint Byrum (clint-fewbar) said : #1

Franco, right now Drizzle's GA release has single master asynchronous replication, which does not meet your requirements. However, Drizzle is highly extensible, so it should be possible to create synchronous replication as a plugin.

This is never going to scale much better than MySQL cluster since you still need to have a scheme for queries that run across the partitions, or you will have to perform all writes on all servers, making all writes as slow as the slowest server.

Franco Riggi (franco-riggi) said : #2

Hi Clint

Thanks for your answer

Regards
Francesco

Franco Riggi (franco-riggi) said : #3

Thanks Clint Byrum, that solved my question.