Re: [Dbmail] Loadbalanced MySQL Cluster, can deadlock occur ?

2016-02-14 Thread Matt .
That is not what I state. If 2 rows are inserted on two different DB server and one needs to be updated because of these two inserts, this might run into a lock on the update of this one for each insert. 2016-02-13 21:09 GMT+01:00 Andrea Brancatelli : > If a two messages arrive at the same time on

Re: [Dbmail] Loadbalanced MySQL Cluster, can deadlock occur ?

2016-02-14 Thread Gordan Bobic
Deadlocks can occur even with a _single_ server and no clustering, unless you are running with transaction isolation level set to "serializable", which comes with a massive performance penalty (it will give you write concurrency of 1, i.e. as bad as MyISAM). On 14/02/16 12:36, Matt . wrote: T