You can create instances that run different database engines in ApsaraDB MyBase dedicated clusters. An ApsaraDB MyBase for PostgreSQL instance allows you to have more permissions than those you can have on an ApsaraDB RDS for PostgreSQL instance. This topic provides an overview of ApsaraDB MyBase for PostgreSQL and introduces related concepts.

ApsaraDB MyBase for PostgreSQL

ApsaraDB MyBase for PostgreSQL fully complies with SQL coding specifications and supports a variety of data types, such as JSON, IP, and geometry data types. ApsaraDB MyBase for PostgreSQL supports transactions, subqueries, multi-version concurrency control (MVCC), and integrity checks for data. ApsaraDB MyBase for PostgreSQL also provides key features such as high availability and backup and restoration. These features help simplify O&M. ApsaraDB MyBase for PostgreSQL also provides the following advanced features:
  • ApsaraDB MyBase dedicated clusters: An ApsaraDB MyBase dedicated cluster consists of multiple hosts, such as ECS instances of the ecs.i2.xlarge instance type and ECS Bare Metal instances. You can run instances on these hosts. For more information, see What is ApsaraDB MyBase?
  • You can upload encrypted data from the user end to your ApsaraDB MyBase for PostgreSQL instance. The database instance protects your data against internal and external security threats and allows only authorized users to access the data.
  • Read-only ApsaraDB MyBase instances: If the primary ApsaraDB MyBase instance is overwhelmed by a large number of read requests, your workloads may be interrupted. In this situation, you can create one or more read-only instances to offload read requests from the primary instance. By creating one or more read-only instances, you can scale up the read capability of your database system and increase the throughput of your application.

Benefits of the engine of ApsaraDB MyBase for PostgreSQL

ApsaraDB MyBase for PostgreSQL is suitable for scenarios in which enterprises execute complex SQL statements for online transaction processing (OLTP). ApsaraDB MyBase for PostgreSQL supports NoSQL data types, such as JSON, XML, and hstore. ApsaraDB MyBase for PostgreSQL also provides the multi-model spatio-temporal engine Ganos that is developed by Alibaba Cloud and supports the geographic information engine PostGIS. The engine of ApsaraDB MyBase for PostgreSQL has the following benefits:
  • Compatible with NoSQL: The engine of ApsaraDB MyBase for PostgreSQL is compatible with SQL 2011 and supports a variety of data types. You can execute SQL statements to manage JSON and XML data.
  • Support for multiple versions: PostgreSQL 10, 11, 12, and 13 are supported.
  • Support for a spatial or spatio-temporal engine: The spatio-temporal engine Ganos that is developed by Alibaba Cloud provides capabilities for multi-model processing and accelerates GPU computing. The engine of ApsaraDB MyBase for PostgreSQL is compatible with the geographic information engine PostGIS.