{"id":4662,"date":"2021-08-03T09:04:59","date_gmt":"2021-08-03T08:04:59","guid":{"rendered":"http:\/\/dasini.net\/blog\/?p=4662"},"modified":"2021-08-16T14:04:55","modified_gmt":"2021-08-16T13:04:55","slug":"discovering-mysql-database-service-episode-1-introduction","status":"publish","type":"post","link":"https:\/\/dasini.net\/blog\/2021\/08\/03\/discovering-mysql-database-service-episode-1-introduction\/","title":{"rendered":"Discovering MySQL Database Service – Episode 1 – Introduction"},"content":{"rendered":"\n

MySQL<\/a>, the world’s most popular open source database<\/strong>, is available as a managed cloud service<\/strong> in Oracle Cloud Infrastructure<\/a><\/strong> (OCI<\/a><\/strong>) under the name of MySQL Database Service<\/a><\/strong> (MDS<\/a><\/strong>).<\/p>\n\n\n\n

MySQL Database Service is a fully managed cloud service, 100% Developed, Managed and Supported by the MySQL Team.<\/strong><\/p><\/blockquote><\/figure>\n\n\n\n

This is the first<\/span> episode of \u00ab\u00a0Discovering MySQL Database Service<\/a><\/em><\/strong><\/em><\/strong>\u00ab\u00a0, 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.<\/p>\n\n\n\n

Please also note that you can run this tutorial and thus try MySQL Database Service & the other Oracle Cloud Infrastructure services for free<\/span><\/strong> by starting your 30-day trial<\/a>.<\/p>\n\n\n\n

\"MySQL<\/figure><\/div>\n\n\n\n
\n

Planning episodes<\/h2>\n\n\n\n
  1. Introduction to the series Discovering MySQL Database Service<\/em><\/strong><\/a> <\/li>
  2. Create a compartment<\/a><\/li>
  3. Create a Virtual Cloud Network<\/a><\/li>
  4. Dump your MySQL data into an Object Storage bucket<\/a><\/li>
  5. Create a MySQL DB system from a MySQL Shell dump<\/a><\/li>
  6. Update the Private Subnet Security List<\/a><\/li>
  7. Use a Bastion SSH port forwarding session<\/a><\/li>
  8. Connect to MySQL Database Service Using MySQL Shell<\/a><\/li>
  9. Connect to MySQL Database Service Using MySQL Workbench<\/a><\/li>
  10. Connect to MySQL Database Service Using OCI Cloud Shell<\/a><\/li>
  11. MySQL Database Service Features Overview<\/li><\/ol>\n<\/div><\/div>\n\n\n\n

    <\/p>\n\n\n\n\n\n

    Episode 1 – Introduction<\/h1>\n\n\n\n

    Like any series, in this episode I’m going to give you some context and set up the characters. <\/p>\n\n\n\n\n\n

    Open Source Software<\/h2>\n\n\n\n

    As you may know, Open Source Software<\/a> has been mainstream in the enterprise for quite some time.
    Open Source usage still increases and it also drives innovation (you can read     this<\/a> and this<\/a><\/em>).
    This is particularly the case for Open Source Databases<\/span>, like MySQL<\/strong> obviously.<\/p>\n\n\n\n\n\n

    MySQL<\/h2>\n\n\n\n
    \"\"
    MySQL, The world\u2019s most popular open source database<\/figcaption><\/figure><\/div>\n\n\n\n

    MySQL has been around for a while now, take a look at this funny article<\/a>.<\/p>\n\n\n\n

    Most popular database (Jetbrains survey<\/em><\/strong><\/a> – Stackoverflow survey<\/em><\/strong><\/a>) means you’ll find experts, experienced DBA, skilled developers, tons of resources… to help you to grow your business.<\/p>\n\n\n\n

    Popular also means that MySQL is widely used and used in many industries that run various workloads.<\/p>\n\n\n\n

    \"\"<\/figure>\n\n\n\n

    MySQL is the ideal database if your use case is:<\/p>\n\n\n\n