[ad_1]
MySQL HeatWave the service of Oracle which combines OLTP, analytics, machine learning and machine learning-based automation in a single MySQL database, is now available on AWS. The advantage of this solution is that it allows you to manage transactional workloads, analytics and machine learning in a single service, avoiding the need to duplicate ETLs between separate databases.
Currently on AWS, as Oracle explains, for transactional processes we must rely on Amazon Aurorafor machine learning a Sage and for analytics ad Amazon Redshift or Snowflake. Being able to manage everything through MySQL HeatWave in short, time and resources can be saved.
The new features of MySQL HeatWave on AWS
Oracle has optimized MySQL HeatWave to take full advantage of the AWS architecture, ensuring latencies in the order of milliseconds. According to the multinational, is able to offer superior performance at more competitive prices: Oracle specifies as in the 4TB TPC-H benchmark, MySQL HeatWave on AWS offers 7x higher price performance than Amazon Redshift, 10x higher than Snowflake, 12x higher than Google BigQuery and 4x higher than Azure Synapse. For machine learning, MySQL HeatWave on AWS is 25x faster than Redshift ML. On a 10GB TPC-C workload, MySQL HeatWave delivers up to 10x more sustained throughput than high concurrency Amazon Aurora.
Anyone wishing to verify the results indicated by Oracle, can do so using the scripts available on GitHub.
Security features have also been enhanced, now including server-side data masking and de-identification, as well as asymmetric encryption and the ability to implement digital signatures to confirm identities. MySQL HeatWave includes a firewall designed to protect the DB from attacks such as SQL Injection.
MySQL Autopilot is also supported, for automation based on machine learning of aspects such as provisioning, data management, query execution, and failure and error management. Oracle also introduced new features for Autopilot, starting in automatic thread pooling to get to the auto shape predictionwhich optimizes workload performance OLTP (On Line Transaction Processing).
“Oracle believes in the principle of empowering customers to choose. Many of our MySQL HeatWave customers have migrated from AWS. Others want to continue to have part of their application on AWS. The latter face tough challenges, including the exorbitant outbound data transfer rates that AWS requires and the higher latency times to access an Oracle cloud database service“, commented Edward Screven, chief corporate architect of Oracle. “We are responding to these challenges with above average performance and with a better price-performance ratio than those of other database providers in the cloud for transactional workloads, analytics, machine learning; it is even better than AWS databases managed in the AWS cloud, contrary to what you might think. We wanted to give them the ability to leverage the innovation of MySQL HeatWave without moving their data from the AWS cloud and without forcing developers to learn a new platform“.
.
[ad_2]
Source link
