Skip to main content

Posts

Showing posts with the label Azure

Introducing Azure HorizonDB: The Next Evolution of Enterprise PostgreSQL

For years, database administrators and data architects have played a balancing act. If you want open-source flexibility, you choose PostgreSQL. If you want massive cloud scale and low-latency throughput, you end up looking at proprietary cloud-native architectures. ​Microsoft is bridging that gap entirely with Azure HorizonDB —a fully managed, AI-ready, cloud-native database built directly on open-source PostgreSQL. ​For the community here at youngdba.com, HorizonDB represents a massive shift in how we think about storage engines, high availability, and AI integration. Let’s break down the architecture that makes this service a game-changer for modern data pipelines. ​The Architectural Blueprint: Disaggregated & Log-Centric ​Traditional databases often couple compute and storage, leading to I/O bottlenecks during heavy scaling or checkpointing. HorizonDB rewrites the playbook by using two core foundational principles: ​Separation of Compute and Storage: Compute resources (vCores an...

10 Facts about Azure Stream Analytics

Microsoft Azure Stream Analytics is a serverless scalable complex event processing engine by Microsoft that enables users to develop and run real-time analytics on multiple streams of data from sources such as devices, sensors, web sites, social media, and other applications (wiki). 10 Facts Stream Analytics is an event processing engine, which can ingest & analyze in real-time. ASA can stream data from devices, sensors, websites, social media feeds, applications, and more. Stream Analytics don't mandatory to store data, analyse data in motion as well as stored. Stream Analytics is built on a pull-based communication mode. Stream Analytics supports two input types, stream data and reference data. It has two source types, Azure Event Hubs and Azure Blob storage. Process starts with a source of streaming data that is ingested into Azure Event Hub or Azure Blob Storage. We can create a job that specifies the input source that streams data. The job also specifies a tran...

Azure doesn't support MyISAM engine

Azure DB for MySQL released in the year 2017, this given the new advantages for those customers whose environment is SQL Server along with open source RDBMS. Now cloud database platform changes the technology parameter cutting-edge technology to bleeding edge technology, everything is being crossed platform. Recently one of the clients has thinking to shift their in-house MySQL to Azure environment. Their 70% database platform is on SQL Server and rest are on MySQL and MongoDB. We got chance to migrate existing database to Azure. The application was 3 years old and database was mix of the plug gable engine of  on tables like MyISAM, InnoDB, and csv. Like all other Azure services  MySQL  on AzureDB is also easy to setup in few clicks. We did the same but when we started migrating database, it raised the error " Azure doesn't support MyISAM ".  Actually, Azure did good for Database point of view but for existing system we required to do some changes. We changes th...