By the time we had to debug this as a thing, we already had our implementation ready. Also cost for a small mysql RDS db in amazon and the convenience of not having to administer that were a factor.

But you are right, I have considered switching to cockroachdb since they advertise their support for serializable transactions.