In this blog , let understand about key business benefit of using MySQL Database Service.
before that let's understand
What is MySQL database service (MDS)?
MySQL Database Service is a fully managed Oracle Cloud Infrastructure native service, 100% developed, managed, and supported by the MySQL team in Oracle.
Oracle automates all tasks such as high availability, backup and recovery, database and operating system patching,version upgrades and so on.
You are responsible solely
for managing your data, schema designs, and access policies.
MDS is only MySQL managed service with MySQL Enterprise Edition and using integrated massively-scalable query accelerator with Heatwave.
More info:- https://www.oracle.com/mysql/
Why is MySQL Database Service (MDS) ?
Understanding Key Business benefit with MySQL Database Service(MDS) with Heatwave.
List of Business benefit of using MySQL Database Service (MDS)
¨
Extreme Performance with HeatWave
HeatWave is a distributed, scalable, shared-nothing,
in-memory, hybrid columnar, query processing engine designed for extreme
performance for MySQL database service (MDS).
It is enabled when you add a HeatWave cluster to a MySQL
DB System.
The MySQL DB System node has a HeatWave plugin that is
responsible for cluster management, loading data into the HeatWave cluster,
query scheduling, and returning query results to the MySQL DB System.
HeatWave nodes store data in memory and process analytics
queries.
Advantage of using HeatWave to accelerate the performance of MySQL Database
|
Without HeatWave |
With HeatWave |
|
ETL(Extract Transform Load) Required |
No ETL(Extract Transform Load) Required |
|
Application level changes required in syntax and semantics |
No Change in Application |
|
Multiple databases for OLAP and OLTP workloads |
Single MySQL Database Service for all applications
(OLTP , OLAP) |
|
Can be prone to Data loss and inconsistency |
No chance of data loss because data intact with MySQL
database service(MDS). |
|
Lower Performance |
Extreme
Performance -
5400x faster than Amazon RDS -
1400x faster than Amazon Aurora -
6.5x Faster than Amazon Redshift |
|
Higher Cost |
Cheaper Cost -
2/3 cost of Amazon RDS -
½ cost of Amazon Aurora -
½ cost of Amazon Redshift |
 |
| Without HeatWave |
 |
| With Heatwave |
¨ MDS HA(High Availability)
|
MDS HA is single clicked high availability solution which ensure fault tolerant system with automatic failover and zero data loss.
|
|
More info:- https://dev.mysql.com/doc/refman/8.0/en/group-replication.html |
¨
MDS Security Features and Compliance
|
In Today’s digital world data is most valuable asset and database
security has become top priority for the stakeholders. If you lose your data, it can have serious impact in the business,
possibly we may loss the brand. That is why we needed to ensure that whatever in our databases, it
should be fully protected. Stay secure with MDS,
the latest MySQL security fixes from the MySQL team are automatically applied
to limit your exposure to security vulnerabilities.
·
Transparent Data Encryption(TDE) :- -
Data at rest encryption -
AES 256 encryption ·
MySQL Enterprise Encryption -
Data at rest encryption -
AES 256 encryption ·
MySQL Data Masking -
De-identify , Anoymize Sensitive data -
Reduce risk of data breach ·
MySQL Enterprise Firewall -
Block SQL injection attacks -
Intrusion detection ·
MySQL Enterprise Audit -
Tracking the use of database records -
Monitoring each operation on data |
|
More info:- https://dev.mysql.com/doc/refman/8.0/en/mysql-enterprise-security.html |
¨
MDS Cost Less than AWS RDS , Aurora
|
Amazon RDS is ~266% more expensive than MySQL Database Service for
standard compute shapes. In fact OCI(compute, storage, networking) is also cheaper with better
underlying hardware. In case you wanted to know in advance how much MDS cost you , please
enter specific details in the cost
estimator tool here:- https://www.oracle.com/cloud/costestimator.html |
|
|
¨
MySQL Enterprise Support – 24x7 from MySQL team
|
MySQL Technical Support Services provide direct access to our expert
MySQL Support engineers who are ready to assist you in the development,
deployment, and management of MySQL applications. •
Largest MySQL engineering and support
organization •
Backed by the MySQL developers •
World-class support, in 29 languages •
Hot
fixes & maintenance releases •
Consultative
support More info:- https://www.mysql.com/support/ |
Conclusion
Oracle MySQL Database Service is a fully managed database
service that lets developers quickly develop and deploy secure, cloud native
applications using the world’s most popular open source database. MySQL
Database Service is the only MySQL cloud service with an integrated, high
performance, in-memory query accelerator—HeatWave.
It enables customers
to run sophisticated analytics directly against their operational MySQL
databases-eliminating the need for complex, time-consuming, and expensive data
movement and integration with a separate analytics database.
HeatWave accelerates MySQL performance by orders of
magnitude for analytics and mixed workloads. Optimized for Oracle Cloud
Infrastructure (OCI), MySQL Database Service is 100% built, managed, and
supported by the OCI and MySQL engineering teams.
