Been looking at the database systems
After the problems EC experienced last week, and the odd problems like server timeouts it has continued to experience I have spent some extra time thinking about the database system I plan to use.
Apparently EC use a database that is stored in memory space rather than on the hard drive. I can see that this does improve speed of the database commands, my main concern would be if the server was to crash then all that is stored in memory would be lost.
I have decided to use the same set up that I use with Yzoo/YzooSearch, at its peak it was receiving upto 1 million page views a day, each one requiring at least one database update. It started as will the new site, using a standard mysql database, but as the site grew additional servers where added and used as ‘slave’ databases. 2 of the servers also became master/slave servers so if one dies for whatever reason then no data would be lost and on restarting it automatically updates. This is great as ‘slave’ servers can be added or removed as and when necessary, but it can become expensive.
8 Responses to “Been looking at the database systems”
Comment from Carl
Time May 22, 2009 at 6:22 pm
Not sure if it is just me. We have to use IE 6 at work. Ya. Don’t ask. Somehow, in IE 6, your EC widget does not show up. I use firefox and chrome at home. Your widget shows up in these two browsers no problem. Weird, huh?
Comment from Dwacon
Time May 22, 2009 at 6:39 pm
Technology changes so fast… have to work on keeping up!
Comment from Michele Cameron Drew
Time May 23, 2009 at 4:53 am
Sounds something like a raid setup to me. I think it’s a good idea. Keep up the good work. 
-M
Comment from sexy legs and body
Time May 23, 2009 at 4:56 am
Hi, congrats on the not smoking part.. just keep going.
Colin.
Comment from Blog Angel a.k.a. Joella
Time May 23, 2009 at 11:27 am
Hi I just stopped by to drop on your Entrecard and wanted to let you know that you have been added to Blog Angel’s All Above the Crease Drop List . I created the list because I was sick of wasting time trying to find people’s Ecards. You and everyone on the list has their Entrecards in an easy to find location. Stop by and check it out.
Comment from Chris
Time July 1, 2009 at 12:50 pm
I am really looking forward to your new alternative EC site – hope it’s up and running soon.
Comment from Lu
Time July 8, 2009 at 8:46 am
sounds good. well done, too many ppl whine and do nothing.
you shd try cmfads, they are good.
Comment from Sandy
Time May 20, 2009 at 12:35 pm
Wish I understood some of what you’re talking about, I’m just techy enough too. But, I am keeping an eye on your page to know when there’s an ulternative to EC, as the problems there seem to be more frequent and the frustration level continues with so little communication on their part.
Good luck with your plan and implimentation.
Sandy