{"id":18458,"date":"2022-08-15T10:00:00","date_gmt":"2022-08-15T08:00:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=18458"},"modified":"2024-09-10T15:49:53","modified_gmt":"2024-09-10T13:49:53","slug":"mysql-server-on-microsoft-azure-1st-part-deployment","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/","title":{"rendered":"MySQL Server on Microsoft Azure 1st part (deployment)"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"293\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1024x293.png\" alt=\"\" class=\"wp-image-18459\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1024x293.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-300x86.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-768x220.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001.png 1345w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Let&#8217;s try Azure Database for MySQL <\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction<\/h2>\n\n\n\n<p>Did you know that you can run MySQL on Microsoft Azure for free for 30 days with a $200 credit? In this first blog I&#8217;ll show how to create a MySQL Server and provide few information related to this service. In futures blogs I&#8217;ll present insights regarding MySQL performances and backup\/recovery. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Let&#8217;s start by registering ourselves<\/h2>\n\n\n\n<p>The registration process lasts approximately 5 to 10 minutes. We simply have to enter our contacts details as well as our credit card details. Don\u2019t worry, no fees are automatically charged. Once your 200$ credit limit used, Microsoft will ask us if we want to keep on with the payment of the additional fees. &nbsp;<\/p>\n\n\n\n<p>In order to register ourselves on Microsoft Azure, we can simply go on the following URL: <a href=\"https:\/\/azure.microsoft.com\/en-us\/services\/mysql\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/azure.microsoft.com\/en-us\/services\/mysql\/<\/a> and click on &#8220;Try Azure Database for MySQL free&#8221; and  &#8220;Start free&#8221;. Then we enter our contact details such as country, name, surname, phone number, e-mail address, address, aso&#8230; Once finished, we will see a screen looking like the one below. We simply have to select the time zone and if we want to join a Q&amp;A session. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"778\" height=\"520\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-002.png\" alt=\"\" class=\"wp-image-18460\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-002.png 778w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-002-300x201.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-002-768x513.png 768w\" sizes=\"auto, (max-width: 778px) 100vw, 778px\" \/><figcaption>You&#8217;re ready to start with Azure!<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\">Our first MySQL Server on Azure<\/h2>\n\n\n\n<p>Once the registration process ended, it&#8217;s time to create our first MySQL Server on Azure. Log in into Microsoft Azure and enter \u201cmysql\u201d in the research field as shown below and select \u201cAzure Database for MySQL servers\u201d. &nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"273\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-003-1024x273.png\" alt=\"\" class=\"wp-image-18461\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-003-1024x273.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-003-300x80.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-003-768x205.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-003.png 1380w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Select &#8220;Azure Database for MySQL Server&#8221;<\/figcaption><\/figure>\n\n\n\n<p>Once &#8220;Azure Database for MySQL servers&#8221; selected, we simply have to click on &#8220;Create Azure Database for MySQL Server&#8221; on the next screen. We now have to select the deployment option. As shown below, we have the choice between the two following options: <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Flexible Server (Recommended)<\/li><li>Single Server<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-004-1024x658.png\" alt=\"\" class=\"wp-image-18462\" width=\"840\" height=\"539\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-004-1024x658.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-004-300x193.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-004-768x494.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-004.png 1237w\" sizes=\"auto, (max-width: 840px) 100vw, 840px\" \/><figcaption>Choice between Flexible server and Single Server<\/figcaption><\/figure>\n\n\n\n<p>In the context of this blog, I chose the first option (Flexible server). <\/p>\n\n\n\n<p>Before deploying our first MySQL Server we have to follow a straightforward process which requires 4 steps described below. As we will see, depending on the workload type retained (which will affect the CPU, memory and possible IOPS), the storage and IOPS, the monthly fees will vary between USD 18.98\/month and USD &gt;10&#8217;000\/month. <br><br>What is really nice is to be able to see in real time the influence that each parameter has on the price estimate on the right hand side as we can see in the screenshot below.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"761\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-005-1024x761.png\" alt=\"\" class=\"wp-image-18463\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-005-1024x761.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-005-300x223.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-005-768x571.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-005.png 1157w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>4 steps (in green) in order to complete your configuration<\/figcaption><\/figure>\n\n\n\n<ol class=\"wp-block-list\" type=\"1\"><li>Firstly, we have to enter basic information regarding our MySQL Server such as :<ul><li>Subscription details,<\/li><li>Server name<\/li><li>Region where you want to deploy your server<\/li><li>MySQL Version (version 5.x or 8.x)<\/li><li>Workload type (Small or Medium Size database, Tier 1 Business Critical Workloads, for development of hobby projects)<\/li><li>Compute+Storage: Compute options &#8211;  (Burstable 1-20 vCores, General purpose 2-64 vCores or Business Critical 2-96 vCores). Storage options &#8211; from 20GB up to 16384GB (no scale down possibility) and from 360 to 48000IOPS<\/li><\/ul><ul><li>Availability Zone (optional)<\/li><li>Enable High-Availability (optional)<\/li><li>Administrator account<br><br><\/li><\/ul><\/li><li>Secondly, we have to fill in networking information regarding our MySQL Server such as:<ul><li>Network Connectivity (connect to your server through a public IP address or a Private Access)<\/li><li>Firewall rules (you can automatically select your current IP address or allow any remote connection)<br><br><\/li><\/ul><\/li><li>Thirdly, we can enter tags. Tags are name\/value pairs that enable you to categorize and view consolidated billing by applying the same tag to multiple resources and resource groups.<br><br><\/li><li>We can finally review and create our server. Please note that we can also download a template for automation purpose.<\/li><\/ol>\n\n\n\n<p>In the compute option, you can select few options as presented below: <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"760\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-006-1024x760.png\" alt=\"\" class=\"wp-image-18464\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-006-1024x760.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-006-300x223.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-006-768x570.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-006.png 1287w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Compute + Storage options<\/figcaption><\/figure>\n<\/div>\n\n\n<p>Once all the the fields completed we can create our server. It&#8217;s interesting to see that we also have the possibility to generate a template for automation purpose. <\/p>\n\n\n\n<p>On the summary page, you can see that you have access to the<a href=\"https:\/\/azure.microsoft.com\/en-us\/support\/legal\/\" target=\"_blank\" rel=\"noreferrer noopener\"> Terms of Use<\/a> and <a href=\"https:\/\/privacy.microsoft.com\/en-us\/privacystatement\" target=\"_blank\" rel=\"noreferrer noopener\">Privacy Policy<\/a>. In the Terms of Use we can find a link to the <a href=\"https:\/\/azure.microsoft.com\/en-us\/support\/legal\/sla\/\" target=\"_blank\" rel=\"noreferrer noopener\">SLA Conditions<\/a> where we can find the guaranteed service time as well as the credit in case of non compliance with the SLA conditions. <\/p>\n\n\n\n<p>The deployment and start-up of the server takes approximately 6 minutes.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"901\" height=\"525\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-007.png\" alt=\"\" class=\"wp-image-18465\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-007.png 901w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-007-300x175.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-007-768x448.png 768w\" sizes=\"auto, (max-width: 901px) 100vw, 901px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">We have a server, let&#8217;s use it now!<\/h2>\n\n\n\n<p>In order to use our brand new MySQL Server, I decided to use MySQL Shell. MySQL Shell is a MySQL Client that provides scripting capabilities in JavaScript and Python. You can download MySQL Shell on this <a href=\"http:\/\/dev.mysql.com\/downloads\/shell\/.\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a> and find MySQL Documentation on this <a href=\"https:\/\/dev.mysql.com\/doc\/mysql-shell\/8.0\/en\/\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a>. <\/p>\n\n\n\n<p>When we run MySQL Shell on Windows, a cmd window opens with a command prompt as shown below. To connect to our MySQL Server, we can use the &#8220;<em>connect<\/em>&#8221; keyword. and then switch in sql mode with the &#8220;<em>\\sql<\/em>&#8221; command. <\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MySQL  JS &gt; \\connect --mysql albatroz.mysql.database.azure.com\nCreating a Classic session to 'grs@albatroz.mysql.database.azure.com'\nPlease provide the password for 'grs@albatroz.mysql.database.azure.com': *************\nSave password for 'grs@albatroz.mysql.database.azure.com'? &#091;Y]es\/&#091;N]o\/Ne&#091;v]er (default No): yes\nFetching schema names for autocompletion... Press ^C to stop.\nYour MySQL connection id is 20\nServer version: 8.0.28 Source distribution\nNo default schema selected; type \\use &lt;schema&gt; to set one.\n MySQL  albatroz.mysql.database.azure.com:3306 ssl  JS &gt; \\sql\nSwitching to SQL mode... Commands end with ;<\/code><\/pre>\n\n\n\n<p>Using <em>show variables like &#8216;%version%&#8217;<\/em>; command provides us few information regarding the MySQL version as well as the Operating System in use. Version 8.0.28 is not the latest version but it is not old either since it dates from December 2021 and at the time of writing this blog, the latest version is 8.0.30.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>MySQL  albatroz.mysql.database.azure.com:3306 ssl  SQL &gt; show variables like '%version%';\n+--------------------------+---------------------+\n| Variable_name            | Value               |\n+--------------------------+---------------------+\n| admin_tls_version        | TLSv1.2             |\n| immediate_server_version | 999999              |\n| innodb_version           | 8.0.28              |\n| original_server_version  | 999999              |\n| protocol_version         | 10                  |\n| replica_type_conversions |                     |\n| slave_type_conversions   |                     |\n| tls_version              | TLSv1.2             |\n| version                  | 8.0.28              |\n| version_comment          | Source distribution |\n| version_compile_machine  | x86_64              |\n| version_compile_os       | Linux               |\n| version_compile_zlib     | 1.2.11              |\n+--------------------------+---------------------+\n<\/code><\/pre>\n\n\n\n<p>After few tests, we can see some performance graphs (CPU and Memory, IO Percent, DB Connections and Queries) through the Azure interface. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"311\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-008-1024x311.png\" alt=\"\" class=\"wp-image-18466\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-008-1024x311.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-008-300x91.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-008-768x233.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-008.png 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption>Few graphs regarding performance<\/figcaption><\/figure>\n<\/div>\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>This first blog does not pretend to go into detail about the possibilities offered by Azure for the deployment of a MySQL server. It simply shows that deploying a MySQL server on the Azure Cloud is really simple. In addition, the $200 offered by Microsoft on the first 30 days of use allows you to have a first overview of the possibilities but also the costs related to a deployment in the Azure Cloud. The interface allows anyone to easily deploy a MySQL database in minutes.<\/p>\n\n\n\n<p>The next blog will discuss MySQL performance on the Azure Cloud through stress tests performed with SysBench.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction Did you know that you can run MySQL on Microsoft Azure for free for 30 days with a $200 credit? In this first blog I&#8217;ll show how to create a MySQL Server and provide few information related to this service. In futures blogs I&#8217;ll present insights regarding MySQL performances and backup\/recovery. Let&#8217;s start by [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":18469,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[3271,955,1316],"tags":[1583,2664],"type_dbi":[],"class_list":["post-18458","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-azure","category-cloud","category-mysql","tag-microsoft-azure","tag-mysql-3"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>MySQL Server on Microsoft Azure 1st part (deployment) - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL Server on Microsoft Azure 1st part (deployment)\" \/>\n<meta property=\"og:description\" content=\"Introduction Did you know that you can run MySQL on Microsoft Azure for free for 30 days with a $200 credit? In this first blog I&#8217;ll show how to create a MySQL Server and provide few information related to this service. In futures blogs I&#8217;ll present insights regarding MySQL performances and backup\/recovery. Let&#8217;s start by [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-15T08:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-10T13:49:53+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1345\" \/>\n\t<meta property=\"og:image:height\" content=\"385\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Gr\u00e9gory Steulet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gr\u00e9gory Steulet\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/\"},\"author\":{\"name\":\"Gr\u00e9gory Steulet\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"headline\":\"MySQL Server on Microsoft Azure 1st part (deployment)\",\"datePublished\":\"2022-08-15T08:00:00+00:00\",\"dateModified\":\"2024-09-10T13:49:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/\"},\"wordCount\":997,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png\",\"keywords\":[\"Microsoft Azure\",\"MySQL\"],\"articleSection\":[\"Azure\",\"Cloud\",\"MySQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/\",\"name\":\"MySQL Server on Microsoft Azure 1st part (deployment) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png\",\"datePublished\":\"2022-08-15T08:00:00+00:00\",\"dateModified\":\"2024-09-10T13:49:53+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png\",\"width\":1345,\"height\":385},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Server on Microsoft Azure 1st part (deployment)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\",\"name\":\"Gr\u00e9gory Steulet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"caption\":\"Gr\u00e9gory Steulet\"},\"description\":\"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \\\"Oracle Certified Professional 10g\\\", \\\"MySQL Cluster 5.1 Certified\\\", and \\\"Avaloq Certified Professional 2.6\\\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL Server on Microsoft Azure 1st part (deployment) - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/","og_locale":"en_US","og_type":"article","og_title":"MySQL Server on Microsoft Azure 1st part (deployment)","og_description":"Introduction Did you know that you can run MySQL on Microsoft Azure for free for 30 days with a $200 credit? In this first blog I&#8217;ll show how to create a MySQL Server and provide few information related to this service. In futures blogs I&#8217;ll present insights regarding MySQL performances and backup\/recovery. Let&#8217;s start by [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/","og_site_name":"dbi Blog","article_published_time":"2022-08-15T08:00:00+00:00","article_modified_time":"2024-09-10T13:49:53+00:00","og_image":[{"width":1345,"height":385,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png","type":"image\/png"}],"author":"Gr\u00e9gory Steulet","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gr\u00e9gory Steulet","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/"},"author":{"name":"Gr\u00e9gory Steulet","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"headline":"MySQL Server on Microsoft Azure 1st part (deployment)","datePublished":"2022-08-15T08:00:00+00:00","dateModified":"2024-09-10T13:49:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/"},"wordCount":997,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png","keywords":["Microsoft Azure","MySQL"],"articleSection":["Azure","Cloud","MySQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/","url":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/","name":"MySQL Server on Microsoft Azure 1st part (deployment) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png","datePublished":"2022-08-15T08:00:00+00:00","dateModified":"2024-09-10T13:49:53+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/08\/MySQLAzure-001-1.png","width":1345,"height":385},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/mysql-server-on-microsoft-azure-1st-part-deployment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL Server on Microsoft Azure 1st part (deployment)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098","name":"Gr\u00e9gory Steulet","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","caption":"Gr\u00e9gory Steulet"},"description":"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \"Oracle Certified Professional 10g\", \"MySQL Cluster 5.1 Certified\", and \"Avaloq Certified Professional 2.6\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18458","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=18458"}],"version-history":[{"count":3,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18458\/revisions"}],"predecessor-version":[{"id":18483,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/18458\/revisions\/18483"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/18469"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=18458"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=18458"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=18458"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=18458"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}