Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Getting Started with MySQL Cloud Service

• About Oracle MySQL Cloud Service
• About MySQL Cloud Service Deployments
  • Computing Power
  • Database Storage
  • Automatic Backup Configuration
• Before You Begin with MySQL Cloud Service
• How to Begin with MySQL Cloud Service Subscriptions
• About MySQL Cloud Service Roles and Users
• Accessing MySQL Cloud Service Console
• Typical Workflow for Using MySQL Cloud Service
• About MySQL Cloud Service Deployments in Oracle Cloud Infrastructure

2 Managing the MySQL Cloud Service Life Cycle

• Creating a MySQL Server Deployment
• Creating a QuickStart Database Deployment
  • Enterprise Edition
• Creating a Cloned Instance from a Snapshot
• Viewing All MySQL Server Deployments
• Viewing Detailed Information for a MySQL Server Deployment
• Viewing Activities for MySQL Server Deployments in an Identity Domain
• Stopping, Starting and Restarting
• Rebooting a Compute Node
• Deleting a MySQL Server Deployment
• Tracking the Number of MySQL Server Deployments in an Account
• Creating and Managing IP Reservations
  • Creating an IP Reservation
  • Deleting an IP Reservation
• Creating and Managing Snapshots
• Managing Tags
  • Creating, Assigning, and Unassigning Tags
  • Finding Tags and Instances Using Search Expressions

3 Managing Network Access to MySQL Cloud Service

• About Network Access to MySQL Cloud Service
• Generating a Secure Shell (SSH) Public/Private Key Pair
  • Generating an SSH Key Pair on UNIX and UNIX-Like Platforms Using the ssh-keygen Utility
  • Generating an SSH Key Pair on Windows Using the PuTTYgen Program
• Creating an SSH Tunnel to a Compute Node Port
  • Creating an SSH Tunnel Using the ssh Utility on Linux
  • Creating an SSH Tunnel Using the PuTTY Program on Windows
• Enabling Access to a Compute Node Port

4 Administering MySQL Cloud Service

• Adding Storage to MySQL Cloud Service
• Scaling MySQL Cloud Service
• Updating or Adding a New SSH Public Key
• Maintaining the Manageability of Your Database Deployments
• Loading Data into the MySQL Database
• Tuning Database Performance on MySQL Cloud Service

5 Accessing MySQL Cloud Service

• Connecting to a Compute Node Through Secure Shell (SSH)
  • Connecting to a Compute Node Using the ssh Utility on UNIX and UNIX-Like Platforms
  • Connecting to a Compute Node Using the PuTTY Program on Windows

6 Backing Up and Restoring Databases on MySQL Cloud Service

• About Backing Up Databases on MySQL Cloud Service
• Creating an On-Demand Backup
  • Creating an On-Demand Backup by Using the MySQL Cloud Service Console
• Deleting a Backup
• Customizing the Current Backup Configuration
• Restoring from a Specific Backup
  • Restoring from a Specific Backup by Using the MySQL Cloud Service Console
• Restoring to a Specific Point in Time
  • Restoring to a Specific Point in Time by Using the MySQL Cloud Service Console
• Updating the Password for Backing Up to the Storage Cloud

7 Patching MySQL Cloud Service

• About Patching an Oracle MySQL Cloud Service Instance
• Checking Prerequisites Before Applying a Patch
  • Checking Patch Prerequisites
• Applying a Patch
  • Applying a Patch Using the MySQL Cloud Service Console
• Rolling Back a Patch
  • Rolling Back a Patch by Using the MySQL Cloud Service Console

8 Migrating MySQL Databases to MySQL Cloud Service

• Migrating MySQL Data

A Characteristics of a Newly Created Deployment

• Linux User Accounts
• Locations of Installed Software

B Oracle Cloud Pages for Administering MySQL Cloud Service

• MySQL Cloud Service Instances Page
• MySQL Cloud Service Activity Page
• MySQL Cloud Service SSH Access Page
• MySQL Cloud Service IP Reservations Page
• MySQL Cloud Service Overview Page
• MySQL Cloud Service Access Rules Page
• MySQL Cloud Service Backup Page
• MySQL Cloud Service Patching Page
• MySQL Cloud Service Snapshots Page
• Create MySQL Cloud Service: Service Page
• Create MySQL Cloud Service: Service Details Page
  • Create MySQL Cloud Service: Supported Timezones
• Create MySQL Cloud Service: Confirmation Page