Re: Engine?
Karl DeSaulniers <[email protected]>
| Newsgroups | gmane.comp.php.database |
|---|---|
| Message-ID | <[email protected]> |
On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote: > Hello, > > I've always been left wondering what Engine to use while creating > tables, > I've read quite a few times about the same on wiki, articles > etc....but > haven't actually been able to decide. > I wanted to know whats the storage engine used on MySQL on big web > application, the application i am developing currently, is kinda > really big > and data intensive, we are looking at about 1,00,000 registration > atleast > in the first few months, and their data lets say, each will have about > 10-20 operations, accounts etc... So the data can get really big and > troublesome to maintain, I am more concerned about the data safety, > as in > crash recovery or auto backups etc... > Basically, if the MySQL DB crashes, we sholdnt be at a loss, and all > the > data till the very last operation should be available as a backup. Any > headsup on this please? > > > Thanks, > Vinay Kannan. Maybe google MySQL innodb. I think they have rollback and table locking. As well as foreign key capabilities. Limited exp. Sorry not much more help. Best, Karl DeSaulniers Design Drumm http://designdrumm.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php