Skip to main content

NineData Best Practices Directory

This directory integrates NineData's directly applicable solutions based on real-world scenarios. Through this directory, you can build enterprise-level solutions from scratch.

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​

  1. 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:

  2. 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:

  3. 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.

  1. 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:

  2. 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:

  3. 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:

  4. 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:

  5. 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:

  6. 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.

Last updated on