Pinecone’s vectors database that is is powered by Spanner’s well-known PostgreSQL
Pinecone provides a fully managed, scalable, and user-friendly vector search engine with one of the top vector databases. Her vector database powers several apps and is used by a diverse clientele that includes Fortune 500 firms and startups. They moved Pinecone’s fundamental database engine to Spanner recently; here is her experience.
Why would Spanner do this?
With tens of thousands of active users at any one moment, her free-tier offering depends on a highly scalable, multitenant design that lowers storage costs without compromising user experience. Pointers and manifests holding a uniform view of the index make up each index’s data plane metadata. Since the metadata is accessed via the crucial read route,he had to store it in a highly accessible database that offered low-latency point reads. More precisely, thought that Spanners read replicas and its millisecond read latencies in the single digits could guarantee that would consistently have low latency in the crucial route for search queries.
Additionally, a transactionally-sense SQL database that could grow in any dimension was what were searching for. In addition to present multi-tenant workloads, They required this to enable unannounced future services in the rapidly advancing AI sector. Along with having very high durability and effective read/write speed, it also required to be free from the operational overhead of failover, scalability, and sharding management. Any database They selected had to be able to manage the three orders of magnitude scaling that anticipated being necessary for Pinecone’s free tier over the next year, all the while being reasonably priced.
Spanner fulfills every one of these requirements. In addition to offering great availability and endurance, it is also highly scalable and reasonably priced. Moreover, Spanner’s PostgreSQL interface is portable and comfortable. Spanner’s recently achieved significant price-performance improvements, which sweetened the pot for us. They now provide no-change pricing, up to 50% more throughput, 2.5 times more storage per node, and reduced latency.
In order to sum up, Google Cloud has proved to be a fantastic collaborator. They are constantly traveling up with fresh concepts and displays to make it simple for business to establish and operate her company. he can’t wait to see where his collaboration goes in the future.
Methodology of migration
Prior to using Spanner, already had a free tier offering, so he had to carefully manage the migration to make sure he gave users the best experience possible while gaining confidence in using Spanner at a larger scale in production.
They created feature flagging to direct a small percentage of signups to the new tier after creating, testing, and benchmarking the new free-tier architecture using Spanner PostgreSQL. Then, in order to guarantee a favorable user experience and predicted cost-of-goods-sold (COGS), They devoted weeks to scrutinizing key performance indicators (KPIs).
As a result of gradual increase in traffic, the new Spanner-based multitenant architecture is now automatically used by all newly registered free tier customers.
Her expenditures to maintain the free tier have decreased by ten times, and now have close to 40,000 customers using this architecture in production. The general user experience has also improved.
An excellent illustration of how to create and manage creative and crucial workloads using Spanner is the Pinecone-Spanner use case.
They are able to greatly expand the free trials that will provide to clients on Google Cloud because of Spanner’s scalability, dependability, and performance. Her platform would be much enhanced by Spanner’s capacity to manage substantial amounts of data and transactions.