[sr-dev] mysql driver update

[Shane Harrison]

Hi Peter,

In thread:
http://lists.kamailio.org/pipermail/sr-dev/2013-January/018347.html
you mentioned transaction support that you have added to PostgreSQL driver.
Unfortunately I do need to use mysql as our HA solution is based on mysql
cluster.

Hence I have implemented the required new functions e.g start_transaction.

However mysql only has one table locking mode (unlike PostgreSQL) and if
you lock a table within a transaction, you can't read other tables without
also obtaining locks for them as well.  As there are places where
active_watchers table is locked but the code tries to query the watchers
table, this is an issue.  I have simply disabled the table locking for the
time being.

It is possible that the implicit transaction locking that mysql is enough
to solve the issues you were trying to solve.  To determine this, can you
tell me or point to a thread that explains what race conditions were trying
to be mitigated in process_notifier mode.

Cheers and thanks
Shane

-- 
Imagination NZ Ltd
Level 6
92 Queens Drive
P0 Box 30449
Lower Hutt 5040

+64 4 5703870 Extn 875
+64 21 608919  (mobile)
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sip-router.org/pipermail/sr-dev/attachments/20130730/19972f49/attachment.html>