3 ms·

Wow, yeah hello PostgreSQL

by jarin 16y ago

plaes 16y ago
Yeah, and also Drizzle, MariaDB and Percona Server.
- mcs 16y ago
  Drizzle probably is the future of "mysql in the cloud", but it's not quite there yet.
  - rbanffy 16y ago
    It's certainly not worse than Oracle MySQL...
    - mcs 16y ago
      I guess it's mainly this mindset of something must have years of testing or it's not really ACID compliant. Drizzle works fantastic, however there needs to be more drivers written to take advantage of it (and it's asynchronous facilities, especially for the Node.JS people). If you're not familiar with Drizzle, it's MySQL that has a bunch of crap you'll never use stripped out.
      - rbanffy 16y ago
        > something must have years of testing or it's not really ACID compliant Can't really grasp that. Drizzle is MySQL minus cruft... Its parts have been extensively tested for many years.
nodata 16y ago
I think the reason you are being downvoted is that you are comparing PostgreSQL with the commercial version of MySQL. A better comparison would be between EnterpriseDB and the commercial version of MySQL.
- jarin 16y ago
  Ah yes, my mistake.
- Andys 16y ago
  Afaik, the free version of MySQL doesn't let you do a live transaction-safe database dump of InnoDB tables. A pretty basic feature I thought, which is included in the free version of PostgreSQL.
  - nodata 16y ago
    Well you can almost get there (completely if you're not changing schemas): mysqldump --single-transaction This option sends a START TRANSACTION SQL statement to the server before dumping data. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when BEGIN was issued without blocking any applications.
    - mrj 16y ago
      Unfortunately, mysql still doesn't have transactional DDL, I believe...
      - koenigdavidmj 16y ago
        Nor does Oracle, for what it's worth.
  - spudlyo 16y ago
    This is incorrect. You can use XtraBackup for this which is an open source alternative to innodb hot backup. Alternately you can quickly lock tables and take a filesystem snapshot or even run mysqldump with --single-transaction all which will let you get a consistent dump of a set of InnoDB tables.

Wow, yeah hello PostgreSQL

by jarin 16y ago

Wow, yeah hello PostgreSQL

plaes 16y ago

Yeah, and also Drizzle, MariaDB and Percona Server.

mcs 16y ago
Drizzle probably is the future of "mysql in the cloud", but it's not quite there yet.
- rbanffy 16y ago
  It's certainly not worse than Oracle MySQL...
  - mcs 16y ago
    I guess it's mainly this mindset of something must have years of testing or it's not really ACID compliant. Drizzle works fantastic, however there needs to be more drivers written to take advantage of it (and it's asynchronous facilities, especially for the Node.JS people). If you're not familiar with Drizzle, it's MySQL that has a bunch of crap you'll never use stripped out.
    - rbanffy 16y ago
      > something must have years of testing or it's not really ACID compliant Can't really grasp that. Drizzle is MySQL minus cruft... Its parts have been extensively tested for many years.

nodata 16y ago

I think the reason you are being downvoted is that you are comparing PostgreSQL with the commercial version of MySQL. A better comparison would be between EnterpriseDB and the commercial version of MySQL.

jarin 16y ago
Ah yes, my mistake.
Andys 16y ago
Afaik, the free version of MySQL doesn't let you do a live transaction-safe database dump of InnoDB tables. A pretty basic feature I thought, which is included in the free version of PostgreSQL.
- nodata 16y ago
  Well you can almost get there (completely if you're not changing schemas): mysqldump --single-transaction This option sends a START TRANSACTION SQL statement to the server before dumping data. It is useful only with transactional tables such as InnoDB, because then it dumps the consistent state of the database at the time when BEGIN was issued without blocking any applications.
  - mrj 16y ago
    Unfortunately, mysql still doesn't have transactional DDL, I believe...
    - koenigdavidmj 16y ago
      Nor does Oracle, for what it's worth.
- spudlyo 16y ago
  This is incorrect. You can use XtraBackup for this which is an open source alternative to innodb hot backup. Alternately you can quickly lock tables and take a filesystem snapshot or even run mysqldump with --single-transaction all which will let you get a consistent dump of a set of InnoDB tables.