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 table's engine for those tables having MyISAM and then did migration again. Finally I seen my first MySQL Database on AzureDB.
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 table's engine for those tables having MyISAM and then did migration again. Finally I seen my first MySQL Database on AzureDB.
Thanks
Comments
Post a Comment
Plz dont forget to like Facebook Page..
https://www.facebook.com/pages/Sql-DBAcoin/523110684456757