MySQL

Open Source Relational Data Base engine. Known for simplicity and speed.

But doesn't support transactions and other "advanced" features. For that you typically use PostgreSQL.

  • but few websites really use/need transactions, and Scalability is pushing people away from those features.

http://www.mysql.com/

Part of the LAMP platform.

Do FederatedTables allow greater scale-out of a schema that uses foreign keys, etc.?

installing on MacOs X

Command Line interface: 'mysql' http://dev.mysql.com/doc/refman/5.1/en/mysql.html

GUI tools http://dev.mysql.com/doc/#guitools

  • Security concerns often keep you from using such things (because you make your db as inaccessible as possible, except from other machines behind that firewall)

batch input/output

  • output/export: "mysqldump" from Command Line

  • import: "source" from inside mysql

date queries: MySQL doesn't have as nice date_trunc and date_part functions as PostgreSQL.

  • you can use date(timestamp) to group by whole-date

  • there's a month() function but that gives you just the month-number, so doesn't work for cross-year queries

    • though I suppose you could break on year() and month()

monitoring tools (recommended by friend May'2011)


Edited:    |       |    Search Twitter for discussion