This blog is a continuation of Part 1 of the article series on the benefits of combining ApsaraDB for PostgreSQL and ApsaraDB for MySQL.
As mentioned earlier, we have an edition of ApsaraDB for PostgreSQL with full-coverage encryption, which is a special edition. This edition is also produced in cooperation with Alibaba DAMO Academy. This edition protects networks, databases, operating systems, storage, and data centers against attacks, data leakage by database applications, data leakage on cloud platforms, and data leakage by cloud platform administrators.
The fifth feature is a vertical spatio-temporal feature. Spatio-temporal scenarios include the planar geometric model, spherical geometric model, raster model, spatio-temporal trajectory model, point cloud model, and topological network model. Our geographic information system (GIS) module supports all of these models.
In addition, our GIS module has wide application scenarios, including the Internet of vehicles (IoV) and the grid network of satellites. For example, our remote sensing satellite can take photos, compare deformations, and predict earthquakes. Also, our GIS module can search for similar trajectory points based on some trajectory points in criminal investigations by the public police. This module can also be used to perform thermal analysis based on time and space. For example, our GIS module can be used to track vehicles in logistics. Specifically, our GIS module can track couriers in real-time to obtain their real-time positions. It can also help find the most suitable rider for delivering a meal order.
All of these scenarios involve spatio-temporal computing. To deal with the computing, the Ganos module is optimized to improve the computing efficiency of these scenarios.
ApsaraDB RDS for PostgreSQL has obvious advantages over on-premises PostgreSQL.
The first advantage is the management advantage. ApsaraDB RDS for PostgreSQL can complete full lifecycle management, so you do not have to be concerned about backups, high availability, and monitoring. We provide 24/7 official expert services to solve your problems at any time.
The second advantage is the security advantage. ApsaraDB RDS for PostgreSQL supports the features of Secure Sockets Layer (SSL), encryption of cloud disks, SGX full-coverage database encryption, and security groups.
The third advantage is the R&D advantage. We own the world's top database kernel experts and management platform R&D teams. In addition, ApsaraDB RDS for PostgreSQL is fully compatible with the community edition. Therefore, we do not require the binding of ApsaraDB RDS for PostgreSQL.
The product ecosystem of ApsaraDB RDS for PostgreSQL includes supporting tools, partners, and technical support groups. We have more than 3,800 members in our community, including users and Alibaba Cloud experts. All problems can be discussed in the community, including community problems and usage problems on ApsaraDB RDS for PostgreSQL. Alibaba Cloud also provides official support, university courses, and expert service.
What problems can the PostgreSQL and MySQL combination solve? We know that MySQL is widely used and supports many frameworks. However, MySQL can be weak in the following aspects:
By combining MySQL and PostgreSQL, we can support more application scenarios to meet various pressing business needs. To connect the data of the two products, we can establish two links between them.
mysql-fdw plug-in
for accessing external tables.digoal - September 2, 2020
digoal - April 23, 2021
digoal - September 20, 2019
ApsaraDB - December 27, 2023
digoal - July 25, 2019
Alibaba Clouder - January 2, 2019
Supports data migration and data synchronization between data engines, such as relational database, NoSQL and OLAP
Learn MoreAlibaba Cloud PolarDB for PostgreSQL is an in-house relational database service 100% compatible with PostgreSQL and highly compatible with the Oracle syntax.
Learn MoreAlibaba Cloud PolarDB for MySQL is a cloud-native relational database service 100% compatible with MySQL.
Learn MoreAn online MPP warehousing service based on the Greenplum Database open source program
Learn MoreMore Posts by digoal