Skip to main content

Manage GaiaDB with NineData Database DevOps

NineData Database DevOps supports Baidu Cloud GaiaDB, a MySQL-compatible cloud-native relational database. After you add a GaiaDB data source to NineData, you can use the SQL Console, SQL development standards, approval workflows, sensitive data protection, slow query analysis, data import and export, and data archiving features.

Supported DevOps Capabilities​

NineData can help teams manage GaiaDB in the following areas:

Enterprise Data Governance​

Use SQL development standards, approval processes, and sensitive data protection to govern GaiaDB access and changes.

NineData Database DevOps overview

SQL Development Standards​

NineData provides SQL development rules for GaiaDB scenarios so teams can standardize database design and change behavior.

Configure SQL development standards for GaiaDB

Rule-Based SQL Console Controls​

After SQL rules are configured, NineData can intercept SQL Console statements that do not comply with the policy. For example, a rule can block SELECT * statements.

Intercept non-compliant SQL in SQL Console

Approval Process​

For statements that may affect production, require users to submit SQL tasks and complete intelligent precheck plus manual approval before execution.

Disable direct SQL Console changes

Submit a SQL task for GaiaDB changes

Sensitive Data Protection​

Configure sensitive columns for GaiaDB tables. Users without the required permission see masked values instead of original sensitive data.

Configure sensitive columns for GaiaDB

Masked sensitive data in GaiaDB

Visual GaiaDB Development​

Use NineData SQL Console as a visual GaiaDB client. The console supports object browsing, table structure design, non-table object management, and result-set editing.

View GaiaDB objects

Design GaiaDB table structure

Edit GaiaDB table structure

Manage GaiaDB non-table objects

Edit GaiaDB result sets

Slow Query Analysis And SQL Optimization​

NineData can collect GaiaDB slow queries, record slow SQL, and provide diagnostic suggestions such as index changes or table-structure adjustments. You can also apply SQL development standards so slow SQL analysis follows your team's rules.

Analyze GaiaDB slow queries

Data Import And Export​

Use NineData to export GaiaDB data to SQL, CSV, or Excel files. You can also import SQL, CSV, or Excel files into GaiaDB.

Export GaiaDB data

Import data into GaiaDB

Scheduled Data Archiving​

Use Data Archiving to move expired GaiaDB data to archive storage and clean the archived rows from the business database.

Create a GaiaDB archiving task

Configure GaiaDB archiving conditions

Execute a GaiaDB archiving task

Result​

After GaiaDB is added to NineData, teams can use one Database DevOps workflow for visual development, SQL governance, approval, auditing, import and export, slow query analysis, and scheduled data archiving.

Next Steps​