Asst. Senior IT Manager at a retailer with 5,001-10,000 employees
Real User
Apr 22, 2020
I have used IBM's DB2 Database on-premise. IBM also has DB2 on Cloud. DB2 does have replication tools. We have used MIMIX. It is also a relational database. It supports SQL, stored procedures and Command language (CL). It also supports High Availability environment.
I have not worked with Oracle Multimaster so I cannot comment on it. The user in question can definitely check out DB2 database. It's extremely reliable.
Senior Integration Engineer and CEO at a tech company with 11-50 employees
User
Apr 30, 2020
If what you mean by "cloud-native" is "managed" or "as a service", then Oracle database with replication, the turnkey solution right now is Amazon RDS using Oracle. However, replication is not using Oracle's replication engine but rather Amazon's own synchronous replication (probably block based on a filesystem) which allows for read replicas (possibly multiple). It is robust enough to allow actual DR fail overs across regions. Aside from replication it features managed standby.
The same applies for MySQL, Postgres or SQLServer under RDS - only read replicas, single master.
However, Aurora, which is a customized (proprietary) managed MySQL, does have multi-master replication across regions. But there are many things to configure for multiple writers, write conflicts, sharding for example. It is also robust as a DR solution and has standard RBMS features for SQL, stored procedures and a CLI.
I have no info on performance of Aurora, however - you just have to test it on your own.
Oracle Database is renowned for its reliability, scalability, and performance, delivering high availability and security. It integrates seamlessly with other systems, providing exceptional data protection and backup, suitable for managing multiple applications and supporting large datasets.Oracle Database offers a powerful platform for managing data across industries such as finance, manufacturing, and agriculture. It is particularly beneficial for ERP systems, data warehouses, and...
I have used IBM's DB2 Database on-premise. IBM also has DB2 on Cloud. DB2 does have replication tools. We have used MIMIX. It is also a relational database. It supports SQL, stored procedures and Command language (CL). It also supports High Availability environment.
I have not worked with Oracle Multimaster so I cannot comment on it. The user in question can definitely check out DB2 database. It's extremely reliable.
Kindly note that there is not database comparing with Oracle, but you can use Microsoft Azure/Amazon Aurora.
If what you mean by "cloud-native" is "managed" or "as a service", then Oracle database with replication, the turnkey solution right now is Amazon RDS using Oracle. However, replication is not using Oracle's replication engine but rather Amazon's own synchronous replication (probably block based on a filesystem) which allows for read replicas (possibly multiple). It is robust enough to allow actual DR fail overs across regions. Aside from replication it features managed standby.
The same applies for MySQL, Postgres or SQLServer under RDS - only read replicas, single master.
However, Aurora, which is a customized (proprietary) managed MySQL, does have multi-master replication across regions. But there are many things to configure for multiple writers, write conflicts, sharding for example. It is also robust as a DR solution and has standard RBMS features for SQL, stored procedures and a CLI.
I have no info on performance of Aurora, however - you just have to test it on your own.
Not sure what the person means by Cloud Native database.
In all cases, IBM databases Db2 (and Db2 Warehouse) are part of Cloud Pack for Data that offers micro-services end to end data and AI platform built on top of Openshift. Would also propose Postgresql:
www.ibm.com/support/producthub/icpdata/docs/view/data-access/SSQNUZ_current/cpd/svc/dbs/work-with-db.html
All these databases are alternatives to Oracle.
You can refer to the tibero database of Korean tmaxsoft software company
More than 95% similar with oracle as below
1. Achieves Multimaster
2. Robust replication features
3. RDBMS database - SQL, CLI, standard procedures