Out of curiosity, was using PowerDNS with CloudSQL (fed from a spanner stream) considered?
There are always trade offs of course but it would have the advantage of DNS spikes not impacting spanner.
We run PowerDNS with MariaDB replication on the backend
Zero problems for last 15 years. Near-instant propagation.
Scaling options are great, as the amount of changes in records per second is generally small even if you have hundreds of domains
I'll admit that we haven't looked at using a Spanner stream with PowerDNS. We did try Spanner and their stale reads feature: https://docs.cloud.google.com/spanner/docs/samples/spanner-r..., however the records were not available instantly after our API said the basin was created. Will investigate.