Been looking at the database systems
May 19th, 2009 by GregAfter 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.
Posted in My Other Sites, PHP | 8 Comments »
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
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?
Technology changes so fast… have to work on keeping up!
Sounds something like a raid setup to me. I think it’s a good idea. Keep up the good work.
-M
Hi, congrats on the not smoking part.. just keep going.
Colin.
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.
I am really looking forward to your new alternative EC site – hope it’s up and running soon.
sounds good. well done, too many ppl whine and do nothing.
you shd try cmfads, they are good.