<div>Thanks Earnie Boyd </div>
<div>Thanks a lot for kind reply.</div>
<div> </div>
<div>In my custom modules, I do normal queries like INSERT/UPDATE/SELECT etc.</div>
<div>So my understanding is that, if at a time multiple users try to insert/update data in same mysql (innodb) table, still data is safe (no data corruption).</div>
<div> </div>
<div>Probably if anybody has better suggestions, kindly share.</div>
<div> </div>
<div>Thanks</div>
<div>Kamal</div>
<div> </div>
<div><br><br> </div>
<div class="gmail_quote">On Mon, Aug 27, 2012 at 5:54 PM, Earnie Boyd <span dir="ltr"><<a href="mailto:earnie@users.sourceforge.net" target="_blank">earnie@users.sourceforge.net</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT:#ccc 1px solid;MARGIN:0px 0px 0px 0.8ex;PADDING-LEFT:1ex" class="gmail_quote">
<div class="im">On Mon, Aug 27, 2012 at 7:48 AM, Kamal Palei wrote:<br>> Hi All<br>> I am using Drupal 6.26, MySQL (InnoDB).<br>><br>> There are few mysql tables, that may be accessed by multiple users at<br>
> sametime.<br>> Do I need to do anything extra to make sure mysql table data would not be<br>> corrupted.<br>><br><br></div>Not that I'm aware of. I've used InnoDB on 6.x successfully and on D7<br>it is the default.<br>
<div class="im"><br>> I read somewhere, I need to install transaction module to safeguard data.<br><br></div>Only if you plan to develop transaction based activity in a module.<br>
<div class="im"><br>> Can somebody advise me is it really required?<br><br></div>One of the best features of transactions is that you commit a set of<br>changes but tell write the changes out normally which are cached<br>
waiting a commit. If the commit never occurs then the changes are<br>never written. So if one of the changes aborts all the other changes<br>also abort. Drupal 6 doesn't make use of this so you do not need to<br>do anything special. Drupal 7 does make some use of transactions but<br>
still you don't need to do anything special.<br><span class="HOEnZb"><font color="#888888"><br>--<br>Earnie<br>-- <a href="https://sites.google.com/site/earnieboyd" target="_blank">https://sites.google.com/site/earnieboyd</a><br>
--<br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></font></span></blockquote></div><br>