Opps... Let's keep this on the list. On Fri, Apr 1, 2011 at 9:06 AM, Chris Nighswonger < cnighswonger@foundations.edu> wrote:
On Fri, Apr 1, 2011 at 8:37 AM, Archives and Collections Society < paul.a@aandc.org> wrote:
At 11:41 AM 4/1/2011 +0700, hansbkk@gmail.com wrote:
Or is there some Koha-specific way of handling this?
Not to my knowledge (Chris?) - but in general for other mysql usage (e.g. our accounting system) there has been no problem for the 12 years I've been running the system. Philosophically, most Koha writes as far as I can see will be from Java scripts processed by perl, and my experience tells me that these are "near instantaneous" so while your example of table A and table B is a possibility, pure corruption is unlikely. And ... any backup is better than none.
If you're really concerned in this regard you could implement some sort of WAL archiving which should allow you to roll back incomplete transactions if I understand it correctly.
Kind Regards, Chris