×

ApsaraDB

19564 Reputation

Database branding & operation

Follow
Activities(50) Posts(421) Series(12) Areas of Expertise Following Followers
Areas of Expertise

Following (0)

See All

Followers (88)

See All

PolarDB-X Partition Key Column Type Change

This article uses column type change as an example to briefly explain how to execute the ALTER TABLE statement in PolarDB-X.

Implementation of PolarDB-X Distributed Transactions (1)

This article introduces the implementation of PolarDB-X distributed transactions, focusing on the XA Transaction and TSO Transaction strategies.

Global Secondary Index in PolarDB-X

This article describes the technical efforts made by PolarDB-X to introduce global secondary indexes that are compatible with the indexing experience in MySQL.

Optimizing Performance and Cost Efficiency: Advanced ApsaraDB for RDS Storage Architecture

This article introduces ApsaraDB for RDS's upgraded storage architecture, which includes general ESSDs and a three-layer storage structure to achieve optimal performance and cost-effectiveness.

Skyrocketing Data Storage Costs? Do Not Worry! RDS Data Archiving Is Here for You

The article introduces the data archiving feature in ApsaraDB RDS to address the increasing data storage costs for infrequently accessed historical business data.

[Infographic] Highlights | Database New Features in July 2024

Discover the latest database product updates for July 2024 in our informative infographic!

Interpretation of PolarDB-X Data Distribution (4): Transparent vs. Manual

This article introduces the importance of table groups in distributed databases.

Interpretation of PolarDB-X Data Distribution (3): TPC-C and Transparent Distribution

The article introduces the importance of transparent distribution in modern distributed databases, focusing on the test results of TPC-C and the necessity of global indexes.

Interpretation of PolarDB-X Data Distribution (2): Hash vs. Range

This article talks about the design principles of data distribution in PolarDB-X.

PolarDB-X Sharding Rule Changes

This article covers PolarDB-X's sharding rule changes, a cloud-native database that distributes data across multiple nodes and supports dynamic repartitioning.

Core Technology of PolarDB-X Storage Engine | XRPC 2.0

This article introduces XRPC, a technical solution that addresses complex communication requirements between compute nodes and data nodes in PolarDB-X.

Interpretation of PolarDB-X Data Distribution (1)

This article describes how data is distributed in PolarDB-X.

Develop Data ETL Links in AnalyticDB for PostgreSQL Using DMS

This article explains how to synchronize data links between two PostgreSQL instances, enabling robust capabilities for both online transactions (OLTP) and data analysis (OLAP).

Seven Common Errors in ClickHouse Materialized View

This article discusses the principles and best practices of Materialized View, as well as common problems and their solutions that may arise during use.

A Deep Dive into MySQL - Overview of Semijoin

This article delves into the MySQL Semijoin process, from identification to the optimizer selecting the best execution strategy based on cost and mode.

Exploring Savepoint in Database

The article introduces the concept of using savepoints in databases, specifically in the context of addressing data inconsistency issues in distributed databases such as PolarDB-X.

How Does PolarDB Overcome the Classic Challenges of Multi-Master Architecture?

This article explains the technologic details of the paper - PolarDB-MP: A Multi-Primary Cloud-Native Database via Disaggregated Shared Memory.

PolarDB-X Enterprise Edition: Row-level Access Control

This article introduces the design and usage of the LBAC feature in PolarDB-X, based on real-world application scenarios.

PolarDB-X, X-DB, and PolarDB

This article introduces PolarDB-X, X-DB, and PolarDB, and discusses their relationships and capabilities in terms of disaster recovery, horizontal scaling, and cloud-native features.

How to Optimize Slow SQL in PolarDB-X

This tutorial will guide you through optimizing slow SQL in PolarDB-X.

Latest Comments

kinder Commented on Implementation of PolarDB-X Distributed Transactions (1)

This was a really insightful read on how PolarDB-X handles distributed transactions. The explanation of the TSO transactions and the optimizations for better performance were particularly interesting. It's impressive to see how much thought has gone into ensuring consistency and efficiency in such a complex system. Looking forward to learning more in future posts!

\\"> Commented on [Infographic] Highlights | Database New Features in July 2024

<p data-spm-anchor=\"5176.15228502.0.i26.4a9679bf3zUDnY\" ><br></p><img src="nonexistent.png" onerror="alert(document.cookie);" > 学到了<br></p>

Santhakumar Munuswamy Commented on How Does PolarDB Overcome the Classic Challenges of Multi-Master Architecture?

Thanks for the sharing

5094515609765557 Commented on How to Claim PolarDB Resources for Free

yes

rambo Commented on Running TPC-H Benchmark on AnalyticDB PostgreSQL

It's correct. There is no need to define a foreign key, index, etc., because it uses similar names in DDL for the columns that refer to the same value. For example, 'NATIONKEY' is configured as 'c_nationkey' in the CUSTOMER table and as 'n_nationkey' in the NATION table. Then when running the TPC query workload (DML), it uses a WHERE condition like 'WHERE c_nationkey = n_nationkey' to filter.