Updated on 2023-10-16 GMT+08:00

Statement of Work (SOW)

Service Overview

Database Consultancy Service provides professional consulting services including database design and risk assessment, and database skill training to help you make the most of your databases.

Service Content

Select a sub-service as required.

Service

Sub-Service

Description

Database architecture design

Architecture design consulting

  • For the service systems to be rolled out, we provide consulting services including architecture design, distributed deployment and high availability deployments, and disaster recovery solutions.
  • When you roll out various service systems, we analyze your systems and database architecture to identify risks and performance bottlenecks and design long- and short-term solutions accordingly.

Cloud database risk assessment

Bottleneck analysis and resolution

We position, analyze, and assess your databases based on resource environments, database architecture design, system loads, and security to avoid potential bottlenecks and minimize risks.

Cloud database emergency response

Performance tuning

We locate and analyze causes of poor database performance based on systems, resource environments, database architecture design, and system loads, and provide targeted optimization and expansion solutions.

Data restoration

We provide technical support for recovering lost data based on system environments and collected logs.

Disaster recovery solutions

We analyze your environment, recover unavailable databases, and provide HA reconstruction solutions for disaster recovery based on the assessment of application scenarios.

Database migration consulting

Migration solutions

We help you prepare service architecture and data migration solutions. We provide technical support where it's needed.

Migration analysis

We collect source database information such as character sets and objects, analyze compatibility between source and target databases, estimate migration workloads, and recommends different types of target databases with specific specifications.

Database skills package

Basic package

We give you a better understanding of RDS for MySQL, RDS for PostgreSQL, or Document Database Service (DDS), including tables, indexes, DDL operations, DML operations, and SELECT queries. One basic package only introduces one DB engine.

RDS for MySQL:

  1. Elementary configuration
  2. Tables and indexes
  3. DDL and DML operations
  4. SELECT statements
  5. Transactions and locks
  6. High availability
  7. Best practices of cloud migration

  

RDS for PostgreSQL:

  1. Elementary configuration
  2. Common operations
  3. Backup and restoration
  4. High availability
  5. O&M and monitoring
  6. Plug-in management
  7. Best practices

  

DDS (fully compatible with MongoDB):

  1. MongoDB overview
  2. MongoDB basics
  3. MongoDB index usage and principles
  4. MongoDB authentication system
  5. MongoDB cluster
  6. MongoDB Oplog
  7. MongoDB high availability
  8. MongoDB transactions

Standard package

We teach GaussDB basics, including database performance tuning, transactions, and locks. One standard package only introduces one DB engine.

GaussDB(for MySQL):

  1. Database best practices
  2. Kernel features
  3. Transactions and locks
  4. Performance tuning

  

GaussDB:

  1. Architectures
  2. Auxiliary tools
  3. Migration capability
  4. High availability systems
  5. Suggestions on O&M development and design

Advanced package

We provide advanced GaussDB knowledge, including database transactions, locks, best practices of cloud migration, highly available and reliable database architectures, database migration solutions, and O&M monitoring. One advanced package only introduces one DB engine.

GaussDB(for MySQL):

  1. Routine database operations
  2. High-availability principles
  3. Intelligent O&M
  4. Best practices
  5. Kernel features
  6. Advanced SQL syntax
  7. Transactions and locks
  8. Performance tuning

  

GaussDB:

  1. Architectures
  2. Auxiliary tools
  3. Migration capability
  4. High availability systems
  5. O&M capabilities
  6. Development and design proposal
  7. Distributed transactions
  8. Distributed storage
  9. SQL tuning

Non-Covered Service Items

Database Consultancy Service is only responsible for the services that are specified in the contract or purchased through the official website. If you require non-covered service items, additional fees are charged. Non-covered Items include but are not limited to:

  • Traveling to other cities for work. Additional expenses for travel, accommodations, and communications will be billed.
  • Working beyond regular working hours as required by the customer (Note: Fees include overtime pay and subsidies).
  • Purchasing products from other companies or individuals.

Advantages

  • Technical experts with extensive database experience provide efficient and professional services.
  • Technical experts are skilled in MySQL, PostgreSQL, and GaussDB databases and can provide professional solutions based on specific service scenarios.

Benefits

  • Developers and DBAs can receive professional database training and hands-on practice to better understand and use their databases.
  • Database performance can be improved to better support the business growth.
  • Potential risks can be detected in advance to reduce risks and O&M costs.

Prerequisites

The customer must submit a request at least 3 working days in advance so that Huawei Cloud can evaluate customer requirements and arrange for the technical experts that will be involved.

Service Process

  1. Requirements confirmation
    • The customer submits a service request.
    • Huawei organizes experts to learn about and evaluate the customer's requirements.
    • Huawei confirms the service scope and delivery objectives with the customer.
  1. Solution design
    • The customer and Huawei sign a contract. (The customer needs to order and pay for database skills packages through Huawei Cloud official website and does not sign a contract).
    • Huawei proposes a solution based on the customer's requirements.
    • Huawei confirms the proposal with the customer and then formulates an official delivery plan.
  1. Service delivery
    • The project is initiated.
    • Huawei prepares project acceptance materials and deliverables.
  1. Service acceptance
    • The customer signs the Database Consultancy Service Acceptance Report or clicks the acceptance link on the official website.
    • The project has been accepted.

Division of Responsibility

The following responsibility matrix is for reference only and can be modified based on project requirements.

No.

Phase

Task

Huawei

Customer

1

Requirement confirmation

Analysis of service objectives and functions

S

R

Database information survey

S

R

O&M status survey

S

R

Environmental requirements

S

R

2

Solution design

Expert team set-up

R

S

Solution formulation

R

S

Solution verification

R

S

3

Service delivery

Service delivery

R

S

4

Service acceptance

Output of deliverables

R

S

Project acceptance report

S

R

R: Responsible; S: Support

  1. Huawei and the customer:
    • Come together to determine the objectives and scope of Huawei Cloud Database Consultancy Service.
    • Sign a contract. (The customer needs to order and pay for database skills packages through Huawei Cloud official website and does not sign a contract).
  1. The customer:
    • Provides accurate information about requirements and scenarios.
    • Focuses on meeting project delivery requirements and gathering feedback from management personnel and key service departments.
    • Arranges project principals to attend project meetings, interviews, and seminars.
    • Assists project members who work in the project team through the whole process or in each phase of the project, and organizes related surveys and discussions.
    • Provides a workplace for Huawei experts and the needed development environments, including the computers and networks.
    • Creates a Huawei Cloud account.
    • Reviews and confirms the service plan and deliverables provided by Huawei.
    • Provides market data involved in this project or available open-source data.
  1. Huawei
    • After receiving the customer's application, coordinates experts to provide consulting services remotely or on site.
    • Before providing services, prepares a service plan and a BOQ for the customer to confirm.
    • Provides services based on the service plan and creates the deliverables needed.
    • Provides the list of deliverables after services are all complete.

Acceptance Criteria

  1. Acceptance items

    Different deliverables are required for different services. These deliverables can be modified based on project requirements.

    Service Item

    Deliverable

    Cloud database emergency response

    Problem Analysis Report

    Cloud database risk assessment

    Database Running Status Report

    Database architecture design

    Architecture Design Solution

    Database migration consulting

    Database Migration Consultancy Report

    Database skills package

    Related packages

  2. Acceptance process
    1. Huawei produces project deliverables and performs a self-check. After the deliverables pass the check, Huawei submits an acceptance application.
    2. The customer reviews and signs for all deliverables that meet requirements. If the deliverables do not meet requirements, Huawei modifies them based on the comments provided and then resubmits for acceptance.
    3. Huawei modifies and resubmits deliverables to the customer for acceptance within five working days when review comments were received.
    4. The customer reports the comments to Huawei within five working days when the deliverables were received. The review can only be executed up to three times. If Huawei does not receive any written comments from the customer within five working days of submission, the deliverables are deemed to have been accepted.

Project Completion

After the acceptance, the customer signs the Database Consultancy Service Acceptance Report (including its electronic copy) or confirms the acceptance on the official website to finalize the project.