Re: [PHP-DB] 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 wrote: > On Mon, Apr 16, 2012 at 1:09 PM, Bastien wrote: > > > > > > Bastien Koert > > > > On 2012-04-16, at 2:21 AM, Karl DeSaulniers > 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 etcbut > >>> 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 > >
Re: [PHP-DB] Engine?
On Mon, Apr 16, 2012 at 1:09 PM, Bastien wrote: > > > Bastien Koert > > On 2012-04-16, at 2:21 AM, Karl DeSaulniers 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 etcbut >>> 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
Re: [PHP-DB] Engine?
Bastien Koert On 2012-04-16, at 2:21 AM, Karl DeSaulniers 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 etcbut >> 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' > > Karl DeSaulniers > Design Drumm > http://designdrumm.com > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Engine?
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 etcbut 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
[PHP-DB] Engine?
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 etcbut 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.