MyBase provides an instance management feature that allows you to manage your self-hosted, open-source MySQL 8.0 databases. This topic describes how to add an instance in the MyBase console and introduces the key features of instance management.
Billing
You can enable the instance management feature for free, and you will not be charged for using the basic features of MyBase to manage your self-built instances.
After integration, if you use advanced features or resources, you will be prompted to purchase the related paid items separately.
Features
Once your self-managed database is configured for management, you will have access to the following features.
Data management
After an instance is managed, it is automatically integrated with Data Management Service (DMS). This service is provided in a free mode. Its main features are as follows:
Visual data and structure management for database instances.
SQL Window: Supports manually writing SQL to perform single-database queries. This feature is suitable for scenarios such as data validation for code deployments, product performance data analysis, and troubleshooting and identifying online issues.
Cross-database query: Provides a timely federated query service for online heterogeneous data sources across different environments.
Data export: You can export up to 1 million rows of data.
Schema design: Supports schema change operations such as creating new tables and modifying tables.
Schema synchronization: You can compare table structures between different environments, such as testing and production environments, to ensure structural consistency between them.
Permission management: Regular users can request permissions for resources such as instances, databases, and tables.
Operation audit: Saves all data query and modification records, allowing you to query information such as database operation records, operators, and operation times at any time.
Performance monitoring
After an instance is managed, it automatically integrates with Database Autonomy Service (DAS) and CloudMonitor to monitor the performance of database instances and ECS instances, respectively. A free mode is currently available. The main features are as follows:
Problem diagnosis and performance optimization: Provides monitoring of database runtime status, problem diagnosis, and performance optimization suggestions to help you resolve common issues during daily operations.
Instance Connection and Management: Connect database instances to DAS and view their basic running status and monitoring metrics.
Host monitoring: Monitors metrics such as CPU, memory, disk, and network for an Alibaba Cloud host by using a plugin installed on the host, and provides an alerting feature for all monitored metrics. (Basic CloudMonitor provides a free quota. For more information, see Free Quota).
Data backup
The data backup feature performs full logical backups of your data at scheduled intervals based on your configurations. The backup process incurs fees that primarily depend on the specifications of the backup plan. For more information, see Backup methods and backup plan specifications.
For more information about backup operations for managed instances, see Data backup.
System Observation
After you install the system observation component, you can perform system observation and diagnosis in the console to help you locate kernel issues. The core features are as follows:
System diagnostics: Provides memory, storage, and network diagnostics, and generates diagnostic reports.
System observation: Supports process hotspot tracing and comparative hotspot analysis to help you diagnose process-level issues.
For more information, see What is the operating system console.
Session snapshot
The session snapshot feature periodically captures and records sessions based on your configuration, storing the results in OSS and incurring storage fees.
For more information about session snapshots of managed instances, see Session Snapshot.
Add an instance
Log on to the ApsaraDB for MyBase console.
In the left navigation bar, click Instance Management.
Click Add Instance.
In the Add Instance page, on the Register Database tab, configure the following parameters.
Parameters
Note
Instance Region
The region where the MySQL instance to be managed is located.
Instance Host
The ECS instance that hosts the MySQL instance to be managed.
Data Disk
The disk that stores MySQL data files is used for subsequent disk monitoring.
Instance Security Group
You must configure the security group for the ECS instance to allow tool components to access MySQL.
Database IP
The IP address required to access MySQL. The default value is the IP address of the ECS instance.
Database Port
The port for the MySQL service is 3306 by default.
Database account
The database user account must have remote access permissions.
Database password
Database user password
Instance Alias
An optional alias to distinguish between instances.
NoteIf you need to create a new database, you can also click the Create Database tab to purchase and create a database.
Click Submit.