Posts

MySQL HeatWave - In-Memory Query Accelerator

Image
 MySQL Database Service delivers a database with all the essential features to help you rapidly pioneer innovative applications, MySQL Database Service is easy to use, secure, and enterprise ready, it combines the benefits of a widely adopted open source database solution with a strong ecosystem, millions of users and the backing of Oracle. MySQL HeatWave increases MySQL DB System performance and eliminates the need for a separate database and tools for OLTP, Analytics and Machine Learning features.  MySQL HeatWave combines transaction processing, real-time analytics and machine learning withing a single MySQL database. It stores data in main memory in a hybrid columnar format, its processing engine is enhanced with aggressive compression of the in-memory data, which helps to reduce the memory footprint, also, it uses a HeatWave cluster for massively parallel and high-performance analytics workloads.  MySQL HeatWave architecture To completely understand how HeatWave works...

Setting up a direct Interconnection between Azure and Oracle Cloud Infrastructure

Image
Oracle and Microsoft have built a dedicated, high-bandwidth, low-latency private network connection between Azure and Oracle Cloud Infrastructure. Customers can access the connection by using either Oracle FastConnect or Microsoft ExpressRoute, and they don’t need to deal with configuration or third-party carriers. Using this cross-cloud connectivity, you can partition a multi-tier application to run your database tier on Oracle Cloud Infrastructure (OCI), and the application and other tiers on Microsoft Azure. The experience is like running the entire solution stack in a single cloud. In this article, I will show you how to create a direct interconnection using the following scenario: A virtual machine DB system running in OCI. A MS Windows Server Machine running in Azure. Then, I will create a connection from SQL Developer in Windows to the Oracle Database in the OCI Virtual Machine.  The following diagram is a high-level overview of the connected solution: Before Start, consider...