
{"id":8808,"date":"2026-07-21T13:14:36","date_gmt":"2026-07-21T12:14:36","guid":{"rendered":"https:\/\/dasini.net\/blog\/?p=8808"},"modified":"2026-07-21T13:52:38","modified_gmt":"2026-07-21T12:52:38","slug":"oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/","title":{"rendered":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn&rsquo;t simply a matter of making the database faster.<br>It requires <strong>placing the right workload on the right layer<\/strong> of the architecture.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Some operations require <strong>ultra-fast repeated reads<\/strong>, others demand <strong>transactional consistency<\/strong>, while analytical queries benefit from <strong>massively parallel in-memory processing<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">This is precisely where <strong>OCI Cache<\/strong> and <strong>MySQL HeatWave<\/strong> complement each other.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><a href=\"https:\/\/www.oracle.com\/cloud\/cache\/\" target=\"_blank\" rel=\"noopener\" title=\"Achieve submillisecond latency with Oracle Cloud Infrastructure (OCI) Cache, a fully managed Valkey and Redis service engineered for exceptional scalability and consistent high availability\">OCI Cache<\/a><\/strong> provides a fully managed, high-performance caching layer compatible with <strong><a href=\"https:\/\/valkey.io\/\" target=\"_blank\" rel=\"noopener\" title=\"Valkey is an open source (BSD) high-performance key\/value datastore that supports a variety of workloads such as caching, message queues, and can act as a primary database. The project is backed by the Linux Foundation, ensuring it will remain open source forever\">Valkey<\/a><\/strong> and <strong><a href=\"https:\/\/redis.io\/\" target=\"_blank\" rel=\"noopener\" title=\"Redis\">Redis<\/a><\/strong> environments, while <strong><a href=\"https:\/\/www.oracle.com\/mysql\/\" target=\"_blank\" rel=\"noopener\" title=\"Improve MySQL query performance by orders of magnitude and get real-time analytics on your transactional data. Use automated, integrated, and secure generative AI and machine learning (ML) in one cloud service for transactions and lakehouse scale analytics\">MySQL HeatWave<\/a><\/strong> delivers a <strong>fully managed <a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noopener\" title=\"The world's most popular open source database\">MySQL<\/a> database<\/strong> with an <strong>integrated in-memory query accelerator<\/strong> capable of running <strong>transactional<\/strong>, <strong>analytical<\/strong>, <strong>machine learning<\/strong>, and <strong>AI workloads<\/strong> from the same database.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The real value isn&rsquo;t choosing one technology over the other. It&rsquo;s understanding that <strong>they solve different problems<\/strong> and that, when combined, they create a simple yet extremely powerful architecture.<\/p>\n\n\n\n<figure class=\"wp-block-pullquote\"><blockquote><p><strong>OCI Cache accelerates data access. <\/strong><br><strong>MySQL HeatWave accelerates data processing.<\/strong><\/p><\/blockquote><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Together they provide exceptional performance while keeping the architecture straightforward, scalable, and easy to operate.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Far from being competitors, these two services are highly complementary. In this article, we&rsquo;ll explore how they work together and why combining them can dramatically improve application responsiveness, database efficiency, and overall user experience.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">What is OCI Cache?<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"500\" height=\"500\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/valkey-logo-og.png?resize=500%2C500&#038;ssl=1\" alt=\"\" class=\"wp-image-8904\" style=\"object-fit:cover;width:100px;height:100px\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/valkey-logo-og.png?w=500&amp;ssl=1 500w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/valkey-logo-og.png?resize=300%2C300&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/valkey-logo-og.png?resize=150%2C150&amp;ssl=1 150w\" sizes=\"auto, (max-width: 500px) 100vw, 500px\" \/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\">OCI Cache is <strong><a href=\"https:\/\/www.oracle.com\/cloud\/\" target=\"_blank\" rel=\"noopener\" title=\"Oracle Cloud Infrastructure (OCI)\">Oracle Cloud Infrastructure<\/a><\/strong>&lsquo;s fully managed in-memory caching service, powered by <strong>Valkey<\/strong> while maintaining compatibility with the <strong>Redis<\/strong> protocol.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Following Redis licensing changes, the <a href=\"https:\/\/en.wikipedia.org\/wiki\/Open_source\" target=\"_blank\" rel=\"noopener\" title=\"Open source\">open source<\/a> community created <strong>Valkey<\/strong> under the <strong><a href=\"https:\/\/www.linuxfoundation.org\/\" target=\"_blank\" rel=\"noopener\" title=\"Decentralized innovation. Built on trust.\">Linux Foundation<\/a><\/strong>. Oracle became one of its major <a href=\"https:\/\/valkey.io\/\" target=\"_blank\" rel=\"noopener\" title=\"\">contributors<\/a> and integrated Valkey directly into Oracle Cloud Infrastructure (OCI), providing developers with an <strong>enterprise-grade managed service while preserving compatibility with existing Redis<\/strong> applications.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">For teams already familiar with Redis, migrating to OCI Cache typically requires little or no application changes.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Being a fully managed service, OCI Cache removes the operational burden of deploying clusters, configuring replication, handling failover, performing upgrades, and scaling infrastructure. Applications benefit from response times measured in <strong>microseconds to sub-millisecond latency<\/strong>, making it ideal for frequently accessed data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Typical use cases include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>User sessions<\/li>\n\n\n\n<li>Shopping carts<\/li>\n\n\n\n<li>User profiles and preferences<\/li>\n\n\n\n<li>Product catalogs<\/li>\n\n\n\n<li>Feature flags<\/li>\n\n\n\n<li>API response caching<\/li>\n\n\n\n<li>Leaderboards<\/li>\n\n\n\n<li>Rate limiting<\/li>\n\n\n\n<li>Frequently accessed configuration data<\/li>\n\n\n\n<li>&#8230; <\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Its mission is simple:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>Keep the hottest application data in memory so it can be returned almost instantly while reducing the workload on the database.<\/strong><\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a613ccc50aa3&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a613ccc50aa3\" class=\"wp-block-image size-large wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-Architecture.png?resize=800%2C533&#038;ssl=1\" alt=\"OCI Cache architecture\" class=\"wp-image-8882\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-Architecture.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-Architecture.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-Architecture.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-Architecture.png?w=1536&amp;ssl=1 1536w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n<\/blockquote>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">What is MySQL HeatWave?<\/h2>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"770\" height=\"550\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/09\/rc24-heatwave-logo.gif?fit=770%2C550&amp;ssl=1\" alt=\"\" class=\"wp-image-8340\" style=\"object-fit:cover;width:100px;height:100px\"\/><\/figure>\n<\/div>\n\n\n<p class=\"wp-block-paragraph\"><strong>MySQL HeatWave<\/strong> is Oracle&rsquo;s fully managed <strong>MySQL Database Service<\/strong> that natively integrates a massively parallel, in-memory query accelerator (the <strong>RAPID engine<\/strong>) directly with a standard MySQL database (via the reliable <strong><a href=\"https:\/\/dev.mysql.com\/doc\/refman\/9.7\/en\/innodb-introduction.html\" target=\"_blank\" rel=\"noopener\" title=\"InnoDB Storage Engine\">InnoDB<\/a><\/strong> <strong>engine<\/strong>).<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Core Capabilities:<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Dual Acceleration Architecture:<\/strong> Unlike traditional database systems that handle transactional and analytical processes completely separately, HeatWave uses an innovative in-memory engine to dramatically accelerate both standard transactional (OLTP) queries and complex reporting.<\/li>\n\n\n\n<li><strong>True Mixed Workloads (<a href=\"https:\/\/en.wikipedia.org\/wiki\/Hybrid_transactional\/analytical_processing\" target=\"_blank\" rel=\"noopener\" title=\"Hybrid transactional\/analytical processing\">HTAP<\/a>):<\/strong> It runs real-time transactional operations using InnoDB storage while concurrently routing heavy queries and analytics (OLAP) workloads to the integrated HeatWave Cluster.<\/li>\n\n\n\n<li><strong>Zero Code Changes:<\/strong> The query optimizer automatically decides whether to execute a query on standard InnoDB or route it to the massively parallel HeatWave cluster nodes. It accelerates standard MySQL queries by orders of magnitude, frequently turning long-running SQL operations into near-instantaneous responses, without altering a single line of your application code.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Moreover, MySQL HeatWave also includes integrated capabilities such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>AutoML<\/li>\n\n\n\n<li>Vector Store<\/li>\n\n\n\n<li>GenAI<\/li>\n\n\n\n<li>Lakehouse<\/li>\n\n\n\n<li>JSON analytics<\/li>\n\n\n\n<li>&#8230;<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">allowing developers to build modern AI-powered applications directly inside MySQL.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a613ccc513f2&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a613ccc513f2\" class=\"wp-block-image size-large wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/MySQL-HeatWave-Architecture.png?resize=800%2C533&#038;ssl=1\" alt=\"MySQL HeatWave Architecture\" class=\"wp-image-8886\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/MySQL-HeatWave-Architecture.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/MySQL-HeatWave-Architecture.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/MySQL-HeatWave-Architecture.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/MySQL-HeatWave-Architecture.png?w=1536&amp;ssl=1 1536w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Complementary Services, Not Competing Ones<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Because both OCI Cache and HeatWave rely heavily on <strong>memory<\/strong>, it&rsquo;s easy to assume they solve the same problem. They don&rsquo;t!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Their objectives are fundamentally different.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>OCI Cache<\/strong> is an in-memory <strong>key\/value store<\/strong> optimized for retrieving already-known data with extremely low latency.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>MySQL HeatWave<\/strong> is an in-memory <strong>relational query engine<\/strong> optimized for executing SQL statements, joins, aggregations, and analytical queries over very large datasets.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Think of them as two different optimization layers.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a613ccc5196f&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a613ccc5196f\" class=\"wp-block-image size-large wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-MySQL-HeatWave-Ref-Architecture.png?resize=800%2C533&#038;ssl=1\" alt=\"OCI Cache + MySQL HeatWave reference architecture\" class=\"wp-image-8889\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-MySQL-HeatWave-Ref-Architecture.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-MySQL-HeatWave-Ref-Architecture.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-MySQL-HeatWave-Ref-Architecture.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/OCI-Cache-MySQL-HeatWave-Ref-Architecture.png?w=1536&amp;ssl=1 1536w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<h2 class=\"wp-block-heading\">OCI Cache &amp; MySQL HeatWave: Head-to-Head Comparison<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">OCI Cache and HeatWave solve different problems, so it helps to compare them directly.<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table class=\"has-fixed-layout\"><thead><tr><th class=\"has-text-align-left\" data-align=\"left\">Aspect<\/th><th class=\"has-text-align-left\" data-align=\"left\">OCI Cache<\/th><th class=\"has-text-align-left\" data-align=\"left\">MySQL HeatWave<\/th><\/tr><\/thead><tbody><tr><td class=\"has-text-align-left\" data-align=\"left\">Primary role<\/td><td class=\"has-text-align-left\" data-align=\"left\">Ultra-fast data access for repeated reads<\/td><td class=\"has-text-align-left\" data-align=\"left\">High-speed transactional and analytical processing<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Data model<\/td><td class=\"has-text-align-left\" data-align=\"left\">NoSQL Key-Value <\/td><td class=\"has-text-align-left\" data-align=\"left\">Relational tables with SQL<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Latency profile<\/td><td class=\"has-text-align-left\" data-align=\"left\">Microseconds to milliseconds<\/td><td class=\"has-text-align-left\" data-align=\"left\">Milliseconds to seconds<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Best suited for<\/td><td class=\"has-text-align-left\" data-align=\"left\">User sessions, configuration flags, hot lookup results, &#8230; <\/td><td class=\"has-text-align-left\" data-align=\"left\">OLTP, OLAP, AI, reporting<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Consistency<\/td><td class=\"has-text-align-left\" data-align=\"left\">Depends on cache strategy and invalidation<\/td><td class=\"has-text-align-left\" data-align=\"left\">ACID transactions, durable<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Query engine<\/td><td class=\"has-text-align-left\" data-align=\"left\">Simple key-based access patterns<\/td><td class=\"has-text-align-left\" data-align=\"left\">Full SQL + accelerated analytics<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Operational goal<\/td><td class=\"has-text-align-left\" data-align=\"left\">Reduce latency and offload MySQL<\/td><td class=\"has-text-align-left\" data-align=\"left\">Accelerate computation<\/td><\/tr><tr><td class=\"has-text-align-left\" data-align=\"left\">Scale Mechanism<\/td><td class=\"has-text-align-left\" data-align=\"left\">Shards\/replicas and vertical scaling<\/td><td class=\"has-text-align-left\" data-align=\"left\">Scale the HeatWave cluster (nodes) independently of MySQL (read replicas)<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">As you&rsquo;ve understood, both are in-memory technologies&#8230; but optimized for completely different access patterns.<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">A simple way to remember the difference:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"text-decoration: underline;\">OCI Cache answers<\/span><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><em>\"Give me product #123.\"<\/em><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><span style=\"text-decoration: underline;\">MySQL HeatWave answers<\/span><\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"><em>\"Show me the top twenty products purchased by customers living in France during the last two years.\"<\/em><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Those are completely different workloads.<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Choosing the Right Architecture<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Depending on your workload, several architectures are possible.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL HeatWave Only<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Ideal when your application requires:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>transactional consistency<\/li>\n\n\n\n<li>query acceleration<\/li>\n\n\n\n<li>operational reporting<\/li>\n\n\n\n<li>real-time analytics<\/li>\n\n\n\n<li>AI capabilities<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The HeatWave Cluster accelerates SQL execution directly inside MySQL, making it an excellent solution for mixed OLTP\/OLAP workloads.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">However, HeatWave is <strong>not<\/strong> a cache.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Repeated requests for the exact same object still require SQL execution.<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">OCI Cache in Front of MySQL<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">This architecture shines for applications with many repeated reads.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Frequently requested objects are stored in OCI Cache, allowing subsequent requests to bypass MySQL entirely.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Benefits include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>dramatically lower latency<\/li>\n\n\n\n<li>reduced database load<\/li>\n\n\n\n<li>improved scalability<\/li>\n\n\n\n<li>better user experience<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The trade-off is that applications must manage cache expiration and cache invalidation.<\/p>\n\n\n\n<figure data-wp-context=\"{&quot;imageId&quot;:&quot;6a613ccc52479&quot;}\" data-wp-interactive=\"core\/image\" data-wp-key=\"6a613ccc52479\" class=\"wp-block-image size-large wp-lightbox-container\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" data-wp-class--hide=\"state.isContentHidden\" data-wp-class--show=\"state.isContentVisible\" data-wp-init=\"callbacks.setButtonStyles\" data-wp-on--click=\"actions.showLightbox\" data-wp-on--load=\"callbacks.setButtonStyles\" data-wp-on--pointerdown=\"actions.preloadImage\" data-wp-on--pointerenter=\"actions.preloadImageWithDelay\" data-wp-on--pointerleave=\"actions.cancelPreload\" data-wp-on-window--resize=\"callbacks.setButtonStyles\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Request-Flow-Cache-Hit-vs-Cache-Miss-1.png?resize=800%2C533&#038;ssl=1\" alt=\"\" class=\"wp-image-8967\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Request-Flow-Cache-Hit-vs-Cache-Miss-1.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Request-Flow-Cache-Hit-vs-Cache-Miss-1.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Request-Flow-Cache-Hit-vs-Cache-Miss-1.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Request-Flow-Cache-Hit-vs-Cache-Miss-1.png?w=1536&amp;ssl=1 1536w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><button\n\t\t\tclass=\"lightbox-trigger\"\n\t\t\ttype=\"button\"\n\t\t\taria-haspopup=\"dialog\"\n\t\t\tdata-wp-bind--aria-label=\"state.thisImage.triggerButtonAriaLabel\"\n\t\t\tdata-wp-init=\"callbacks.initTriggerButton\"\n\t\t\tdata-wp-on--click=\"actions.showLightbox\"\n\t\t\tdata-wp-style--right=\"state.thisImage.buttonRight\"\n\t\t\tdata-wp-style--top=\"state.thisImage.buttonTop\"\n\t\t>\n\t\t\t<svg xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"12\" height=\"12\" fill=\"none\" viewBox=\"0 0 12 12\">\n\t\t\t\t<path fill=\"#fff\" d=\"M2 0a2 2 0 0 0-2 2v2h1.5V2a.5.5 0 0 1 .5-.5h2V0H2Zm2 10.5H2a.5.5 0 0 1-.5-.5V8H0v2a2 2 0 0 0 2 2h2v-1.5ZM8 12v-1.5h2a.5.5 0 0 0 .5-.5V8H12v2a2 2 0 0 1-2 2H8Zm2-12a2 2 0 0 1 2 2v2h-1.5V2a.5.5 0 0 0-.5-.5H8V0h2Z\" \/>\n\t\t\t<\/svg>\n\t\t<\/button><\/figure>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">OCI Cache + MySQL HeatWave<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">For many modern applications, this is the sweet spot:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>OCI Cache handles extremely frequent application reads.<\/li>\n\n\n\n<li>MySQL remains the durable source of truth.<\/li>\n\n\n\n<li>HeatWave accelerates reporting, dashboards, AI, and complex SQL queries.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Each service focuses on what it does best.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-default\"\/>\n\n\n\n<p class=\"wp-block-paragraph\">A useful mental model is:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>OCI Cache is the fastest path to already-known information.<\/strong><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">while<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>MySQL HeatWave is the fastest path to discovering new information through SQL, analytics, and AI.<\/strong><\/p>\n<\/blockquote>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Why use both?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Using both services together creates a very balanced architecture. OCI Cache absorbs the repetitive reads that applications perform thousands of times every second.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Meanwhile, MySQL HeatWave focuses on:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>transactional integrity<\/li>\n\n\n\n<li>fresh data<\/li>\n\n\n\n<li>analytical queries<\/li>\n\n\n\n<li>dashboards<\/li>\n\n\n\n<li>AI workloads<\/li>\n\n\n\n<li>reporting<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The combination is especially attractive when:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>your application has a small set of extremely hot data;<\/li>\n\n\n\n<li>you need operational dashboards;<\/li>\n\n\n\n<li>you want to reduce database load;<\/li>\n\n\n\n<li>you want analytics without introducing another database technology;<\/li>\n\n\n\n<li>you prefer a simple, cloud-native architecture.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">One way to visualize the relationship is:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>OCI Cache reduces how often your application needs to ask the database the same question. <\/strong><br><br><strong>MySQL HeatWave dramatically improves how quickly the database answers every remaining question.<\/strong><\/p>\n<\/blockquote>\n\n\n\n<p class=\"wp-block-paragraph\">That&rsquo;s not overlap, that&rsquo;s architectural layering!<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Advantages and Considerations<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">OCI Cache<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Advantages<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Extremely low latency<\/li>\n\n\n\n<li>Redis\/Valkey protocol compatibility<\/li>\n\n\n\n<li>Fully managed<\/li>\n\n\n\n<li>Reduces read pressure on database instances<\/li>\n\n\n\n<li>Excellent horizontal scalability<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Considerations<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Adds cache invalidation complexity to application code<\/li>\n\n\n\n<li>No persistence guarantee (ephemeral in nature)<\/li>\n\n\n\n<li>Does not replace a persistent database<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Cache-Aside-Workflow.png?ssl=1\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"533\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Cache-Aside-Workflow.png?resize=800%2C533&#038;ssl=1\" alt=\"Cache-aside Workflow\" class=\"wp-image-8895\" srcset=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Cache-Aside-Workflow.png?resize=800%2C533&amp;ssl=1 800w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Cache-Aside-Workflow.png?resize=300%2C200&amp;ssl=1 300w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Cache-Aside-Workflow.png?resize=768%2C512&amp;ssl=1 768w, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/Cache-Aside-Workflow.png?w=1536&amp;ssl=1 1536w\" sizes=\"auto, (max-width: 800px) 100vw, 800px\" \/><\/a><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity is-style-dots\"\/>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL HeatWave<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Advantages<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>SQL support<\/li>\n\n\n\n<li>ACID compliance<\/li>\n\n\n\n<li>Mixed OLTP, OLAP and AI workloads<\/li>\n\n\n\n<li>High-performance analytics<\/li>\n\n\n\n<li>Integrated Machine Learning and GenAI<\/li>\n\n\n\n<li>Persistent storage<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Considerations<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Not intended for key\/value caching<\/li>\n\n\n\n<li>Slightly higher baseline network and query parsing overhead compared to pure memory lookups<\/li>\n\n\n\n<li>Solves a different class of performance problems<\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Demo: A Python Glimpse at Latency<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><br>To show how simple it is to programmatically bridge these two layers, let\u2019s look at a practical Python script.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Instead of mock data, this script connects to <strong>MySQL HeatWave<\/strong> using the <code>MySQL Connector\/Python<\/code> to find a specific user, populates (seeds) the <strong>OCI Cache<\/strong> with that record as a JSON object using the <code>valkey<\/code> client, and then runs a back-to-back benchmark to demonstrate the latency difference between the two layers.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The goal isn\u2019t to show MySQL is slow, its own read latency with a primary key is excellent, but to highlight the&nbsp;<strong>difference in speed<\/strong>&nbsp;a dedicated cache layer can provide for hot data.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"python\" class=\"language-python\">import valkey\nimport mysql.connector\nimport time\nimport json\n\n# ==========================================\n# 1. CONNECTION SETUP\n# ==========================================\n# OCI Cache (Valkey) Connection\ncache = valkey.Valkey(\n    host='abcdefghijklmno.redis.eu-frankfurt-1.oci.oraclecloud.com',\n    port=6379,\n    ssl=True,\n    decode_responses=True\n)\n\n# MySQL HeatWave Connection\ndef get_mysql_conn():\n    return pymysql.connect(\n        host='10.0.1.42',\n        user='dev',\n        password='My5U4\u20acs3kret',\n        database='oci-cache_mysql-heatwave',\n        autocommit=True\n    )\n\n# ==========================================\n# 2. SETUP: SYNC DATA FROM MYSQL TO OCI CACHE\n# ==========================================\nUSER_ID = 42\ncache_key = f\"user:{USER_ID}\"\n\nprint(f\"[*] Connecting to MySQL HeatWave to fetch data for user {USER_ID}...\")\nsetup_conn = get_mysql_conn()\ncursor = setup_conn.cursor(dictionary=True)\ncursor.execute(\"SELECT id, name, role FROM users WHERE id = %s\", (USER_ID,))\nuser_data = cursor.fetchone()\n\ncursor.close()\nsetup_conn.close()\n\nif not user_data:\n    raise ValueError(f\"User with ID {USER_ID} not found in MySQL. Please verify your seed data.\")\n\n# Set the cache with the actual database payload\nprint(f\"[*] Seeding OCI Cache (Valkey) with data from MySQL: {user_data}\")\ncache.set(cache_key, json.dumps(user_data))\nprint(\"[+] Cache primed successfully!\\n\")\n\n\n# ==========================================\n# 3. LATENCY BENCHMARK\n# ==========================================\n\n# --- SCENARIO A: Reading from OCI Cache (Valkey) ---\nstart_time = time.perf_counter()\ncached_data = cache.get(cache_key)\ncache_latency = (time.perf_counter() - start_time) * 1000 # Convert to ms\n\n\n# --- SCENARIO B: Reading from MySQL (InnoDB) ---\nconn = get_mysql_conn()\nstart_time = time.perf_counter()\ncursor = conn.cursor(dictionary=True)\ncursor.execute(\"SELECT id, name, role FROM users WHERE id = %s\", (USER_ID,))\ndb_data = cursor.fetchone()\ncursor.close()\ndb_latency = (time.perf_counter() - start_time) * 1000 # Convert to ms\n\nconn.close()\n\n\n# ==========================================\n# 4. RESULTS\n# ==========================================\nprint(\"--- Latency Benchmark Results ---\")\nprint(f\"OCI Cache (Valkey) Read: {cache_latency:.3f} ms\")\nprint(f\"MySQL (InnoDB) Read:     {db_latency:.3f} ms\")\nprint(f\"Speedup Factor:          {db_latency \/ cache_latency:.1f}x faster via Cache\")<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">You can download the script <a href=\"https:\/\/github.com\/freshdaz\/OCI-Cache-and-MySQL-HeatWave-Better-Together-for-High-Performance-Applications\/blob\/main\/mysql_valkey.py\" target=\"_blank\" rel=\"noopener\" title=\"OCI-Cache-and-MySQL-HeatWave-Better-Together-for-High-Performance-Applications \/mysql_valkey.py on GitHub\">here<\/a>.<\/p>\n\n\n\n<div style=\"height:15px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Let&rsquo;s run this script&#8230;<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code lang=\"bash\" class=\"language-bash\">(venv) daz@sandbox:~\/valkey$ python3 demo1_local.py \n[*] Connecting to MySQL HeatWave to fetch data for user 42...\n[*] Seeding OCI Cache (Valkey) with data from MySQL: {'id': 42, 'name': 'Olivier', 'role': 'admin'}\n[+] Cache primed successfully!\n\n--- Latency Benchmark Results ---\nOCI Cache (Valkey) Read: 0.078 ms\nMySQL (InnoDB) Read:     0.248 ms\nSpeedup Factor:          3.2x faster via Cache<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><span style=\"text-decoration: underline;\">What this tells us<\/span>:<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">When you run this script, you will typically see OCI Cache returning data in <strong>fractions of a millisecond<\/strong>, while MySQL takes a few milliseconds.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>For a CTO:<\/strong> That millisecond difference, multiplied by millions of daily active users, translates to a scalable architecture, massive infrastructure cost savings and a snappier user experience.<\/li>\n\n\n\n<li><strong>For a Developer:<\/strong> You get access to ultra-fast, microsecond APIs for fast user experiences alongside a fully robust, standard SQL database that seamlessly handles backend transactional logic and reporting.<\/li>\n\n\n\n<li><strong>For a DBA:<\/strong> You successfully offloaded millions of trivial <code>SELECT<\/code> statements away from your precious MySQL connection pool, keeping the database healthy for complex transactions and HeatWave analytics.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">By running both services natively on OCI, you eliminate integration and management overhead, allowing you to focus purely on building fast, scalable applications.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">P\u00e9roraison<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>OCI Cache<\/strong> and <strong>MySQL HeatWave<\/strong> are not competing services, they operate at different layers of the application stack.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">OCI Cache minimizes application latency by serving frequently accessed data directly from memory, while MySQL HeatWave accelerates transactional processing, analytics, machine learning, AI, and SQL execution on persistent data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Together they enable architects to design applications that are responsive, scalable, analytically powerful, and remarkably simple.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Perhaps the biggest advantage is that both are fully managed Oracle Cloud services. You don&rsquo;t have to spend your time provisioning servers, configuring clusters, or managing failover. Instead, you can focus on what really matters: <strong>building applications that deliver value to your users<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the end, it&rsquo;s not about choosing between caching and database acceleration. It&rsquo;s about using each technology where it delivers the greatest benefit.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Resources<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.oracle.com\/mysql\/\" target=\"_blank\" rel=\"noopener\" title=\"MySQL HeatWave Overview\">MySQL HeatWave Overview<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/dev.mysql.com\/doc\/heatwave\/en\/\" target=\"_blank\" rel=\"noopener\" title=\"HeatWave User Guide\">HeatWave User Guide<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noopener\" title=\"MySQL\">MySQL<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.oracle.com\/cloud\/cache\/\" target=\"_blank\" rel=\"noopener\" title=\"OCI Cache Overview\">OCI Cache Overview<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/valkey.io\/\" target=\"_blank\" rel=\"noopener\" title=\"Valkey\">Valkey<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.oracle.com\/cloud\/\" target=\"_blank\" rel=\"noopener\" title=\"Oracle Cloud Infrastructure\">Oracle Cloud Overview<\/a><\/li>\n<\/ul>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/www.linkedin.com\/groups\/12524512\/\" target=\"_blank\" rel=\"noopener\" title=\"Olivier DASINI on Linkedin\">Follow me on Linkedin<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Watch my videos on my <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier's MySQL Channel\">YouTube channel<\/a> and <a href=\"https:\/\/www.youtube.com\/channel\/UC12TulyJsJZHoCmby3Nm3WQ\/?sub_confirmation=1\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Subscribe\">subscribe<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">My <a href=\"https:\/\/speakerdeck.com\/freshdaz\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Speaker Deck\">Speaker Deck account<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">My <a href=\"https:\/\/www.slideshare.net\/freshdaz\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Olivier DASINI on Slideshare\">Slideshare account<\/a> (<em>archive<\/em>).<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p class=\"has-vivid-red-color has-text-color wp-block-paragraph\"><strong>Thanks for using HeatWave &amp; MySQL!<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn&rsquo;t simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_post_was_ever_published":false},"categories":[1744,1694,1719,203,425],"tags":[1779,306,1697,1777,1775],"class_list":["post-8808","post","type-post","status-publish","format-standard","hentry","category-coding","category-heatwave-en","category-mds-en","category-mysql-en","category-nosql-en","tag-cache","tag-cloud","tag-heatwave-fr-en","tag-redis","tag-valkey"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 4.9.9 - aioseo.com -->\n\t<meta name=\"description\" content=\"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn&#039;t simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Olivier DASINI\"\/>\n\t<meta name=\"google-site-verification\" content=\"HN6x37mM2NBzUxcsZUKC8OY_DxAioI6oKazYPPNq02c\" \/>\n\t<meta name=\"keywords\" content=\"cache,cloud,heatwave,redis,valkey,coding,mds,mysql,nosql\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 4.9.9\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\n\t\t<meta property=\"og:site_name\" content=\"Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights | Exploring Beyond the Limits of Knowledge\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\" \/>\n\t\t<meta property=\"og:description\" content=\"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn&#039;t simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2026-07-21T12:14:36+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2026-07-21T12:52:38+00:00\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@freshdaz\" \/>\n\t\t<meta name=\"twitter:title\" content=\"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\" \/>\n\t\t<meta name=\"twitter:description\" content=\"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn&#039;t simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@freshdaz\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#article\",\"name\":\"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\",\"headline\":\"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications\",\"author\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/dasini.net\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/07\\\/valkey-logo-og.png?fit=500%2C500&ssl=1\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#articleImage\",\"width\":500,\"height\":500},\"datePublished\":\"2026-07-21T13:14:36+01:00\",\"dateModified\":\"2026-07-21T13:52:38+01:00\",\"inLanguage\":\"fr-FR\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#webpage\"},\"articleSection\":\"Coding, HeatWave, MDS, MySQL, NoSQL, Cache, Cloud, Heatwave, Redis, Valkey, English\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/dasini.net\\\/blog\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"name\":\"MySQL\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"position\":2,\"name\":\"MySQL\",\"item\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#listItem\",\"name\":\"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#listItem\",\"position\":3,\"name\":\"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/category\\\/mysql-en\\\/#listItem\",\"name\":\"MySQL\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\",\"name\":\"Olivier DASINI\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#personImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Olivier DASINI\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/\",\"name\":\"Olivier DASINI\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#authorImage\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g\",\"width\":96,\"height\":96,\"caption\":\"Olivier DASINI\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#webpage\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/\",\"name\":\"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights\",\"description\":\"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn't simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit\",\"inLanguage\":\"fr-FR\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/2026\\\/07\\\/21\\\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\\\/#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/author\\\/freshdaz\\\/#author\"},\"datePublished\":\"2026-07-21T13:14:36+01:00\",\"dateModified\":\"2026-07-21T13:52:38+01:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/dasini.net\\\/blog\\\/\",\"name\":\"dasini.net - Diary of a MySQL expert\",\"description\":\"Exploring Beyond the Limits of Knowledge\",\"inLanguage\":\"fr-FR\",\"publisher\":{\"@id\":\"https:\\\/\\\/dasini.net\\\/blog\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","description":"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn't simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit","canonical_url":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/","robots":"max-image-preview:large","keywords":"cache,cloud,heatwave,redis,valkey,coding,mds,mysql,nosql","webmasterTools":{"google-site-verification":"HN6x37mM2NBzUxcsZUKC8OY_DxAioI6oKazYPPNq02c","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#article","name":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","headline":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications","author":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"publisher":{"@id":"https:\/\/dasini.net\/blog\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2026\/07\/valkey-logo-og.png?fit=500%2C500&ssl=1","@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#articleImage","width":500,"height":500},"datePublished":"2026-07-21T13:14:36+01:00","dateModified":"2026-07-21T13:52:38+01:00","inLanguage":"fr-FR","mainEntityOfPage":{"@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#webpage"},"isPartOf":{"@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#webpage"},"articleSection":"Coding, HeatWave, MDS, MySQL, NoSQL, Cache, Cloud, Heatwave, Redis, Valkey, English"},{"@type":"BreadcrumbList","@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog#listItem","position":1,"name":"Home","item":"https:\/\/dasini.net\/blog","nextItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","name":"MySQL"}},{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","position":2,"name":"MySQL","item":"https:\/\/dasini.net\/blog\/category\/mysql-en\/","nextItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#listItem","name":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications"},"previousItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#listItem","position":3,"name":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications","previousItem":{"@type":"ListItem","@id":"https:\/\/dasini.net\/blog\/category\/mysql-en\/#listItem","name":"MySQL"}}]},{"@type":"Person","@id":"https:\/\/dasini.net\/blog\/#person","name":"Olivier DASINI","image":{"@type":"ImageObject","@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#personImage","url":"https:\/\/secure.gravatar.com\/avatar\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g","width":96,"height":96,"caption":"Olivier DASINI"}},{"@type":"Person","@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author","url":"https:\/\/dasini.net\/blog\/author\/freshdaz\/","name":"Olivier DASINI","image":{"@type":"ImageObject","@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#authorImage","url":"https:\/\/secure.gravatar.com\/avatar\/d46da4fb4b99ea9ce527a93ce9b998a446577e42e1f132d8437235fa5b963636?s=96&d=mm&r=g","width":96,"height":96,"caption":"Olivier DASINI"}},{"@type":"WebPage","@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#webpage","url":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/","name":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","description":"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn't simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit","inLanguage":"fr-FR","isPartOf":{"@id":"https:\/\/dasini.net\/blog\/#website"},"breadcrumb":{"@id":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/#breadcrumblist"},"author":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"creator":{"@id":"https:\/\/dasini.net\/blog\/author\/freshdaz\/#author"},"datePublished":"2026-07-21T13:14:36+01:00","dateModified":"2026-07-21T13:52:38+01:00"},{"@type":"WebSite","@id":"https:\/\/dasini.net\/blog\/#website","url":"https:\/\/dasini.net\/blog\/","name":"dasini.net - Diary of a MySQL expert","description":"Exploring Beyond the Limits of Knowledge","inLanguage":"fr-FR","publisher":{"@id":"https:\/\/dasini.net\/blog\/#person"}}]},"og:locale":"fr_FR","og:site_name":"Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights | Exploring Beyond the Limits of Knowledge","og:type":"article","og:title":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","og:description":"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn't simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit","og:url":"https:\/\/dasini.net\/blog\/2026\/07\/21\/oci-cache-and-mysql-heatwave-better-together-for-high-performance-applications\/","article:published_time":"2026-07-21T12:14:36+00:00","article:modified_time":"2026-07-21T12:52:38+00:00","twitter:card":"summary","twitter:site":"@freshdaz","twitter:title":"OCI Cache and MySQL HeatWave: Better Together for High-Performance Applications | Data Daz (dasini.net) - Data Systems, AI, and Real-World Insights","twitter:description":"Modern applications are expected to deliver instant responses while processing increasingly large volumes of data. Achieving this level of performance isn't simply a matter of making the database faster.It requires placing the right workload on the right layer of the architecture. Some operations require ultra-fast repeated reads, others demand transactional consistency, while analytical queries benefit","twitter:creator":"@freshdaz"},"aioseo_meta_data":{"post_id":"8808","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"","score":0,"analysis":{"keyphraseInTitle":{"score":0,"maxScore":9,"error":1}}},"additional":[]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"Article","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","location":null,"local_seo":null,"breadcrumb_settings":null,"limit_modified_date":false,"ai":{"faqs":[],"keyPoints":[],"schemas":[],"titles":[],"descriptions":[],"socialPosts":{"email":{"subject":"","preview":"","content":""},"linkedin":[],"twitter":[],"facebook":[],"instagram":[]}},"created":"2026-07-13 13:57:12","updated":"2026-07-21 15:10:44","seo_analyzer_scan_date":null},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-2i4","jetpack-related-posts":[{"id":4462,"url":"https:\/\/dasini.net\/blog\/2021\/04\/13\/heatwave-a-mysql-cloud-feature-to-speed-up-your-queries\/","url_meta":{"origin":8808,"position":0},"title":"HeatWave &#8211; A MySQL cloud feature to speed up your queries","author":"Olivier DASINI","date":"13 avril 2021","format":false,"excerpt":"If you have (too) long running select queries it is probably because of lack of relevant indexes, problematic schema that lead to poor queries or inadequate hardware. That said, sometime even if you doing it right, the query execution time could be too long regarding of what the application or\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/04\/MySQL-Database-Service-HeatWave-Replication.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/04\/MySQL-Database-Service-HeatWave-Replication.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/04\/MySQL-Database-Service-HeatWave-Replication.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/04\/MySQL-Database-Service-HeatWave-Replication.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":5762,"url":"https:\/\/dasini.net\/blog\/2022\/06\/09\/explore-visualize-your-mysql-heatwave-data-with-superset\/","url_meta":{"origin":8808,"position":1},"title":"Explore &#038; visualize your MySQL HeatWave data with Superset","author":"Olivier DASINI","date":"9 juin 2022","format":false,"excerpt":"In this article I will show you how to properly configure Apache Superset in order to take advantage of a high performance, in-memory query accelerator: MySQL HeatWave.","rel":"","context":"Dans &quot;MySQL&quot;","block_context":{"text":"MySQL","link":"https:\/\/dasini.net\/blog\/category\/mysql-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=1050%2C600 3x"},"classes":[]},{"id":4662,"url":"https:\/\/dasini.net\/blog\/2021\/08\/03\/discovering-mysql-database-service-episode-1-introduction\/","url_meta":{"origin":8808,"position":2},"title":"Discovering MySQL Database Service &#8211; Episode 1 &#8211; Introduction","author":"Olivier DASINI","date":"3 ao\u00fbt 2021","format":false,"excerpt":"This is the first episode of \u201cDiscovering MySQL Database Service\u201c, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. Like any series, in this episode I\u2019m going to give you some context and set\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"MySQL Database Service","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":5915,"url":"https:\/\/dasini.net\/blog\/2022\/07\/05\/interactively-explore-visualize-your-mysql-heatwave-data-with-apache-zeppelin\/","url_meta":{"origin":8808,"position":3},"title":"Interactively explore &#038; visualize your MySQL HeatWave data with Apache Zeppelin","author":"Olivier DASINI","date":"5 juillet 2022","format":false,"excerpt":"In this article I will show you how to properly configure Apache Zeppelin in order to take advantage of the Analytics and Machine Learning capabilities of MySQL HeatWave the MySQL in-memory query accelerator.","rel":"","context":"Dans &quot;Machine Learning&quot;","block_context":{"text":"Machine Learning","link":"https:\/\/dasini.net\/blog\/category\/machine-learning-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=700%2C400 2x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2022\/06\/Configure-Heatwave-Cluster.png?resize=1050%2C600 3x"},"classes":[]},{"id":7252,"url":"https:\/\/dasini.net\/blog\/2025\/02\/11\/building-an-interactive-llm-chatbot-with-heatwave-using-python\/","url_meta":{"origin":8808,"position":4},"title":"Building an Interactive LLM Chatbot with  HeatWave Using Python","author":"Olivier DASINI","date":"11 f\u00e9vrier 2025","format":false,"excerpt":"AI-powered applications require robust and scalable database solutions to manage and process large amounts of data efficiently. HeatWave is an excellent choice for such applications, providing high-performance OLTP, analytics, machine learning and generative artificial intelligence capabilities. In this article, we will explore a Python 3 script that connects to an\u2026","rel":"","context":"Dans &quot;HeatWave&quot;","block_context":{"text":"HeatWave","link":"https:\/\/dasini.net\/blog\/category\/heatwave-en\/"},"img":{"alt_text":"simple but robust chatbot system leveraging HeatWave GenAI and its in-database Mistral LLM","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/02\/HW-Chat-mistral-7b.gif?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/02\/HW-Chat-mistral-7b.gif?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/02\/HW-Chat-mistral-7b.gif?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/02\/HW-Chat-mistral-7b.gif?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2025\/02\/HW-Chat-mistral-7b.gif?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":8792,"url":"https:\/\/dasini.net\/blog\/2026\/07\/01\/mysql-mysql-heatwave-report-june-2026\/","url_meta":{"origin":8808,"position":5},"title":"MySQL &amp; MySQL HeatWave Report \u2013 June 2026","author":"Olivier DASINI","date":"1 juillet 2026","format":false,"excerpt":"Keeping up with the MySQL ecosystem is becoming increasingly challenging. Every release introduces new features, performance improvements, security enhancements, and cloud capabilities. While the official documentation is comprehensive, it is not always easy to quickly identify what really matters. To help with that, I've published a new edition of my\u2026","rel":"","context":"Dans &quot;AI&quot;","block_context":{"text":"AI","link":"https:\/\/dasini.net\/blog\/category\/ai\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/8808","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=8808"}],"version-history":[{"count":156,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/8808\/revisions"}],"predecessor-version":[{"id":8975,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/8808\/revisions\/8975"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=8808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=8808"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=8808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}