zlacker

> A non-trivial component to MySQL popularity was that easy installation

...Along with replication and being joined with the hip to PHP. As to installation, there was a point in time in the early 2000s where you could sudo to root, type 'mysql' and be talking to a live MySQL on most Linux distros that I used. No wonder a lot of people defaulted to it.

>>hodges+(OP)
Replication came later - but the fact that you could do

  sudo apt-get install mysql-server mysql-client
  sudo -i mysql

and be logged in as admin into mysql database was indeed a huge reason for defaulting to it.

EDIT: Of course, at that time, there was no Ubuntu teaching everyone to sudo all the time, so drop all instances of sudo and add a su - at start ;)

>>p_l+c3
MySQL has had replication since May 2000.

>>tomnip+T9
Replication being easier as driver for developers defaulting to MySQL

>>p_l+c3
Mysql also came with pretty much any webhost.

>>p_l+c3
> Of course, at that time, there was no Ubuntu teaching everyone to sudo all the time

Maybe that's why I am used to logging in as root rather than a user. I started in 1999 and have been surprised how few users now do

>>porker+KE
Most prod configs I've seen now days disable SSH-ing in as root and password auth so it just becomes:

$ ssh user@server <rsa key> $ sudo -i <user pass> #

>>maskli+DB
That's exactly my point. A lot of people started with dynamic websites by using cheap webhosting that you FTP'ed your PHP files to, and used PhpMyAdmin to manage your smallish database, and 2000-2009 they still formed a strong portion of market for starting out (I chose 2009 because that's when EC2 becomes more accessible for this due to RDS)

>>hodges+(OP)
Yes, replication. MySQL made it dead easy to have DB clusters in minutes.

I'd wish PostgreSQL would have as simple when it comes to replication and failover like MySQL does. It's always a pain when switching masters back and forth.