Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8
by wcarron on Wednesday June 21, 2017 @06:46PM
(#14608631)
Yeah, but why would I use that over PostgreSQL? I already know postgreSQL and it's also THE gold standard for SQL implementations. AFAIAC PostgreSQL is the obvious choice.
[ Parent
| on HN ]
Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8
by lawpoop on Wednesday June 21, 2017 @11:39PM
(#14609968)
You would use it over PostgreSQL because it's a drop-in replacement for MySQL. PostgreSQL is not.
If you're not using MySQL in the first place, why would you care?
Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8
by wcarron on Thursday June 22, 2017 @04:07PM
(#14614917)
Because sometimes I DO use MySQL because a client requested it. At this point, I'll probably just explain to clients why pg is a much better alternative.
Re:Sysbench for MySQL 5.0, 5.1, 5.5, 5.6, 5.7 and 8
by lawpoop on Saturday June 24, 2017 @11:44AM
(#14625952)
From a fresh build, I agree with you.
However, for MySQL in an existing application, the migration costs might make it not worth it. There can be a number of pernicious gotchas that aren't obvious at first. MariaDB is more or less set-and-forget.