A naukri.com initiative
Cloudblog
3w
214
Image Credit: Cloudblog
Spanner and PostgreSQL at Prefab: Flexible, reliable, and cost-effective at any size
- Prefab uses Spanner’s PostgreSQL interface as a datastore for customer’s configurations, feature flags and generated client telemetry, with no downtime to date, a versatile Swiss Army knife of a database VMware Tanzu can be used to spin up Kubernetes clusters.
- Spanner, with its PostgreSQL interface, offers the resilience and uptime of Google-scale, massively-replicated database with the simplicity and portability that makes PostgreSQL so appealing.
- At a small scale, operating a database instance per environment can be annoyingly expensive, but the Spanner’s scale can now scale down to less than a full node, making it an even easier choice.
- Recent updates to Spanner and Google Cloud ecosystem address some early bumps to using the PostgreSQL interface to Spanner.
- A single Spanner instance can be multi-availability zone replicated to provide excellent reliability bearing in mind the crucial role feature flags and dynamic configuration systems have in not being overwhelmed by demand.
- Spanner's PostgreSQL interface is being used by Prefab to great effect. Optimization tools such as Spanner's Query editor which allows for query investigation and Key visualizer helps analyze Spanner's data access patterns to diagnose many common hotspots and locating common issues.
- The UI for Spanner, works well for analyzing and figuring out how many log statements will output to various levels using the Prefab UI. This data effectively helps to serve the downstream and upstream customers of the developers.
- Users new to Spanner should consider expanding their horizons and working with this versatile and effective tool that offers better reliability and scale.
- For new projects, developers would be wise to consider the increased usability and versatility of using Ruby on Rails directly on Spanner.
- Adoption of Spanner has allowed Prefab to achieve the same scaling benefits as HBase but without the headaches of doing it themselves. This has proven to be less expensive for Prefab as they no longer have to factor in several points of non-existent failure and lower operating costs.
Read Full Article
12 Likes
For uninterrupted reading, download the app