Document Feedback

Migrate data and resource units between tables

Last Updated： Updated

OceanBase Database

SQL - V4.0.0

Document overview
Overview
- Overview
- System architecture
- Compatibility with MySQL
- Limits
Get Started
- Quick experience
- Hands on for OceanBase SQL
  - Before you start
  - Basic SQL operations
- Create a sample application
  - Connect to OceanBase Database by using a Python driver
  - Connect to OceanBase Database by using Go MySQL Driver
  - Connect a Java application to OceanBase Database
  - Connect a C application to OceanBase Database
- Experience OceanBase advanced features
  - Experience scalable OLTP
    - Run the TPC-C benchmark test on OceanBase Database
    - Experience the hot row update capability of OceanBase Database
  - Experience operational OLAP
  - Experience parallel import and data compression
  - Experience the multitenancy feature
Develop
- Connect to Oceanbase Database with client
  - Overview
  - Connect to OceanBase Database by using a MySQL client
  - Connect to OceanBase Database by using OBClient
  - Connect to OceanBase Database by using ODC
  - Connect Java applications to OceanBase Database
  - Connect to OceanBase Database by using Go MySQL Driver
  - Connect to OceanBase Database by using Unix ODBC
  - C application
    - OceanBase Connector/C
    - C API functions
    - Connect C applications to OceanBase Database
  - Connect Python applications to OceanBase Database
  - SpringBoot connection example
  - SpringBatch connection example
  - SpringJDBC connection example
  - SpringJPA connection example
  - Hibernate connection example
  - MyBatis connection example
  - Example of Database connection pool configuration
    - Overview of database connection pool configuration
    - Example of configuring a Tomcat connection pool
    - Example of configuring a C3P0 connection pool
    - Example of configuring a Proxool connection pool
    - Example of configuring a HiKariCP connection pool
    - Example of configuring a DBCP connection pool
    - CommonPool configuration example
    - Example of configuring a JDBC connection pool
- Create and manage database objects
  - About DDL statements
  - View the currently connected database
  - Change the password of a user
  - Data type
    - General data types
    - Unsupported data types
  - Create and manage tables
    - About tables
    - Create a table
    - About auto-increment columns
    - About types of column constraints
    - About table structure modification
    - About table clearing
    - About table dropping
    - Flash back a dropped table
    - About table privileges
  - Create and manage partition tables
    - About partitioned tables
    - Create a partitioned table
    - Manage a partitioned table
    - Create a subpartitioned table
    - Manage a subpartitioned table
    - Partition routing
    - Indexes on partitioned tables
    - Suggestions on using partitioned tables
  - Create and manage indexes
    - About indexes
    - Create an index
    - Drop an index
  - Create and manage views
    - About views
    - Create a view
    - Modify a view
    - Delete a view
  - Create and manage sequences
    - About sequences
    - Create a sequence
    - Modify a sequence
    - Delete a sequence
- Query
  - About queries
  - Single-table queries
  - Conditional queries
  - ORDER BY queries
  - GROUP BY queries
  - Use the LIMIT clause in queries
  - Query data from multiple tables
    - About multi-table join queries
    - INNER JOIN queries
    - OUTER JOIN queries
    - Subqueries
  - Use operators and functions in a query
    - Use arithmetic operators in queries
    - Use numerical functions in queries
    - Use string connectors in queries
    - Use string functions in queries
    - Use datetime functions in queries
    - Use type conversion functions in queries
    - Use aggregate functions in queries
    - Use NULL-related functions in queries
    - Use the CASE conditional operator in queries
    - Use the SELECT FOR UPDATE statement to lock query results
  - Execution plan
    - View an execution plan
    - Understand an execution plan
  - Use SQL hints in queries
  - Variables of query timeout
- DML statements and transactions
  - DML statement
    - About DML statements
    - About the INSERT statement
    - UPDATE statements
    - About the DELETE statement
    - About the REPLACE INTO statement
  - Transactions
    - About transaction control statements
    - Start a transaction
    - Transaction savepoints
    - Commit a transaction
    - Roll back a transaction
    - About transaction timeout
- Common errors and solutions
  - About error codes
  - Database connection error
  - About timeout
    - Idle session timeout
    - Transaction timeout errors
  - About user
    - Locked user
    - Incorrect user password
  - About table
    - Table already exists
    - Table does not exist
    - Invalid use of NULL value
  - About constraint
    - Unique key conflict
    - Foreign key conflict
  - About SQL commands
    - Data truncation
Deploy
- Overview
- On-premises deployment
  - Software and hardware requirements
  - Configuration before deployment
  - Deploy OceanBase Database online
  - Deploy OceanBase Database offline
- Deploy OceanBase Database in a Kubernetes cluster
- High availability deployment
  - Use Alibaba Otter to implement remote active-active disaster recovery
Migrate
- Data Migration Overview
- Migrate data from MySQL Database to OceanBase
  - Use Canal to synchronize MySQL data to OceanBase Database in real time
  - Use DataX to migrate MySQL data to OceanBase Database
  - Use DBCAT to migrate MySQL table schemas to OceanBase Database
  - Migrate MySQL table schemas to OceanBase Database by using mysqldump
  - Migrate MySQL table data to OceanBase Database by using mysqldump
- Use OBDUMPER to export data from or OBLOADER to import data to OceanBase Database
- Migrate data from CSV-file to OceanBase
  - Use DataX to load CSV data files to OceanBase Database
  - Use the LOAD DATA statement to load CSV data files to OceanBase Database
- Migrate data from SQL files to OceanBase Database
- Migrate data and resource units between tables
- Migrate data from OceanBase Database to MySQL
  - Use Canal to synchronize OceanBase Database data to MySQL in real time