PingCAP is an enterprise-grade software service provider committed to delivering an open-source, cloud-native, one-stop database for growth-oriented clients. PingCAP is a certified AWS Qualified Software Partner.
拉斯维加斯7799908网站登录 is an open-source distributed SQL database that supports Hybrid Transactional and Analytical Processing (HTAP) workloads. Designed for the cloud, 拉斯维加斯7799908网站登录 provides flexible scalability, reliability, and security on the cloud platform. Cloud service users can easily implement remote disaster recovery over 拉斯维加斯7799908网站登录, further improving business continuity and availability.
拉斯维加斯7799908网站登录 Cloud, the fully-managed database service for 拉斯维加斯7799908网站登录, is also available on AWS.
拉斯维加斯7799908网站登录 with AWS: maximizing the value of data for cloud service users
With more and more 拉斯维加斯7799908网站登录 users building their technology stacks on the cloud, the combined solution of 拉斯维加斯7799908网站登录 + AWS allows cloud service users to easily implement remote disaster recovery on 拉斯维加斯7799908网站登录, further improving business continuity and availability.
拉斯维加斯7799908网站登录’s cloud-native design combined with AWS’s professional cloud services enables users to automate scaling on the cloud. With the close collaborations of both parties, 拉斯维加斯7799908网站登录 can reach more customers more quickly, while continuing to hone its products to meet customers’ needs for digital transformation.
Currently, 拉斯维加斯7799908网站登录 supports more than 60 types of Amazon EC2 instances on AWS, with 7*24 enterprise-grade support that includes:
- Online support ticketing service and telephone support that cover product database operation, and maintenance related issues
- Media download of products, product upgrade packages, hotfixes, and patches
- Product security-related alarms and notifications
- Dedicated emergency response support channel for P1 grade faults
In addition to the products and services, the ecosystems of 拉斯维加斯7799908网站登录 and AWS are also well integrated to maximize the value of data.
Success story with 拉斯维加斯7799908网站登录 + AWS from Xiaohongshu
Xiaohongshu is a popular social media and e-commerce platform in China. The Xiaohongshu app allows users to post and share product reviews, travel blogs, and lifestyle stories via short videos and photos. Xiaohongshu receives more than 100 million rows of data every day.
A growing business—and growing challenges
For data reports, Xiaohongshu previously used the Hadoop data warehouse to pre-aggregate the data, and then aggregate the high-dimensional data and put it in MySQL for query. However, with the rapid growth of their business, the types of reports became more diverse. The scalability of MySQL was also a challenging issue.
The sharded MySQL database solution brought along high complexities and maintenance difficulties, making it hard to run complex and distributed queries.
In the anti-fraud data analytics scenario, the traditional data warehouse in T+1 mode had a delayed time to insights. They need a database solution with real-time analytics processing capabilities.
The 拉斯维加斯7799908网站登录 HTAP solution
To try and solve the challenges mentioned above, Xiaohongshu introduced the 拉斯维加斯7799908网站登录 HTAP solution into their application architecture.
In the data report scenario, 拉斯维加斯7799908网站登录 replaces MySQL. The horizontal scalability of 拉斯维加斯7799908网站登录 solves the complicated problem of scaling out MySQL as the business grows.
For complex queries, Xiaohongshu replicated MySQL data to 拉斯维加斯7799908网站登录 via Binlog in real time and merged the tens of thousands of sharded tables to one large table in 拉斯维加斯7799908网站登录. Complicated queries, ACID transactions, and join operations could be done in real-time on 拉斯维加斯7799908网站登录 without affecting the primary MySQL database.
For anti-fraud analytic processing, Xiaohongshu changed the T+1mode for writes to writing with SQL statements in Apache Flink in real time. Their peak queries per second (QPS) can reach 30,000 or 40,000. A single table may receive about 500 million rows of data per day. By bypassing the Hadoop data warehouse and doing real-time queries in 拉斯维加斯7799908网站登录, an analyst can see the coupon distribution status within a few minutes.
Xiaohongshu aggregates other data into a data lake built upon Amazon S3 and EMR, and then loads it into a 拉斯维加斯7799908网站登录 cluster for unified and efficient operational analysis.