#cloudspanner — Public Fediverse posts

PostgreSQL→Cloud Spanner 240テーブル移行：LLMによるテーブル分類とダウンタイム約60%削減の実践
https://qiita.com/kane_ryu/items/38911988915c6bbd8c8d?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #Bash #PostgreSQL #CloudSpanner #GoogleCloud #LLM

Dataflow × Spanner データ移行を完遂する実戦ガイド — IAM 2ロール・パス不一致・DDL完了待ちの3チェック
https://qiita.com/kane_ryu/items/7d8d6f388849f1593658?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #IAM #DataStream #dataflow #CloudSpanner #GoogleCloud

PostgreSQL→Cloud Spanner大規模移行トラブル詳解 — 18時間ずれの解消と240テーブルPDML補正、Dataflow高速化の実戦
https://qiita.com/kane_ryu/items/c96e6f0ab2b2dbab6ad8?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #migration #PostgreSQL #dataflow #CloudSpanner #PDML

Okay this is another cool one: Now you can move your #CloudSpanner instance with zero downtime.

Application moved and need data to move? No problem! Expanding to global regions and need to shift from single to multi-region? No problem!

https://cloud.google.com/spanner/docs/move-instance

Okay this is another cool one: Now you can move your #CloudSpanner instance with zero downtime.

Application moved and need data to move? No problem! Expanding to global regions and need to shift from single to multi-region? No problem!

https://cloud.google.com/spanner/docs/move-instance

OOoooooh nice. #CloudSpanner implemented RETURNING (THEN RETURN is the actual directive in gSQL)!

I have to say, RETURNING is one of the reasons I <3 #Postgres more than #MySQL. Awesome to see it in Spanner.

OOoooooh nice. #CloudSpanner implemented RETURNING (THEN RETURN is the actual directive in gSQL)!

I have to say, RETURNING is one of the reasons I <3 #Postgres more than #MySQL. Awesome to see it in Spanner.

The #CloudSpanner paper “Spanner: Google’s Globally-Distributed Database" received the 2022 SIGOPS Hall of Fame Award. While that in and of itself is pretty cool, what's more cool?

Hearing from Chris Taylor, one of the original authors of the paper, about the context and inspiration behind Spanner. ↓

https://cloud.google.com/blog/products/databases/reflecting-on-spanner-papers-sigops-hall-of-fame-award

#GoogleCloud

The #CloudSpanner paper “Spanner: Google’s Globally-Distributed Database" received the 2022 SIGOPS Hall of Fame Award. While that in and of itself is pretty cool, what's more cool?

Hearing from Chris Taylor, one of the original authors of the paper, about the context and inspiration behind Spanner. ↓

https://cloud.google.com/blog/products/databases/reflecting-on-spanner-papers-sigops-hall-of-fame-award

#GoogleCloud

@garystafford scaled writes is a harder problem to solve of course. If the app has heavy writes as well I’d look to something like #CloudSpanner.

@garystafford scaled writes is a harder problem to solve of course. If the app has heavy writes as well I’d look to something like #CloudSpanner.

Does anyone know if #mastodon works with a more scalable #postgres compatible database like #gcp #CloudSpanner and similar? Just curious. That would probably be what I would do to scale a massive Mastodon instance dramatically.