Re: Engine?

Awesome Thank You Guys! A better scalable DB was on my mind, looks like I
might have to go for much before I thought I might have to go ahead with :)

Going through the resources provided, Thank You for the headsup!!

Vinay Kannan.

On Mon, Apr 16, 2012 at 4:44 PM, Matijn Woudt <[email protected]> wrote:

> On Mon, Apr 16, 2012 at 1:09 PM, Bastien <[email protected]> wrote:
> >
> >
> > Bastien Koert
> >
> > On 2012-04-16, at 2:21 AM, Karl DeSaulniers <[email protected]>
> wrote:
> >
> >> 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,
> >
> > InnoDB with replication should get you close to what you need. But it
> sounds like you are also requiring some High Availability architecture so
> you may want to look at fail overs using Heartbeat or some other tool to
> automatically switch over to a new master.
> >
> > Check out the
> http://www.mysql.com/products/enterprise/high_availability.html or google
> 'MySQL high availability'
> >
>
> Or maybe you should look at a other databases than MySQL, there are a
> few that scale much better. Google for scalable database, and you'll
> find some.
>
> - Matijn
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>