Getting started with Managed Service for MySQL®
To get started with the service:
Getting started
-
Go to the management console
and log in to Yandex Cloud or sign up if not signed up yet. -
If you do not have a folder yet, create one:
-
In the management console
, select the appropriate cloud in the list on the left. -
At the top right, click
Create folder. -
Enter the folder name. The naming requirements are as follows:
- The name must be from 3 to 63 characters long.
- It may contain lowercase Latin letters, numbers, and hyphens.
- The first character must be a letter and the last character cannot be a hyphen.
-
(Optional) Enter a description of the folder.
-
Select Create a default network. This will create a network with subnets in each availability zone. Within this network, a default security group will be created, inside which all network traffic is allowed.
-
Click Create.
-
-
Make sure your account has the vpc.user role and managed-mysql.editor role or higher for creating a cluster.
-
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).
- 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-based VM.
-
Connect to the VM over SSH.
-
Install the required 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 Managed Service for MySQL cluster parameters and click Create cluster. For more information, see Creating clusters.
- 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 DB
-
If you are using security groups for a cloud network, configure them to enable all relevant traffic between the Managed Service for MySQL cluster and the connecting host.
-
To connect to the DB 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 is 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 is saved to the
$HOME\.mysql\root.crt
file. -
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 next
- Read about service concepts.
- Learn more about creating a Managed Service for MySQL cluster and connecting to the database.
- Read questions and answers.