On Apr 15, 2012, at 9:29 PM, Vinay Kannan wrote:
I've always been left wondering what Engine to use while creating
I've read quite a few times about the same on wiki, articles
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
and data intensive, we are looking at about 1,00,000 registration
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,
crash recovery or auto backups etc...
Basically, if the MySQL DB crashes, we sholdnt be at a loss, and all
data till the very last operation should be available as a backup. Any
headsup on this please?
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.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php