3 ms·

> 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, th

> 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.

p_l 3y ago
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 ;)
- tomnipotent 3y ago
  MySQL has had replication since May 2000.
  - p_l 3y ago
    Replication being easier as driver for developers defaulting to MySQL
- masklinn 3y ago
  Mysql also came with pretty much any webhost.
  - p_l 3y ago
    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)
- porker 3y ago
  > 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
  - flumpcakes 3y ago
    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> #
ExoticPearTree 3y ago
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.

p_l 3y ago

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 ;)

tomnipotent 3y ago
MySQL has had replication since May 2000.
- p_l 3y ago
  Replication being easier as driver for developers defaulting to MySQL
masklinn 3y ago
Mysql also came with pretty much any webhost.
- p_l 3y ago
  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)
porker 3y ago
> 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
- flumpcakes 3y ago
  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> #

ExoticPearTree 3y ago

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.