oceanbase/oceanbase-ce

Deploy OceanBase with Docker

Introduction

The oceanbase-ce Docker image, available on https://hub.docker.com/r/oceanbase/oceanbase-ce, https://quay.io/repository/oceanbase/oceanbase-ce and https://ghcr.io/oceanbase/oceanbase-ce, is designed for users to quickly set up an OceanBase environment for testing purposes.

Key ***ations:

• This image is intended for testing only; do not use it in production environments.
• The image supports the setup of a single-instance cluster only.
• This image is not designed for Kubernetes. For running containerized OceanBase on Kubernetes, refer to the https://github.com/oceanbase/ob-operator repository.

Prerequisites

Before deploying oceanbase-ce, ensure that the following requirements are met:

• The host machine should have at least 2 physical cores and 8GB of memory.
• Docker should be installed and running on the host machine. Refer to the https://docs.docker.com/get-docker/.

Starting an OceanBase Instance

To start an OceanBase instance, use one of the following docker run commands:

bash
# Deploy a mini mode instance
docker run -p 2881:2881 --name oceanbase-ce -d oceanbase/oceanbase-ce

# Deploy an instance to utilize the full resource of the container
docker run -p 2881:2881 --name oceanbase-ce -e MODE=normal -d oceanbase/oceanbase-ce

# Deploy an instance using fastboot mode
docker run -p 2881:2881 --name oceanbase-ce -e MODE=slim -d oceanbase/oceanbase-ce

# Execute init SQL scripts after bootstrap, do not change root user's password in SQL scripts.
# If you'd like to change root user's password, use variable OB_TENANT_PASSWORD.
docker run -p 2881:2881 --name oceanbase-ce -v {init_sql_folder_path}:/root/boot/init.d -d oceanbase/oceanbase-ce

The bootstrap procedure may take up to five minutes. Verify the bootstrap completion by running:

docker logs oceanbase-ce | tail -1

Expected output:

boot success!

Connecting to OceanBase Instance

Note:

• Users created in the instance via script use empty passwords by default.
• The default general non-sys tenant is 'test', so 'root@test' is used as the username.

For local connections using obclient or mysql client:

mysql -h127.0.0.1 -P2881 -uroot       # Connect with the root account of sys tenant
mysql -h127.0.0.1 -P2881 -uroot@test  # Connect with the root account of a general tenant

Supported Environment Variables

Below is a table of supported environment variables for the image:

Running Sysbench Script

The oceanbase-ce image includes the sysbench tool for benchmarking. Use the following command to run a sysbench test:

docker exec -it oceanbase-ce obd test sysbench obcluster

Data Persistence

By default, oceanbase-ce deploys OceanBase under /root/ob and saves its configurations under /root/.obd/cluster. Use the following command to persist data on the host:

mkdir -p ob
mkdir -p obd/cluster
docker run -d -p 2881:2881 -v $PWD/ob:/root/ob -v $PWD/obd/cluster:/root/.obd/cluster --name oceanbase oceanbase/oceanbase-ce

Fault Diagnosis

The enable_rich_error_msg parameter is enabled by default during Docker startup. If an error occurs, you can obtain detailed error information using the trace command.