Monday, February 7, 2022

Understanding MySQL Database Service(MDS): Managed MySQL, Focus on your Business

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.

 A HeatWave cluster includes a MySQL DB System node and two or more HeatWave nodes.

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.

 More info:- https://dev.mysql.com/doc/heatwave/en/heatwave-introduction.html

 

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

Performance benchmark available:- https://www.mysql.com/why-mysql/benchmarks/

¨   MDS HA(High Availability)

MDS HA is single clicked high availability solution which ensure fault tolerant system with automatic failover and zero data loss.

 Key business benefit of MDS HA include

·       Single Click High Availability

·       Automatic Failover

·       Increase Uptime

·       Zero Data Loss during failure event

·       Application will never experience down time due to MySQL node failures.

 Key product benefit of MDS HA include

·       Built on Group Replication

-          Provides distributed state machine replication with strong coordination between servers.

-          Servers automatically coordinate using Paxos based protocol

·       Plugin that enables you to create elastic, highly-available, fault-tolerant replication topologies.

·       Proven MySQL technology (binary log & replication)

·       Developed and Supported by MySQL Team





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.

 Also, MDS is the only public cloud service built on MySQL Enterprise Edition which comes with comprehensive enterprise security features like

·       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.

 A vast majority of the problems the MySQL Support Engineers encounter, they have seen before. So an issue that could take several weeks for your staff to research and resolve, may be solved in a matter of hours by the MySQL Support team.

       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.