MySQL Forums
Forum List  »  Newbie

Re: Synchronisation for multiple write / access to a single database
Posted by: Phillip Ward
Date: November 22, 2017 05:46AM

Quote

I suppose that MySql will do the lock to synchronise the multiple writes ...

To an extent, yes.

You don't need to worry about multiple clients issues [reads or] writes at the same time; MySQL will takes care of that for you.

Quote

... and I don't need to worry about conflicts caused by multiple writing processes ...

No. You do need to worry think about using Transactions to control any processes that involve multiple updates, e.g. transferring money from one account to another; these two must happen as a single unit, or not at all.

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: Synchronisation for multiple write / access to a single database
November 22, 2017 05:46AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.