How can read and write operations be separated in a simple and efficient manner?
Hello and welcome to another episode of Cloud Forward.
Today, we’ll discuss read and write splitting.
In industries such as e-commerce, the need for more reads and fewer writes places enormous pressure on the database's read capacity, which may eventually affect the business.
We would naturally think of read and write splitting to solve this issue.
Conceptually, it is straightforward, but the real question is how?
What if we use a single cluster address as a proxy to re-route read and write requests?
The concept evolved into the PolarProxy; it's transparent, highly available, and has an adaptive load balancing capability.
Through PolarProxy, SQL requests are automatically forwarded to each node of the PolarDB cluster, providing high-performance, high-throughput, concurrent SQL processing capabilities.
So, applications only need to connect to one single cluster address, and write requests are automatically routed to the primary node, while read requests are routed to the primary or read-only nodes, based on the loads on each node.
Watch the full video here to learn more about PolarDB >>
Cloud Forward Episode 6: Cloud-Native Database - PolarDB | Strict Consistency Cluster
Analyze the Technical Essentials of PolarDB at the Architecture Level
ApsaraDB - December 5, 2018
ApsaraDB - August 9, 2022
ApsaraDB - August 9, 2022
ApsaraDB - August 9, 2022
ApsaraDB - August 10, 2022
Alibaba Clouder - January 8, 2021
PolarDB is a cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle.
Learn MoreDesigned to address database challenges such as ultra-high concurrency, massive data storage, and large table performance bottlenecks.
Learn MoreLeverage cloud-native database solutions dedicated for FinTech.
Learn MoreLindorm is an elastic cloud-native database service that supports multiple data models. It is capable of processing various types of data and is compatible with multiple database engine, such as Apache HBase®, Apache Cassandra®, and OpenTSDB.
Learn MoreMore Posts by ApsaraDB