Skip to main content

Posts

Showing posts with the label Azure

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 the tab