Getting started with Managed Service for MySQL®

To get started:

• Create a database cluster.
• Connect to the database.

Getting startedGetting started

1. Navigate to the management console and log in to Yandex Cloud or sign up if not signed up yet.

2. If you do not have a folder yet, create one:

   1. In the management console, in the top panel, click and select the cloud.

   2. To the right of the cloud name, click .

   3. Select Create folder .

      

   4. Give your folder a name. The naming requirements are as follows:

      • It must be from 2 to 63 characters long.
      • It can only contain lowercase Latin letters, numbers, and hyphens.
      • It must start with a letter and cannot end with a hyphen.

   5. Optionally, specify the description for your folder.

   6. Select Create a default network. This will create a network with subnets in each availability zone. Within this network, you will also have a default security group, within which all network traffic will be allowed.

   7. Click Create.

      

3. Assign the vpc.user role and the managed-mysql.editor role or higher to your Yandex Cloud account. These roles allow you to create a cluster.

   Note

   If you are unable to manage roles, contact your cloud or organization administrator.

4. You can connect to database clusters from both inside and outside Yandex Cloud:

   • To connect from inside Yandex Cloud, create a VM in the same cloud network as the database cluster (on Linux).
   • To connect to the Managed Service for MySQL® cluster from the internet, request public access to hosts when creating the cluster.

   Note

   The next step assumes that you are connecting to the Managed Service for MySQL® cluster from a Linux VM.

5. Connect to your VM over SSH.

6. Install the required dependencies and the MySQL® client:

   sudo apt update && sudo apt install -y mysql-client
   

Create a clusterCreate a cluster

1. In the management console, select the folder where you want to create your database cluster.
2. Go to Managed Service for MySQL.
3. Click Create cluster.
4. Specify your Managed Service for MySQL® cluster settings and click Create cluster. For more information, see Creating a cluster.
5. Wait until the Managed Service for MySQL® cluster is ready: its status on the Managed Service for MySQL® dashboard will change to Running and its state, to Alive. This may take some time.

Connect to the databaseConnect to the database

1. If you are using security groups for a cloud network, configure them to allow all relevant traffic between the Managed Service for MySQL® cluster and the connecting host.

2. To connect to the database server, get an SSL certificate:

   Linux (Bash)/macOS (Zsh)

   Windows (PowerShell)

   mkdir -p ~/.mysql && \
   wget "https://storage.yandexcloud.net/cloud-certs/CA.pem" \
        --output-document ~/.mysql/root.crt && \
   chmod 0600 ~/.mysql/root.crt
   

   The certificate will be saved to the ~/.mysql/root.crt file.

   mkdir $HOME\.mysql; curl.exe -o $HOME\.mysql\root.crt https://storage.yandexcloud.net/cloud-certs/CA.pem
   

   The certificate will be saved to the $HOME\.mysql\root.crt file.

   Your corporate security policies and antivirus software may block the certificate download. For more information, see FAQ.

3. Use the mysql command to connect:

   mysql --host=<MySQL®_host_name>.mdb.yandexcloud.net \
         --port=3306 \
         --ssl-ca=~/.mysql/root.crt \
         --ssl-mode=VERIFY_IDENTITY \
         --user=<username> \
         --password \
         <DB_name>
   

What's nextWhat's next

• Read about the service concepts.
• Learn more about creating a Managed Service for MySQL® cluster and connecting to a database.
• Check questions and answers.