Skip to main content

NineData Best Practices Directory

This directory collects NineData best practices for common database DevOps, data replication, migration, security, and enterprise data management scenarios.

Before you begin​

  • Identify the business outcome you want to achieve, such as centralized SQL access, safer change approval, real-time replication, or cross-cloud migration.
  • Make sure you have access to the NineData modules and data sources used by the best practice you want to follow.

How to Use This Directory​

Start with the section that matches your current goal, then open the related best practice documents for step-by-step guidance. For a new NineData rollout, review the Database DevOps basics first, then move to intermediate controls, advanced automation, and data replication scenarios.

Database DevOps Basics: Perfecting the Basic Environment and Unified Management​

Revoke all direct database connection accounts, requiring connection to databases through NineData

Enterprise personnel operating databases through direct connection accounts bring a series of risks, including abuse of permissions, sensitive data leakage, and difficulty in auditing. NineData provides a unified access entry, forcing users to access and manage databases only through NineData, enhancing data security and operational auditing capabilities.

Related Best Practice Documents:

Database DevOps Intermediate: Accessing and Managing Databases through Database DevOps​

Standards and Processes: NineData provides a complete set of database DevOps solutions, with rigorous SQL change standards and approval processes, helping enterprises efficiently complete data access and changes.

  • Design Phase: System administrators design SQL development standards on NineData, ensuring that user operations on the platform comply with unified standards. These standards will run through the entire database development and management lifecycle, forming standardization and automation.

  • Operation Phase: Developers attempt to directly change the database, are intercepted by the standards, and thus submit database change requests through SQL tasks. Change requests will be pre-reviewed by the system, then reviewed by DBAs or responsible persons for the change content, and can only be executed after all approvals.

Related Best Practice Documents:

Data Import and Export: NineData provides convenient data import and export functions, supporting various data sources. It also embeds rigorous approval processes to ensure data security and operational compliance.

Related Best Practice Documents:

Database Management: NineData offers powerful database management features, covering daily changes, performance monitoring, health checks, and more, helping enterprises simplify management processes and improve database operation efficiency.

Related Best Practice Documents:

Database DevOps Advanced: Enhancing Database Usage Efficiency through Database DevOps​

NineData provides a range of advanced database DevOps capabilities to further optimize enterprise efficiency and security in data management and usage.

Lock-Free Changes: NineData implements lock-free change technology, allowing OnlineDDL (table structure changes, index additions, or field adjustments), OnlineDML (batch execution of large data changes), and other operations to be completed without affecting business operations.

Related Best Practice Documents:

Batch Changes: NineData's batch database change supports unified modification and update operations on database structures or data, covering multiple data sources, databases, and tables, ensuring that data sources in a distributed environment can complete the same changes at the same time.

Related Best Practice Documents:

Data Generation: Efficient data generation tools help users simulate real data scenarios during development and testing, improving data validation and business simulation efficiency.

Related Best Practice Documents:

Data Archiving and Cleaning: Automated data archiving and cleaning tools can help enterprises optimize database performance, reduce storage costs, and ensure the traceability of historical data.

Related Best Practice Documents:

Structure Design and Release: Full lifecycle management of database structure design and release, from development to online, ensuring the correctness and efficiency of database structure changes.

Related Best Practice Documents:

Sensitive Data: Comprehensive sensitive data identification and protection features ensure that enterprises meet legal, regulatory, and industry standard compliance requirements when managing and using sensitive data, while preventing data leaks.

Related Best Practice Documents:

Data Replication​

NineData's data replication feature provides a comprehensive multi-source, multi-target data replication solution, supporting data synchronization across databases and environments to meet enterprise needs in data sharing, high-availability architecture, disaster recovery, and more.

Next Steps​

Open the best practice document that matches your scenario, then use the related product documentation links in that page to configure the required NineData features.