detroit_dan's picture

Re: Linuxjournal.com Down: Incident Report

On December 20th, 2001 detroit_dan (not verified) says:

Less important in a write-few-read-many application

such as ours. This trait is shared with lots of other web

apps.

That's one reason, I believe, why MySQL maintains its strong presence on the web, in the face of PostgreSQL's finer-grained locking, transaction support, subqueries, triggers, scripting

languages, and other features not found at present in MySQL.

I'm aware that MySQL offers transaction support when you

use BDB tables, and I believe that the upcoming (??) new

version offers subqueries. An improvement I applaud. No doubt other features will be introduced with time.

While we're interested in PostgreSQL (indeed, I use it at home)

this application is based on MySQL, and we don't mean to

reconsider that decision unless we find reason to believe MySQL

is our problem. We have not found this.

--

Dan Wilder

Reply

Please note that comments may not appear immediately, so there is no need to repost your comment.
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <pre> <ul> <ol> <li> <dl> <dt> <dd> <i> <b>
  • Lines and paragraphs break automatically.

More information about formatting options

Newsletter

Each week Linux Journal editors will tell you what's hot in the world of Linux. You will receive late breaking news, technical tips and tricks, and links to in-depth stories featured on www.linuxjournal.com.
Sign up for our Email Newsletter

Featured Videos

Set up a secure virtual host in Apache

December 22nd, 2008 by Elliot Isaacson in

Setting up an https server in Apache is easy. This tutorial covers how to create and sign your ssl certificate as well as how to configure the web server.

See more Linux Journal Videos

From the Magazine

January 2009, #177

It's a battle as old as time: good vs. evil. Fortunately, Linux and FOSS are on our side as we wage the battle against those who try to steal our secrets and invade our systems.

Checking your system's security is best done sooner rather than later. Test the locks with our article on security verification; find out how to use PAM to help secure your systems; use MinorFS and AppArmor to implement discretionary access control; learn more about Samba security in part III of our series; use Darknet to help detect bots and secure your systems; use the Yubikey to increase your site's security; and don't forget to lock the doors, because a cold boot attack could render your security useless if somebody has physical access to your computer.

But, we're not just about sowing the seeds of fear. We also show you how to use memcached in Rails, how to manage multiple servers efficiently, how to deploy applications easily with Capistrano, how to manage your videos with MythVideo, how to mix it up a bit (your audio that is), and even play a few games.

Read this issue