Pragmatic Works Nerd News

Intro to Azure Database for Maria DB

Written by Steve Hughes | Nov 25, 2019

If you’re thinking about migrating to an open source database, then you’ll want to know about Azure database for MariaDB. Azure Database for MariaDB is a relational database service in the Microsoft cloud.

Azure Database for MariaDB can help you rapidly develop your app and accelerate your time to market. You can also continue to develop your application by using the open-source tools and platform of your choice. Deliver with the speed and efficiency your business demands, all without learning new skills.

Today I’d like to talk about migrating MariaDB solutions. In the world of databases, I like to talk about the purpose and the platform. If you’re using Maria and you’re looking to move your full application suite, including the open source technologies, you may move all that over to Azure as well as MariaDB as it runs on the native platform.

  • The Purpose
    • To move your MariaDB solutions over to Azure in a meaningful way.
    • MariaDB is typically used for e-commerce and retail solutions often using the open source technology as part of the process.
  • The Platform
    • One thing to keep in mind about the open source database, it is a Platform as a Service (PaaS) option so it runs in Azure’s relational SQL database underlying platform that runs SQL Server, MySQL, PostgreSQL, and MariaDB.
    • This gives you things like high availability and built in backups, so you get more capability than most have in their open source technology space.
    • It runs on the community edition of MariaDB. Microsoft is not making custom versions of their open source database technologies, so if you’re running on the Community version and you pull it into Azure you’ve got platform consistency.
    • It supports elastic scaling, so you can scale it up or down easily.
    • Because it’s open source, Microsoft provides Azure IP Advantage which protects you in the case of patent laws that sometimes hit the open source community.
  • Cost
    • Comes in three pricing tiers: Basic, General and Memory Optimized.
    • Pricing separates storage from compute so you’re paying for V-core.
    • When you pay for each of those tiers you may get more out of the V-core than you would otherwise in the Memory Optimized.
    • You shouldn’t run any production workloads on Basic, but it is a great way to get used to and work with the platform.
    • Additional cost considerations: Re-replicas and threat protection costs extra but these are add-ons. You can add them to your technology base and still use Maria DB.

So the key points or advantages are this is great for MariaDB workloads and if you’re building something out that you choose to use Mari DB, this gives you an option to use this Platform as a Service and start off small and scale as you need to without having to purchase your own support platform. As a PaaS it will provide the Microsoft IP Advantage for open source work. Plus, it runs on the Community Edition. Finally, the pricing tiers with the V-core pricing model allow you to scale to your needs and your budget.

If you have questions about working with MariaDB, other database technology or anything in Azure, our experts have all the insight you’ll need in these areas. Click the link below or contact us to start a conversation – we’d love to help.