{"id":4194,"date":"2021-01-19T11:18:21","date_gmt":"2021-01-19T10:18:21","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=4194"},"modified":"2021-01-19T11:38:05","modified_gmt":"2021-01-19T10:38:05","slug":"mysql-in-azure","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2021\/01\/19\/mysql-in-azure\/","title":{"rendered":"MySQL in Azure"},"content":{"rendered":"\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/Ikaria_Greece_by_Anastasia_Papachristopoulou.jpg\" alt=\"Ikaria Greece by Anastasia Papachristopoulou\" \/><\/figure>\n\n\n\n<p>Cloud computing is becoming more and more famous among the IT circles and it is growing super fast. Industries are charmed by its flexible character and the avoidance of having their own infrastructure. <br>An easy solution that offers automation on every field and they can scale up depending on the needs of each user and company.<\/p>\n\n\n\n<p>There are many Cloud providers, such as <a href=\"https:\/\/www.oracle.com\/cloud\/#:~:text=Oracle%20Cloud%20Infrastructure%20(OCI)%20is,integrated%20security%2C%20and%20serverless%20compute.\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Oracle Cloud Infrastructure\">Oracle Cloud Infrastructure<\/a>, <a href=\"https:\/\/azure.microsoft.com\/en-us\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"https:\/\/azure.microsoft.com\/en-us\/\">Microsoft Azure<\/a>, <a href=\"https:\/\/aws.amazon.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"https:\/\/aws.amazon.com\/\">Amazon Web Services<\/a>, etc&#8230; <br>In this article, we are going to see how to set up a <strong>MySQL Database instance on Microsoft Azure Cloud<\/strong>.<\/p>\n\n\n\n<p>At this point, it is important to clarify that we are going to set up MySQL as a Service (<a href=\"https:\/\/en.wikipedia.org\/wiki\/Platform_as_a_service\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Platform as a service\">PaaS<\/a>).<\/p>\n\n\n\n<p>So, before starting with the actual Database creation, we need:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>An Azure subscription, you may create a free Azure account that offers for the first month a $200&nbsp;credit and for the first year the most wanted services.<\/li><li>Have an available resource group.<\/li><li>Have specifically access for MySQL.<\/li><\/ul>\n\n\n\n\n\n<p>Let\u2019s sign in to Azure portal, <a href=\"https:\/\/portal.azure.com\/\">https:\/\/portal.azure.com\/<\/a> and you should see a screen like the following:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture1.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>We need to verify that we have the correct resources available for our subscription, in order to set up the MySQL DB:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>From Azure Portal, go to Subscriptions<\/li><li>Then, on Development Services and choose Resource Provider<\/li><li>Scroll down and check if Microsoft.DBforMySQL is registered<\/li><\/ul>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture2.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>If it is not registered, then click Register on the top left corner:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture3.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>Once the registration is completed, we are ready for creating our DB.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture4.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>To create the MySQL Database, we need to choose Azure Database for MySQL Servers:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture5.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>By clicking the Add option on the top left, we are presented with two options, as it can be shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture6.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\"><li><em><span style=\"text-decoration: underline\">Single Server<\/span><\/em>&nbsp;is a fully managed database service with minimal requirements for customizations of the database. The single server platform is designed to handle most of the database management functions such as patching, backups, high availability, security with minimal user configuration and control. The architecture is optimized to provide 99.99% availability on single availability zone. Single servers are best suited for cloud native applications designed to handle automated patching without the need for granular control on the patching schedule and custom MySQL configuration settings. MySQL available version is <strong>8.0.15<\/strong><\/li><li><em><span style=\"text-decoration: underline\">Flexible Server<\/span> (Preview)<\/em>&nbsp;is a fully managed database service designed to provide more granular control and flexibility over database management functions and configuration settings. In general, the service provides more flexibility and server configuration customizations compared to the single server deployment based on the user requirements. The flexible server architecture allows users to opt for high availability within a single availability zone and across multiple availability zones. Flexible servers also provide better cost optimization controls with the ability to start\/stop your server and burstable SKUs, ideal for workloads that do not need full compute capacity continuously. MySQL version is<strong> 5.7<\/strong> and <strong>8.0.21<\/strong> is on trial.<\/li><\/ul>\n\n\n\n\n\n\n\n<p>We choose Single Server for our start, and we are presented with the following screen:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture7.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture8.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>We need to set accordingly:<\/p>\n\n\n\n<p><em><span style=\"text-decoration: underline\">Subscription<\/span><\/em>: Make sure that you have choosen the corresponding subscription<\/p>\n\n\n\n<p><em><span style=\"text-decoration: underline\">Resource Group<\/span><\/em>: Choose the proper resource group with the correct resources<\/p>\n\n\n\n<p><em><span style=\"text-decoration: underline\">Server name<\/span><\/em>: This is actually the name of the MySQL Server<\/p>\n\n\n\n<p><em><span style=\"text-decoration: underline\">Data Source<\/span><\/em>: You may create the new server from a Backup, here we choose none<\/p>\n\n\n\n<p><em><span style=\"text-decoration: underline\">Location<\/span><\/em>: Choose the proper location that your resource group has access to<\/p>\n\n\n\n<p><em><span style=\"text-decoration: underline\">Version<\/span><\/em> : Available versions 5.6,5.7 and 8.0<\/p>\n\n\n\n<p><em><span style=\"text-decoration: underline\">Compute+storage<\/span><\/em>: Choose the best settings, we have Basic , General Purpose and Memory Optimized. The basic differences are among Basic &amp; General Purpose\/Memory Optimized.<\/p>\n\n\n\n<p><strong>Basic <\/strong>offers 2 cores and storage up to 1024GB.<\/p>\n\n\n\n<p><strong>General Purpose<\/strong> offers up to 64 cores and storage up to 16384GB.<\/p>\n\n\n\n<p><strong>Memory Optimized<\/strong> offers up to 32 cores and storage up to 16384GB.<\/p>\n\n\n\n<p>All three available configurations offer Backup retention policy up to 35 days (default is 7 days).<\/p>\n\n\n\n<p><span style=\"text-decoration: underline\">General Purpose<\/span>: <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture9.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture10.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture11.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture12.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture13.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p><em><span style=\"text-decoration: underline\">Admin username<\/span><\/em>: Choose the proper name of the DB admin<\/p>\n\n\n\n<p><span style=\"text-decoration: underline\"><em>Password<\/em> and <em>Confirm Password<\/em><\/span> : Create a strong password for the DB admin<\/p>\n\n\n\n<p>As soon as these settings are ready, we go to the Next:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture15.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p><span style=\"text-decoration: underline\">Additional Settings<\/span>:<\/p>\n\n\n\n<p>We are able to select encryption:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture16.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>And then moving on:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture17.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p><em><span style=\"text-decoration: underline\">Tags<\/span><\/em> : are name\/value pairs that enable you to categorize and view consolidated billing by applying the same tag to multiple resources and resource groups. We won\u2019t be organizing our resources with tags now so we are moving on to Review&amp;Create to check the price and the options we have selected:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture18.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>While our DB is being created, we see its progress:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture19.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n\n\n<p>Once ready, we are able to access the new resource that we created :<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture20.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>From this page, we may stop the server, reset the password , restore\/delete and restart.<\/p>\n\n\n\n<p>From the left side-bar, we may create alerts\/metrics and to gather information. <br>The server logs are also available on this section, as well as the Replica option in case we need to set up a replica for our environment. <\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture22.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>Same for the server settings:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture21.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>One important note, before we connect officially to our Database. <br>We need to add the proper Firewall Rule to allow our Client to connect to the MySQL instance:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture23.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>In order to connect to the Database via <a href=\"https:\/\/www.mysql.com\/products\/workbench\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL Workbench\">MySQL Workbench<\/a> we need to use the Server name on the <em>Hostname<\/em> as well as the <em>Username<\/em>, like you may see on the following screenshot:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture24.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>Finally, we are connected to the Database and we are able to execute any query we wish:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture25.png\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>If you wish to delete the Database, Azure will give you a warning that the deletion is irreversible and you will need to provide MySQL Server\u2019s name.<\/p>\n\n\n\n\n\n\n\n<p>The same concept lies for the <strong>Flexible Server<\/strong>, but with a couple of differences:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture26.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture27.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>Here, we need to specify the expected Workload type and based on that the most appropriate settings are being recommended and we also have <em>Zone Redundancy<\/em> available :<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture28.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>Backups offer the same retention policy as in Single Server:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture29.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>To be able to connect, we need to set the Firewall Rules, either a specific Public address to access the Flexible MySQL Server or via a Virtual Network:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture30.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<figure class=\"wp-block-image\"><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/20210113_Azure_MySQL_picture31.jpg\" alt=\"Azure MySQL\" \/><\/figure>\n\n\n\n\n\n<p>Flexible Servers offers synchronous replication when Zone Redundancy is enabled, however it does not offer read-only replicas and due to synchronous replication to another availability zone, primary database server can experience elevated write and commit latency.<\/p>\n\n\n\n<p>We need to mention here that if a more updated version of MySQL is needed, then we will need to have a VM created.<\/p>\n\n\n\n\n\n\n\n<p><strong>Conclusion<\/strong><\/p>\n\n\n\n<p>Depending on your needs, Cloud computing can for sure serve them and most probably for a fair price. It offers a variety of services, so give it a try! <\/p>\n\n\n\n<p>After all, it is no coincidence that our heads are up in the clouds.<\/p>\n\n\n\n\n\n\n\n<p><strong>References<\/strong><\/p>\n\n\n\n<p><a href=\"https:\/\/www.mysql.com\/\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"MySQL - The world's most popular open source database\">https:\/\/www.mysql.com\/<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/select-right-deployment-type\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"Choose the right MySQL Server option in Azure\">https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/select-right-deployment-type<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/flexible-server\/concepts-high-availability\" target=\"_blank\" rel=\"noreferrer noopener\" title=\"High availability concepts in Azure Database for MySQL Flexible Server (Preview)\">https:\/\/docs.microsoft.com\/en-us\/azure\/mysql\/flexible-server\/concepts-high-availability<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we are going to see how to set up a MySQL Database instance on Microsoft Azure Cloud.<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"footnotes":""},"categories":[1648,1638,203],"tags":[1650,306],"class_list":["post-4194","post","type-post","status-publish","format-standard","hentry","category-azure","category-cloud","category-mysql-en","tag-azure","tag-cloud"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9LfWW-15E","jetpack-related-posts":[{"id":4662,"url":"https:\/\/dasini.net\/blog\/2021\/08\/03\/discovering-mysql-database-service-episode-1-introduction\/","url_meta":{"origin":4194,"position":0},"title":"Discovering MySQL Database Service &#8211; Episode 1 &#8211; Introduction","author":"Olivier DASINI","date":"3 ao\u00fbt 2021","format":false,"excerpt":"This is the first episode of \u201cDiscovering MySQL Database Service\u201c, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. Like any series, in this episode I\u2019m going to give you some context and set\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"MySQL Database Service","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4719,"url":"https:\/\/dasini.net\/blog\/2021\/08\/10\/discovering-mysql-database-service-episode-2-create-a-compartment\/","url_meta":{"origin":4194,"position":1},"title":"Discovering MySQL Database Service &#8211; Episode 2 &#8211; Create a compartment","author":"Olivier DASINI","date":"10 ao\u00fbt 2021","format":false,"excerpt":"This is the second episode of \u201cDiscovering MySQL Database Service\u201c, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. In the previous episode we've introduced the different components that we will use during this\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"MySQL Database Service","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":5139,"url":"https:\/\/dasini.net\/blog\/2021\/10\/05\/discovering-mysql-database-service-episode-10-connect-to-mysql-database-service-using-oci-cloud-shell\/","url_meta":{"origin":4194,"position":2},"title":"Discovering MySQL Database Service \u2013 Episode 10 \u2013 Connect to MySQL Database Service Using OCI Cloud Shell","author":"Olivier DASINI","date":"5 octobre 2021","format":false,"excerpt":"MySQL, the world\u2019s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastructure (OCI) under the name of MySQL Database Service (MDS). This is the tenth episode of \u201cDiscovering MySQL Database Service\u201c, a series of tutorials where I will show you, step by step,\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"MySQL Database Service","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4745,"url":"https:\/\/dasini.net\/blog\/2021\/08\/17\/discovering-mysql-database-service-episode-3-create-a-virtual-cloud-network\/","url_meta":{"origin":4194,"position":3},"title":"Discovering MySQL Database Service &#8211; Episode 3 &#8211; Create a Virtual Cloud Network","author":"Olivier DASINI","date":"17 ao\u00fbt 2021","format":false,"excerpt":"This is the third episode of \u201cDiscovering MySQL Database Service\u201c, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. In the previous episode we\u2019ve created our compartment, the foundation stone, of the architecture that\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"MySQL Database Service","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":4052,"url":"https:\/\/dasini.net\/blog\/2020\/12\/10\/create-a-cloud-backup-with-mysql-enterprise-backup\/","url_meta":{"origin":4194,"position":4},"title":"Create a Cloud Backup with MySQL Enterprise Backup","author":"Olivier DASINI","date":"10 d\u00e9cembre 2020","format":false,"excerpt":"Cloud backup is a strategy increasingly used in organizations. Send copies of your data to the cloud, can help you to prevent a devastating IT crisis and ensure business continuity. Currently, MySQL Enterprise Backup supports the following types of cloud storage services: - Oracle Cloud Infrastructure (OCI) Object Storage -\u2026","rel":"","context":"Dans &quot;Backup \/ Restore&quot;","block_context":{"text":"Backup \/ Restore","link":"https:\/\/dasini.net\/blog\/category\/backup-restore\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":4774,"url":"https:\/\/dasini.net\/blog\/2021\/08\/24\/discovering-mysql-database-service-episode-4-dump-your-mysql-data-into-an-object-storage-bucket\/","url_meta":{"origin":4194,"position":5},"title":"Discovering MySQL Database Service &#8211; Episode 4 &#8211; Dump your MySQL data into an Object Storage bucket","author":"Olivier DASINI","date":"24 ao\u00fbt 2021","format":false,"excerpt":"This is the fourth episode of \u201cDiscovering MySQL Database Service\u201c, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. In the previous episode we\u2019ve created our Virtual Cloud Network, that provides you with complete\u2026","rel":"","context":"Dans &quot;Cloud&quot;","block_context":{"text":"Cloud","link":"https:\/\/dasini.net\/blog\/category\/cloud\/"},"img":{"alt_text":"MySQL Database Service","src":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dasini.net\/blog\/wp-content\/uploads\/2021\/06\/MDS_car_801x600.png?resize=700%2C400&ssl=1 2x"},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/4194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/comments?post=4194"}],"version-history":[{"count":30,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/4194\/revisions"}],"predecessor-version":[{"id":4254,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/posts\/4194\/revisions\/4254"}],"wp:attachment":[{"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/media?parent=4194"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/categories?post=4194"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dasini.net\/blog\/wp-json\/wp\/v2\/tags?post=4194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}