High Security
HA architecture
One primary,multi-standby,and one cascaded standby databases
Financial-grade HA
Zero RPO and RTO < 10s
High Performance
Multithreading and high concurrency
Incremental checkpoints
Memory page level primary/standby sync
2.5 million tpmC
High Compatibility
General data types and objects
Stored procedures
Highly compatible with Oracle
Easy to Maintain
Automatic switchover
Automatic backup and cloud sync
API monitoring integration
Application Scenarios
Transaction applications
Applications need to process highly concurrent online transactions containing a large volume of data, such as e-commerce, finance, O2O, telecom customer relationship management (CRM), and billing.
IoT data
In IoT scenarios, such as industrial monitoring, remote control, smart cities, smart homes, and loV, challenges come from a large number of sensors and monitoring devices, high sampling frequency, additional storage modes, and concurrent operation and analysis.
Basic FunctionsBasic Functions
APIs
Standard JDBC 4.0 and ODBC 3.5.
Management Tools
Deployment, instance start/stop, and backup/restoration tools.
Standard SQLs
SQL-92, SQL-99, SQL:2003, and SQL:2011 standards, GBK and UTF-8 character sets, SQL standard functions and analytic functions, and stored procedures.
Security Management
SSL network connection, permission/password Mgmt, and security auditing ensure data security at the Mgmt, app, system, and network layers.
Database Storage Management
Tablespaces where different tables can be stored in different locations.
Primary/Standby Deployment
ACID, recovery from SPOF, and primary/standby data sync.
APIs
Standard JDBC 4.0 and ODBC 3.5.
Standard SQLs
SQL-92, SQL-99, SQL:2003, and SQL:2011 standards, GBK and UTF-8 character sets, SQL standard functions and analytic functions, and stored procedures.
Database Storage Management
Tablespaces where different tables can be stored in different locations.
Management Tools
Deployment, instance start/stop, and backup/restoration tools.
Security Management
SSL network connection, permission/password Mgmt, and security auditing ensure data security at the Mgmt, app, system, and network layers.
Primary/Standby Deployment
ACID, recovery from SPOF, and primary/standby data sync.
Product Advantages and HighlightsProduct Advantages And Highlights
Independent HA Suite
Automatic HA component which can deal with such faults as a server or instance crash, reduces the downtime from minutes to seconds.
Rich Monitoring Items
Apart from regular flow and capacity monitoring items, database event monitoring and the WDR report based on it are also provided.
Unlimited XID
With 64-bit XIDs, the problem that 32-bit XIDs are easily used up existing in PostgreSQL for ages is now solved, and unnecessary vacuum freeze maintenance can be prevented.
Multithreading
The multithreading architecture improves the efficiency of lock synchronization between sessions.
Multiple Storage Engines
In addition to the default stack storage engine, the production-level column-store engine and in-memory storage engine are also provided.
WAL Parallel Replay
The standby database adopts the WAL parallel replay mechanism, thereby preventing data delay occurred in large flow scenarios.
Independent HA Suite
Automatic HA component which can deal with such faults as a server or instance crash, reduces the downtime from minutes to seconds.
Rich Monitoring Items
Apart from regular flow and capacity monitoring items, database event monitoring and the WDR report based on it are also provided.
Unlimited XID
With 64-bit XIDs, the problem that 32-bit XIDs are easily used up existing in PostgreSQL for ages is now solved, and unnecessary vacuum freeze maintenance can be prevented.
Multithreading
The multithreading architecture improves the efficiency of lock synchronization between sessions.
Multiple Storage Engines
In addition to the default stack storage engine, the production-level column-store engine and in-memory storage engine are also provided.
WAL Parallel Replay
The standby database adopts the WAL parallel replay mechanism, thereby preventing data delay occurred in large flow scenarios.
Hands-on Experience
Are you ready to get started with MogDB? We have prepared everything for you! If you have any question, you can view our docs, visit our community, or contact us.