MariaDB Community Server 11.7.2

MariaDB Community Server is a popular database management system; it is a fork of MySQL^®. The solution is being developed by an open community under the GNU GPL license and ensures a high degree of compatibility with MySQL^®.

1. Create a secret:

   1. Add a password for the superuser:

      • Key: For example, set it to root.
      • Value: Any value to use as a password.

   2. Add a password for the replication user:

      • Key: For example, set it to replication-user.
      • Value: Any value to use as a password.

2. Create a service account and assign it the lockbox.payloadViewer role.

   If using KMS key encryption for the secret, assign the kms.keys.decrypter role to the service account.

3. Create a cloud network with a subnet.

4. Create a security group in the cloud network and configure the rules as follows:

   Traffic direction	Description	Port range	Protocol	Source / Destination	CIDR blocks
   Ingress	MariaDB	3306	TCP	CIDR	0.0.0.0/0
   Ingress	SSH	22	TCP	CIDR	0.0.0.0/0
   Egress	Any Egress	0-65535	Any	CIDR	0.0.0.0/0

5. In our Marketplace, find MariaDB Community Server 11.7.2 and click Create VM on its page.

   1. Under Product configuration, do the following:

      • Select the host role in the cluster.
      • In the Superuser password field, select the ID of the previously created secret, version ID, and password key.
      • Specify the replication user name.
      • In the Replication user password field, select the ID of the previously created secret, version ID, and password key.
      • Enter the master host name.
      • Create and specify a Server ID, which is the instance ID.
        If you plan to include this instance in a cluster, the ID must be unique within that cluster.

   2. Under Disks and file storages, specify at least 25 GB as your disk size.

   3. Under Network settings, specify the cloud network, subnet, and security group you created earlier.

   4. Under Additional, specify the service account.

   5. Complete setting up your VM and click Create VM.

      Wait for the VM to be created and the application to be installed: this may take up to 10 minutes.

6. Connect to MariaDB via port 3306.

   For your connection, use a graphical client or a command-line client suitable for working with MySQL^®. Here is an example:

   mariadb -h <VM_public_IP_address> -P 3306 -u <username> -p
   

   Where:

   • -h: Public IP address of the VM where the product is deployed.
   • -u: Superuser or replication user name specified when creating the VM.

   The result after entering the password:

   Welcome to the MariaDB monitor.  Commands end with ; or \g.
   Your MariaDB connection id is 41
   Server version: 11.7.2-MariaDB-ubu2404-log mariadb.org binary distribution
   
   Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
   
   Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
   

• Storing and processing data for web applications.
• Organizing corporate and commercial databases.
• Developing and operating content management systems.
• Deploying high-load online services.
• Collecting and storing logs and analytical data.
• Working with business analytics systems.
• Scalable solutions for e-commerce.

Yandex Cloud technical support is available 24/7. The types of requests you can submit and the relevant response times depend on your pricing plan. You can switch to the paid support plan in the management console. You can learn more about the technical support terms and conditions here.