MySQL¶
In this article
Information
MySQL is a database management system. It is one of the most popular relational DBMS (database management systems) in the world and is widely used by both web developers and enterprises. MySQL has a simple and intuitive interface. It supports standard SQL (Structured Query Language) functions that allow you to efficiently work with data, create, modify, and manage databases.
MySQL. Key Features¶
- Relational model: It allows you to organize data into tables with specific relationships between them. It provides structured storage of information and the ability to run complex requests to retrieve the data you need.
- SQL language: MySQL supports the full set of SQL (Structured Query Language) features. You can perform "select, insert, update, and delete" operations with SQL.
- High performance: MySQL is optimized for multi-threading, allowing the efficient process of simultaneous requests.
- Stored procedures and triggers: They allow developers to create complex data processing logic directly in the database.
- Replication and fault tolerance: It allows you to create copies of the database and distribute the load between them. This improves data availability and ensures fault tolerance of the system. Replication also allows you to back up data and secure its safety.
- Full-Text Search: Built-in support for full-text search makes it easy to search and analysis of text data. This feature of MySQL allows you to perform complex requests based on keywords and phrases, as well as to rank search results.
- Scalability and support: MySQL can be deployed on multiple servers and integrated with distributed systems.
Deployment Features¶
| ID | Compatible OS | VM | BM | VGPU | GPU | Min CPU (Cores) | Min RAM (Gb) | Min HDD/SDD (Gb) | Active |
|---|---|---|---|---|---|---|---|---|---|
| 30 | Ubuntu 22.04 | + | + | + | - | 1 | 1 | - | Yes |
- Installation time is 15-20 minutes, including OS.
- The MySQL installation process includes several stages:
- Installation of the system;
- Adding repositories and GPG keys;
- Installing the MySQL package from the repository;
- Running and enabling autorun of the MySQL service.
- Opening port
3306/tcp.
Note
Unless otherwise specified, by default we install the latest release version of software from the developer's website or operating system repositories.
Getting started after deploying MySQL¶
A notification will be sent to the e-mail specified during registration that the server is ready for work after paying for the order. It will contain the IP address of the VPS, as well as the login and password for the connection.
Clients of our company manage the hardware in the server`s and API control panel — Invapi.
Note
For more information on the basic settings of MySQL, see documentation of the developers.
Ordering MySQL using the API¶
To install this software using the API, follow these instructions.