![]() We have some modules to support multi-modal application enhancements for certain application scenarios. In this case, you can manually set the parallelism so the database can run as fast as expected. For example, you need to generate a report in the middle of the night, or your analysts must respond to the boss's need during the daytime to generate a report for some factories. In addition, the parallelism is completely automatic.Īlso, you can manually set the parallelism for SQL statements. In other words, parallel computing is available for any query. These scenarios cover almost all complex query conditions. In 32-thread and 64-thread editions, we tested 39 scenarios, for which the speed increased by 20 times on average. So far, we have achieved a qualitative leap in parallel computing. Parallel Computing for Supporting Hybrid Load Business The visualized graph provided by performance insights tells us whether to improve I/O throughput or increase the number of CPUs to solve the performance problem. For a point in time, the larger the area of the polygon enclosed by the point and both axes, the more waiting sessions at this point of time. The horizontal axis indicates the timeline, and the vertical axis indicates the number of waiting sessions. All of the waiting information will be recorded by this feature. An active session contains SQL statements that are being executed, the database where each user is executing the SQL statements, the source host, and the waiting event during the execution, such as waiting for CPUs. If you have enabled this feature, it will intermittently collect active sessions in the database. Features of ApsaraDB RDS for PostgreSQL Product FeaturesĪs shown in the following figure, ApsaraDB RDS for PostgreSQL provides high availability, large capacity, high performance, backup and recovery, robust security and reliability, and read-only disaster recovery.įor more information about performance insights, explore the console. The following figure shows its technical architecture.Ĥ. Technical Architecture of ApsaraDB RDS for PostgreSQLĪpsaraDB RDS for PostgreSQL from Alibaba Cloud not only has the features of native PostgreSQL but also inherits the excellent features of ApsaraDB for RDS. The Apsara stack and agility editions are also available.ģ. Some users may want to use certain special features and therefore need to use the software output. Some new features were added to the Alibaba Cloud edition. The last form is the edition provided by Alibaba Cloud instead of the open-source edition. ![]() The output forms of ApsaraDB for RDS include public cloud, virtual provider, big account, and software output. ![]() All of these are managed by ApsaraDB for RDS so that it becomes a product that covers the full database lifecycle. Users of ApsaraDB for RDS usually do not care about underlying database operating principles, such as how the database product implements high availability, backup, and security audit. It is an out-of-the-box centralized management platform that can manage the full database lifecycle. It supports MySQL, PostgreSQL, and MS SQL. What Is ApsaraDB for RDS?ĪpsaraDB RDS is a relational database service from Alibaba Cloud. It also explains five business scenarios and joint applications. This two-part article details how to combine both the PostgreSQL and MySQL versions of ApsaraDB RDS to enhance the application value. The combination of the two can make the whole greater than the sum of the parts and solve problems that could not have been solved by individual applications. MySQL is currently the most popular open-source database product, and PostgreSQL is the most advanced open-source database product. Digoal, a senior product expert in the Database Business Group of Alibaba Cloud Intelligence, introduced ways to combine ApsaraDB for PostgreSQL and ApsaraDB for MySQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |