Getting started with Managed Service for MySQL®
To get started with the service:
Before you start
Go to the management console. Then log in to Yandex.Cloud or sign up if you don't have an account yet.
If you don't have a folder yet, create one:
Click Create folder in the Home page of the management console.
Enter the folder name.
- Length — from 3 to 63 characters.
- The name may contain lowercase Latin letters, numbers, and hyphens.
- The first character must be a letter. The last character can't be a hyphen.
Select Create a default network. A network is created with subnets in each availability zone.
You can connect to DB clusters from both inside and outside Yandex.Cloud:
- To connect to a DB cluster from inside Yandex.Cloud, create a VM in the same cloud network as the DB cluster (with Linux or Windows).
- To be able to connect to the cluster from the internet, request public access to hosts when creating the cluster.
The next step assumes that you connect to the cluster from a Linux-based VM.
Connect to the VM via SSH.
Install the necessary dependencies and the MySQL client:
sudo apt update && sudo apt install -y mysql-client
Create a cluster
- In the management console, select the folder where you want to create a DB cluster.
- Select Managed Service for MySQL.
- Click Create cluster.
- Set the cluster parameters and click Create cluster. This process is described in detail in Creating MySQL clusters.
- When the cluster is ready, its status on the Managed Service for MySQL dashboard changes to Running and its state to Alive. This may take some time.
Connect to the DB
Configure security groups for the cloud network to enable all the relevant traffic between the cluster and the connecting host.
To connect to the DB server, get an SSL certificate:
Create a folder:
$ mkdir ~/.mysql
Get a certificate:
$ wget "https://storage.yandexcloud.net/cloud-certs/CA.pem" -O ~/.mysql/root.crt
Configure permissions to the certificate:
$ chmod 0600 ~/.mysql/root.crt
mysqlcommand to connect:
$ mysql --host=<host address> \ --port=3306 \ --ssl-ca=~/.mysql/root.crt \ --ssl-mode=REQUIRED \ --user=<name of database user> \ --password <DB name>