You can create instances that run different database engines in ApsaraDB for MyBase dedicated clusters. A 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 MyBase for PostgreSQL and introduces related concepts.

MyBase for PostgreSQL

MyBase for PostgreSQL fully complies with SQL coding specifications and supports a variety of data types, such as JSON, IP, and geometry data types. MyBase for PostgreSQL supports transactions, subqueries, multi-version concurrency control (MVCC), and integrity checks for data. MyBase for PostgreSQL also provides key features such as high availability and backup and restoration. These features help simplify O&M. MyBase for PostgreSQL also provides the following advanced features:
  • ApsaraDB for MyBase dedicated clusters: An ApsaraDB for 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 for MyBase?
  • You can upload encrypted data from the user end to your 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. For more information, see Overview.
  • Read-only RDS instances: If the primary RDS 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 RDS instances to offload read requests from the primary RDS instance. For more information, see Create a read-only ApsaraDB RDS for PostgreSQL instance. By creating one or more read-only RDS instances, you can scale up the read capability of your database system and increase the throughput of your application.

Benefits of the engine of MyBase for PostgreSQL

MyBase for PostgreSQL is suitable for scenarios in which enterprises execute complex SQL statements for online transaction processing (OLTP). MyBase for PostgreSQL supports NoSQL data types, such as JSON, XML, and hstore. 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 MyBase for PostgreSQL has the following benefits:
  • Compatible with NoSQL: The engine of 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 MyBase for PostgreSQL is compatible with the geographic information engine PostGIS.