Re:Migrating Facebook to MySQL 8.0
by derekperkins on Thursday July 22, 2021 @09:56PM
(#27926429)
Yeah, Google policy was to migrate everything to Spanner, not a technical decision.
> Are cross-server transactions scalable? Would anyone architect a system that did them en masse unless they absolutely 100% had to?
As a long time Vitess user and contributor/maintainer, this perfectly describes the issue. Minimal effort has been put into solving cross shard / 2PC transactions because a well designed system rarely needs it.
I am just speculating here but I doubt that YouTube migrated to Spanner so that they could do cross-server transactions. I would think consolidating the Ops burden into the GCP org and also serving as a trophy "customer" were higher on the list of reasons. But again, just speculating...