MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

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.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Synchronisation for multiple write / access to a single database
jupiter hce
November 21, 2017 04:54PM
Re: Synchronisation for multiple write / access to a single database
Peter Brawley
November 21, 2017 06:26PM
Re: Synchronisation for multiple write / access to a single database
Phillip Ward
November 22, 2017 05:46AM
Re: Synchronisation for multiple write / access to a single database
jupiter hce
November 25, 2017 06:26PM


Sorry, you can't reply to this topic. It has been closed.

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.