MySQL
The world's most popular open-source database, enhanced by Oracle for real-time analytics and high performance.
Executive Summary
MySQL is a widely used open-source relational database management system (RDBMS) known for its reliability, performance, and ease of use. Originally developed by MySQL AB, it was acquired by Sun Microsystems, and subsequently by Oracle Corporation. Oracle continues to develop, support, and enhance MySQL, offering various editions including the community version, MySQL Enterprise Edition, and MySQL HeatWave. MySQL Enterprise Edition provides a comprehensive set of advanced features, management tools, and technical support tailored for mission-critical applications, focusing on high availability, security, scalability, and backup. MySQL HeatWave is a specialized service that significantly accelerates query performance for OLTP and OLAP workloads, offering real-time analytics and integrated machine learning capabilities directly within the MySQL database, eliminating the need for separate analytics databases or ETL processes. Oracle's stewardship ensures continuous innovation, robust security, and enterprise-grade support for MySQL, making it a versatile choice for a wide range of applications from web and e-commerce to data warehousing and embedded systems.
Use Cases
- Web applications and e-commerce platforms
- Data warehousing and real-time analytics
- Mission-critical enterprise applications
- Embedded database solutions
- Machine learning model training and inference
Features
Visibility
- MySQL Enterprise Monitor: Provides real-time visibility into database performance, availability, and security through a comprehensive dashboard.
- Query Analyzer: Helps identify and optimize slow-running SQL queries to improve application performance.
Intelligence
- HeatWave ML: Integrated machine learning capabilities for training, inference, and explanation of models directly within the database.
- Real-time Analytics: Accelerates analytical queries on transactional data by orders of magnitude using the HeatWave in-memory query accelerator.
- Generative AI: Integrated generative AI capabilities available within MySQL HeatWave.
Support
- 24/7 Technical Support: Oracle provides comprehensive technical support for MySQL Enterprise Edition and HeatWave.
- Extended Support: Available for desupported MySQL programs, ensuring continued assistance.
- Consulting Services: Expert assistance for deployment, optimization, and management of MySQL environments.
Technical Specifications
- Architecture
- Relational database management system (RDBMS) with client-server architecture. Supports ACID transactions, various storage engines (e.g., InnoDB), and replication for high availability and scalability. HeatWave adds an in-memory query accelerator.
- Deployment
- On-Premise, Self-Hosted, SaaS (via Oracle Cloud Infrastructure or AWS)
- API Available
- Yes
Infrastructure
- Oracle Cloud Infrastructure (OCI)
- AWS
AI/ML Stack
- Generative AI
- Machine Learning
Integrations
- Salesforce
- SAP
- Shopify
- Snowflake
- Workday
Security & Compliance
Certifications: SOC 2, GDPR
Encryption: Supports data encryption at rest (e.g., Transparent Data Encryption) and in transit (e.g., SSL/TLS) to protect sensitive information.
Pricing
- Model
- Subscription-based (per server, per user, or consumption-based for cloud services)
- Starting Price
- Contact sales for Enterprise Edition; consumption-based pricing for HeatWave on OCI/AWS with a free tier available.
- Target Customer
- SMB,Mid-Market,Enterprise
- Contract Type
- Annual (for Enterprise Edition); Monthly/Consumption-based (for cloud services)
- Free Trial
- Yes, Free tier available for MySQL HeatWave on Oracle Cloud Infrastructure (credit card required)
About Oracle Corporation
Oracle Corporation is a global technology company that provides cloud infrastructure and applications, database software, and enterprise IT solutions. Oracle Learning is the company’s training and certification offering, providing role-based learning paths, digital training, and credentials to help organizations adopt and optimize Oracle technologies.