Product Advantages

Data Security and Reliability

UDB PostgreSQL’s multilayered defenses ensure the security and reliability of data, and high-reliability hardware guarantees the safety of data storage. High availability instances of PostgreSQL ensure multiple redundant data storage, and users can even use the “Create Replica” function to create more database data backups to further enhance data security. UDB PostgreSQL high availability version supports “Second-level Rollback” feature (under development), which can be used to recover data to any second within the past 7 days when a user makes a manual error. “Second-level Rollback” can act as a reassurance for users of the UDB PostgreSQL product.

Full Protocol Compatibility

UDB PostgreSQL is 100% compatible with the PostgreSQL protocol and comes with some typical PostgreSQL extensions (such as the PostGIS geographic database) installed by default, offering a ready-to-use PostgreSQL service experience.

High Performance

Provides fast and efficient database query and transaction processing capabilities to easily handle high concurrency and large-scale data processing needs. Each UDB PostgreSQL instance is backed by powerful hardware. Ucloud’s operating system kernel team has optimized the kernel of each server running a UDB PostgreSQL instance to ensure high system performance; the parameters of UDB PostgreSQL instance have been optimized by professional DBAs to ensure they can handle the majority of use cases.

High Availability

UDB PostgreSQL supports high availability deployment, i.e., UDB PostgreSQL high availability instances. UDB PostgreSQL high availability instances use a master-slave replication architecture, with the master database providing services while another set of database services continually syncs data and stands by, as shown in the figure below:

UDB’s powerful automatic disaster recovery module can detect problems when the UDB PostgreSQL high availability instance service encounters issues and perform disaster recovery automatically, ensuring the stability and reliability of the user’s PostgreSQL database service. When switching UDB PostgreSQL instances, the disaster recovery module will promote the standby PostgreSQL service to be the master, and fall back to being the slave after the original master service starts again. The entire process does not require any manual intervention or configuration changes. The demonstration of the entire disaster recovery process is as shown below:

Easily Handles Complex Scenarios

Easily handles business scenarios with larger data volumes and more complex data types, such as data mining, map spatial data, etc. The PostGIS extension supports standards in the field of geography, suitable for maps, LBS and other business scenarios.

Fast Deployment

Instance deployment can be carried out rapidly online, saving the time spent on purchasing, deploying, and configuring a self-built database, shortening project cycles and enabling businesses to get online faster.

Flexible and Elastic Scaling (Under Development)

UDB PostgreSQL can dynamically adjust database resources according to business needs. With just a few clicks on the console, users can dynamically adjust the computational specifications and disk resources of UDB PostgreSQL instances, meeting the demands for database performance and storage space at different business stages. Particularly for UDB PostgreSQL high-availability instances, during resource expansion, the user’s database service can achieve nearly no downtime with only seconds of short interruption. This greatly reduces the impact time of database expansion on database services, to achieve true “hot upgrade”.

Flexibility and Ease of Use

Everyday operation and maintenance automation, UDB PostgreSQL greatly simplifies a DBA’s routine maintenance tasks: With a few clicks on the interface, a DBA can create a database service running the standard PostgreSQL protocol within minutes; UDB PostgreSQL service performs automatic daily backups and uploads them to a highly reliable backup storage cluster, saving users the need for routine backup tasks; UDB PostgreSQL collects database monitoring data in real time, and users can configure monitoring thresholds to receive timely alerts for various database anomalies.

Lower Costs

Resources required for business needs can be activated on-demand, avoiding the need for high-cost hardware purchases at the start of the business, effectively reducing initial capital investment and avoiding resource idle waste.