Sign inSign up

stoneatom/stonedb

By stoneatom

•Updated about 3 years ago

StoneDB is a MySQL HTAP database developed by StoneAtom Technology Co.,Ltd.(https://stonedb.io)

Image
2

10K+

stoneatom/stonedb repository overview

⁠What is StoneDB

logo

StoneDB is a MySQL-compatible high-performance hybrid transaction/analytical processing (HTAP) database. It provides analytical processing (AP) abilities to MySQL. The running systems can be seamlessly migrated to StoneDB without any code changed. Compared to InnoDB, StoneDB provides 10 times the query performance as well as 10 times the load performance. StoneDB also provides 10:1 to 40:1 compression ratio.

StoneDB Github:https://github.com/stoneatom/stonedb⁠

⁠Quick Start

Make sure your CPU supports AVX

cat /proc/cpuinfo |grep avx

⁠1. Pull the image

Run the following command:

docker pull stoneatom/stonedb

⁠2. Run the image

Run the following command:

docker run -p 3306:3306 -itd -v $YOU_DATA_DIR:/opt -e MYSQL_ROOT_PASSWORD='$YOU_PASSWORD' stoneatom/stonedb

Altenatively, run the following command:

docker run -p 3306:3306 -itd  -e MYSQL_ROOT_PASSWORD='$YOU_PASSWORD'  stoneatom/stonedb

Parameter description:

 -p: maps ports in the Port of the host:Port of the container format.
 -v: mounts directories in the Path in the host:Path in the container format. If no directories ae mounted, the container will be initialized.
 -i: the interaction.
 -t: the terminal.
 -d: Do not enter the container upon startup. If you want to enter the container upon startup, run the  docker exec command.
 -e: Set environment variables,need MYSQL_ROOT_PASSWORD

⁠3. Log in to StoneDB in the container

# Obtain the Docker container ID.
docker ps
# Use the "docker ps" command to obtain the container ID and enter the Docker container.
docker exec -it <Container ID> bash
<Container ID>$ /opt/stonedb57/install/bin/mysql -uroot -p$YOU_PASSWORD

⁠4. Log in to StoneDB using a third-party tool

You can log in to StoneDB by using third-party tools such as mysql, Navicat, and DBeaver. The following code uses mysql as an example.

mysql -h<Host IP address> -uroot -p$YOU_PASSWORD -P<Mapped port of the host>

Tag summary

Content type

Image

Digest

sha256:9cb0fde6e…

Size

238 MB

Last updated

about 3 years ago

docker pull stoneatom/stonedb