mes Posted January 12, 2005 Posted January 12, 2005 I have 2 copies of exactly the same osc store running on 2 servers, and both are linked to the same database located on one of the servers! Am i asking for trouble and will this f**k up? or will it work ok? Cheers Guys Help Appreciated mes
mes Posted January 12, 2005 Author Posted January 12, 2005 Just wondering 2 people accessing same data of 2 different sites, or same person logged in at 2 sites etc could cause a prob. thanks though Chemo.. mes
Guest Posted January 12, 2005 Posted January 12, 2005 If you're using the same database there are automatic locks or delayed inserts to address data corruption. However, if you are really concerned I would change the table type to INNODB which has a per row lock instead of a whole table lock. This will help ensure there is no data corruption... Bobby
mes Posted January 13, 2005 Author Posted January 13, 2005 Chemo i really dont know that much about databases, are the automatic locks or delayed inserts already running in the database or do you have to install them? And how do you change the table type? Im using phpmyadmin Thanks, mes
Guest Posted January 13, 2005 Posted January 13, 2005 They are already running...no need to change anything to take advantage of them. To change the table type in phpMyAdmin select the table and at the top select "Operations". Down at the bottom there is an option for table type which is most likely MyISAM. Change it to "INNO DB". You'll have to do this for each table or create a script to do it all at once. Bobby
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.