MySQL Forums
Forum List  »  Synchronization

Update Database on Hourly Basis
Posted by: Nitin Deopura
Date: May 17, 2012 08:02AM

Hello,

I have as server serving 40 Production Database. All these database are SELECT only to the Customer and hence i have used MyISAM db engine. Now i have to update All these database on Hourly Basis with new data Set. Since these database are production and consumers are access these database, while loading the dump to the existing db, it locks up all the select queries to that db.? Is there any way that i can update the database without affecting the current customer on the site.

Regards,
Nitin

Options: ReplyQuote


Subject
Views
Written By
Posted
Update Database on Hourly Basis
4173
May 17, 2012 08:02AM


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.