GLB 0.7.3 released

Submitted by alex on October 16, 2009 - 00:48
in

Featuring bugfixes and cleanups. Notably now connects/disconnects can happen concurrently. Download here

  • Kirjaudu·tai·rekisteröidy·kirjoittaaksesi kommentteja

Kommentit

How galera supports "SELECT

Submitted by man4j on October 28, 2009 - 14:07.

How galera supports "SELECT FOR UPDATE" statement for pessimistic locking?

  • Kirjaudu·tai·rekisteröidy·kirjoittaaksesi kommentteja

SELECT FOR UPDATE

Submitted by alex on October 28, 2009 - 20:00.

Galera is concerned only with committed changes so it is simply does not care about "SELECT FOR UPDATE". Note however, that if a writeset from another node needs to modify any row locked by local transaction, that transaction is rolled back as deadlocked. This is true of any locks, including those left by "SELECT FOR UPDATE". Thus in Galera cluster application may have deadlocks where in a single server setup it normally didn't and "SELECT FOR UPDATE" is no guarantee for successful commit.

  • Kirjaudu·tai·rekisteröidy·kirjoittaaksesi kommentteja