News for hackers. Stuff that matters.

A comment on MySQL now shows its thread names at OS level for better troubleshooting. Parent comment

Re:MySQL now shows its thread names at OS level for better t... by DeathArrow on Friday March 18, 2022 @02:20AM (#30719192)
>I did pick MySQL over Postgres for a old project that I'm currently working on again, the primary reason was easy multi-master replication via galera.

I plan to use CockroachDB as a distributed data store since it's protocol compatible with Postgres. Still in testing phase, but the deployment is very easy.

[ Parent | on HN ]
Re:MySQL now shows its thread names at OS level for better t... by linsomniac on Friday March 18, 2022 @09:11AM (#30721741)
Agreed, the deployment was very easy, that was one of the reasons I wanted to switch to Cockroach from MySQL+Galera. It took me less than a day to get ansible roles to set up a Cockroach cluster, but around a week for the MySQL Galera cluster, to get it completely right. And that was starting with somebody else's Maria+Galera Ansible role.

My blocker was that I'm using it in part for Postfix maps, and the Postfix pgsql module can't be configured to us anything but LATIN-1 encoding, and Cockroach only supports UTF-8.

[ Parent | on HN ]