Is MongoDB recommended for OLTP processing?

Question

MongoDB is designed for OLTP workloads, so more transactional, online, realtime workloads. People definitely do use it for batch processing, and it works okay in those areas, but it's really designed for OLTP. 9 нояб. 2014 г.

Which database is best for OLTP?

MySQL As a ServiceMySQL Database Service (Multi-Cloud, OLTP, and OLAP)ScaleGrid (Horizontal Scaling)Vitess (Horizontal Scaling)Aiven for MySQL (Multi-Cloud)Amazon RDS for MySQL.Oracle MySQL Cloud Service (Horizontal Scaling)Azure MySQL Database.Google Cloud SQL for MySQL.Top 10 Databases to Use in 2021. MySQL, Oracle, PostgreSQL ...

Is MongoDB good for transactional database?

Summary. Even though it has improved its transactional capabilities over the last few years, MongoDB is still architecturally inferior to modern transactional databases such as YugaByte DB. Using transactions in MongoDB today essentially means giving up on high performance and horizontal scalability.

Is NoSQL good for OLTP?

Relational databases are designed for transactional and strongly consistent online transaction processing (OLTP) applications and are good for online analytical processing (OLAP). NoSQL databases are designed for a number of data access patterns that include low-latency applications.

Can MongoDB be used for OLAP?

MongoDB released the MongoDB connector for BI, which acts as a MySQL server on top of MongoDB data. It means you can use ROLAP (Relational OLAP) engines, such as Cube.

Expert · Answer