you are viewing a single comment's thread
view the rest of the comments
[–] 40 points 10 months ago (14 children)

Are there real advantages to using either MySQL or MariaDB instead of PostgreSQL?

  • source
  • hideshow 14 child comments
  • [–] 5 points 10 months ago* (last edited 10 months ago) (4 children)

    Operating and securing Postgres is a steeper learning curve. MariaDB is more forgiving for best-effort shoestring setups without compensating scalability for it.

    As a dev I'm agnostic, as an owner and computer scientiest I prefer Postgres, as a sysadmin or *Ops I will put my hand up for MariaDB any day if I'll be on call or maintain deployments.

  • source
  • parent
  • hideshow 4 child comments
  • [–] 1 point 10 months ago (3 children)

    Is Maria that much better than MySQL?

    Cause that one is absolute shit, very difficult to maintain, and requires lots of config changes and even replicas can disconnect when something's not 100% ok.

    I will take Postgres over any other DB any day of the week.

  • source
  • parent
  • hideshow 3 child comments
  • [–] 1 point 10 months ago (2 children)

    Is Maria that much better than MySQL?

    MariaDB is MySQL's fork, initiated by the main developers, so...

  • source
  • parent
  • hideshow 2 child comments
  • [–] 9 points 10 months ago (2 children)

    Yeah,
    I did a speed test comparison between Oracle MySQL and MariaDB MySQL,
    MariaDB is about 10 times faster.

    FYI: When Oracle bought MySQL a lot of developers left and created MariaDB, so the brains behind the project moved, and in the meantime Oracle did a great job of fucking things up.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 5 points 10 months ago* (1 child)

    MySQL often has moderately higher performance (particularly for workloads where you want your data clustered by PK, which is how InnoDB is natively structured) and its replication system is much more flexible than either of PostgreSQL's. I like Percona personally, but MariaDB is fine too.

  • source
  • parent
  • hideshow 1 child comment
  • [–] 0 points 10 months ago

    Is it true?

    Postgres with correct fillfactor, it doesn't create new pages and works very fast.

    Replication in MySQL always sucked ass, only received synchronous replication in some new edition, and that also didn't sound great.

    Postgres has logstream and logical replication, both of them can be set to various levels of synchronicity, and logical replication is configurable at least as well as MySQL is in terms of which data is sent.

  • source
  • parent