Are you sure you want to delete this task? Once this task is deleted, it cannot be recovered.
DandreChen 923c991772 | 1 year ago | |
---|---|---|
.github | 1 year ago | |
BUILD | 1 year ago | |
Docs | 1 year ago | |
client | 1 year ago | |
cmake | 1 year ago | |
dbug | 1 year ago | |
extra | 1 year ago | |
include | 1 year ago | |
libbinlogevents | 1 year ago | |
libbinlogstandalone | 1 year ago | |
libmysql | 1 year ago | |
libmysqld | 1 year ago | |
libservices | 1 year ago | |
man | 1 year ago | |
mysql-test | 1 year ago | |
mysys | 1 year ago | |
mysys_ssl | 1 year ago | |
packaging | 1 year ago | |
plugin | 1 year ago | |
rapid | 1 year ago | |
regex | 1 year ago | |
scripts | 1 year ago | |
sql | 1 year ago | |
sql-common | 1 year ago | |
storage | 1 year ago | |
strings | 1 year ago | |
support-files | 1 year ago | |
testclients | 1 year ago | |
unittest | 1 year ago | |
vio | 1 year ago | |
website | 1 year ago | |
win | 1 year ago | |
zlib | 1 year ago | |
.gitignore | 1 year ago | |
CMakeLists.txt | 1 year ago | |
CODE_OF_CONDUCT.md | 1 year ago | |
CONTRIBUTING.md | 1 year ago | |
Doxyfile-perfschema | 1 year ago | |
INSTALL | 1 year ago | |
LICENSE | 1 year ago | |
README | 1 year ago | |
README.md | 1 year ago | |
README_zh-hans.md | 1 year ago | |
VERSION | 1 year ago | |
config.h.cmake | 1 year ago | |
configure.cmake | 1 year ago |
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.
Overview
Architecture 2.0
For more information about StoneDB, see stonedb.io.
StoneDB welcomes all kinds of contributions, such as contributing code to the code base, sharing your experience on how to use StoneDB, and providing insights in the community on the Forums, or contributing to projects that make StoneDB a better project. For more specifics, see the contributing guide for more specifics.
The Getting Started part provides information about StoneDB supported platforms, installation (including creating your first table), and migrating from the running MySQL databases to StoneDB.
The officially supported subsets of platforms are:
Compiler toolsets we verify our builds with:
The following packages we verify our builds with:
For more information, see Compile StoneDB on Ubuntu 20.04.
For more information, see Compile StoneDB on CentOS 7.x.
For more information, see Compile StoneDB on RedHat 7.x.
For more information, see Compile StoneDB in a Docker Container.
After StoneDB is installed, you need to configure at least the following parameters in the my.cnf file:
#the stonedb configuration options are listed as following.
#for an example.
[mysqld]
# For version 5.7 or later, the engine should be set to tianmu
default-storage-engine=tianmu
# For version 5.6, the engine should be set to stonedb
# default-storage-engine=stonedb
default-tmp-storage-engine=MyISAM
binlog-format=STATEMENT
# For version 5.6
cd /path/to/your/path/bin && ./mysql_install_db --basedir=/stonedb/install/ --datadir=/stonedb/install/data/ --user=mysql
# For version 5.7 or later
cd /path/to/your/path/bin && ./mysqld --initialize --basedir=/stonedb/install/ --datadir=/stonedb/install/data/ --user=mysql
mysqld_safe --defaults-file=/path/to/my.cnf --user=mysql &
--The example code for creating a table with 'tianmu' engine.(For version 5.7 or later)
CREATE TABLE `example_table` (
`id1` bigint(20) NOT NULL DEFAULT '0',
`id1_type` int(10) NOT NULL DEFAULT '0',
`id2` bigint(20) NOT NULL DEFAULT '0',
`id2_type` int(10) NOT NULL DEFAULT '0',
`data` varchar(255) NOT NULL DEFAULT '',
`time` bigint(20) NOT NULL DEFAULT '0',
`version` int(11) NOT NULL DEFAULT '0',
) ENGINE=tianmu;
-- For version 5.6, the engine should be set to 'stonedb'
The example shows some important features and limitations in StoneDB. For more information about limitations, please see StoneDB Limitations.
If you want to use both InnoDB and StoneDB within the same instance to run a join query, set stonedb_ini_allowmysqlquerypath to 1 in file my.cnf.
Online migration tools to move data between storage engines are not currently developed, but you obviously want this to happen without downtime, data loss, or inaccurate results. To achieve this, you need to move data logically from the source MySQL server that uses the InnoDB engine and load it into StoneDB to do analytical processing. The detailed procedure is as follows:
SELECT … INTO OUTFILE
.LOAD DATA … INFILE
.Documentation can be found online at https://stonedb.io. The documentation provides you with StoneDB basics, extensive examples of using StoneDB, as well as other information that you may need during your usage of StoneDB.
The GitHub Discussions is the home for most discussions and communications about the StoneDB project. We welcome your participation. Every single opinion or suggestion of yours is welcomed and valued. We anticipate StoneDB to be an open and influential project.
You can add our little assistant's WeChat and join StoneDB's user group:
When participating in the StoneDB project, please ensure all your behavior complies with the Code of Conduct.
StoneDB 是由石原子科技公司自主设计、研发的国内首款基于 MySQL 内核打造的开源 HTAP(Hybrid Transactional and Analytical Processing)融合型数据库,可实现与 MySQL 的无缝切换。StoneDB 具备超高性能、实时分析等特点,为用户提供一站式 HTAP 解决方案。
C++ Text C JavaScript Java other
Dear OpenI User
Thank you for your continuous support to the Openl Qizhi Community AI Collaboration Platform. In order to protect your usage rights and ensure network security, we updated the Openl Qizhi Community AI Collaboration Platform Usage Agreement in January 2024. The updated agreement specifies that users are prohibited from using intranet penetration tools. After you click "Agree and continue", you can continue to use our services. Thank you for your cooperation and understanding.
For more agreement content, please refer to the《Openl Qizhi Community AI Collaboration Platform Usage Agreement》