MySQL HeatWave: OLTP
Online Transaction Processing (OLTP)
MySQL powers the most demanding Web, E-commerce, SaaS, and Online Transaction Processing (OLTP) applications. The InnoDB transactional storage engine is ACID compliant, featuring commit, rollback, and crash-recovery capabilities to protect user data. It provides data integrity through foreign key constrains to ensure there are no data inconsistencies across tables.
MySQL provides advanced SQL features including, Common Table Expressions (CTEs), and Window Functions. The cost-based optimizer analyzes SQL queries and determines the most optimal execution plan to access data. Optimizer hints provide developers and DBAs fine-grained control over statement execution plans.
Innovative enterprises across many industries run MySQL.
MySQL supports a native JSON data type for managing unstructured data. JSON documents are stored in an optimized binary format that enables quick, efficient access to data in JSON documents. MySQL provides automatic validation of JSON documents stored in JSON columns.
MySQL HeatWave Database Service delivers advanced database level security including Network encryption and Transparent Database Encryption (TDE) to protect data in transit and at rest. OCI Identity and Access Management (IAM) allows companies to control who has access to business-critical resources with simple to define policies.
MySQL provides standards-based drivers for JDBC, ODBC,.Net, Node.js, and Python, enabling developers to build database applications in their language of choice. In addition, a native C library allows developers to embed MySQL directly into their applications. The MySQL Community develops and maintained database drivers for PHP, Perl, Python, Ruby, Go, Rust, and Node.js.