Shulou(Shulou.com)05/31 Report--

This article introduces you to the distributed database PolonDB cloud power future data processing requirements, the content is very detailed, interested partners can refer to, I hope to help you.

With the deepening of enterprise digital transformation, traditional IT architecture and database have long been unable to adapt to the needs of industries such as Internet of Things, new finance, new retail, new manufacturing, etc. for high throughput and flexible expansion of data, and enterprises have higher requirements for databases.

PolonDB distributed database launched by Qingyun QingCloud this time is a distributed relational database based on Citus and compatible with PostgreSQL ecosystem. It also supports online transaction processing ( OLTP ) and online analytical processing ( OLAP ) scenarios. It is suitable for real-time analysis of mass data, mass transaction processing and other application scenarios. It is an ideal choice for future data processing.

As an extension of PostgreSQL, Citus open source database adopts shared nothing architecture, and there is no shared data between nodes. A database cluster is composed of coordinator nodes and Work nodes.

Compared to standalone PostgreSQL, Citus can use more CPU cores and memory, and store more data. Citus also supports unlimited horizontal scaling, making it easy to scale databases by adding nodes to a cluster.

PolonDB Features and Features

1. Seamless compatibility with PostgreSQL ecosystem

Seamless compatibility with the PostgreSQL ecosystem, instant access to the latest PostgreSQL features and performance improvements, no code and application modifications required.

2. Ultra high performance

Database concurrent connections can reach nearly one million;TPC-B performance test QPM (queries per minute) can easily achieve millions; high-availability standby machines in clusters can double query performance; 200 connections can reach 7 million; additional configuration can easily exceed ten million. (For detailed test data, click to read the original text, refer to TPC-B test data)

3. Smooth expansion

Online vertical/horizontal expansion without interruption of business without shutdown, performance increases linearly with node expansion, easily meets performance challenges brought by ultra-high concurrent requests, and supports rapid business growth.

4. High availability

Two-phase commit is used to handle distributed transactions, and when the cluster is running normally, it runs in synchronous mode. When an exception occurs, it automatically switches to asynchronous mode.

5. Consistency of data

Adopt asynchronous high performance transaction processing model to ensure data correctness.

6. Support HTAP mixed mode

It also supports OLTP and OLAP scenarios, helping users to support online transactions and data analysis based on a single system, greatly saving storage costs, improving business efficiency, and providing efficient processing capabilities for real-time online analysis, recommendation, search, and other business scenarios.

PolonDB application scenarios

Support HTAP service system

in database system application, OLTP scenario involve small amount of data but high requirement for real-time return, OLAP scenario involves large amount of data and calculation but low requirement for real-time return.

PolonDB can support both OLTP and OLAP scenarios, helping users to host online transactions and data analysis businesses simultaneously based on a single system, greatly saving storage costs and improving business decision-making efficiency.

massive data storage

With the explosive growth of data, enterprises often encounter very large data set storage requirements, which used to exist in a stand-alone PostgreSQL database, and query performance could not meet the demand.

PolonDB has unlimited horizontal scalability, and its performance increases linearly with capacity expansion. It can expand clusters on demand to ensure that clusters can support petabytes of storage.

Real-time high concurrency transaction system

With the vigorous development of Internet, mobile Internet, e-commerce and other businesses, the number of customers continues to grow, and the core business system needs to withstand the test of high concurrent access.

PolonDB's share-nothing architecture can smoothly scale instances online to cope with such scenarios; at the same time, PolonDB provides distributed transaction consistency capabilities to ensure distributed system transaction consistency in high-concurrency scenarios.

About the distributed database PolonDB cloud power future data processing needs are shared here, I hope the above content can be of some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.