实方数据库(RubatoDB)
University of Alberta
上海实方软件
主页 ( Home ) | 文档 ( Documentation) | 下载 ( Downloads ) | Bug Report |
服务器数目 | 并发用户数 | tpmC | 每分钟事务处理数 |
1 | 25,000 | 28,935 | 65,761 | 4 | 85,000 | 105,572 | 240,618 | 8 | 160,000 | 184,524 | 419,372 | 16 | 325,000 | 363,759 | 828,725 |
服务器数目 | 每秒运算数量(以读为主) | 每秒运算数量(以写为主) |
1 | 15,000 | 15,000 | 4 | 54,000 | 52,000 | 12 | 160,000 | 150,000 |
服务器数目 | 数据导入(TB/小时 ) |
4 | 1-2 TB |
下面用几个简单的例子显示实方数据库的基本功能。详细介绍见《实方数据库系统使文档》.
CREATE TABLE item ( i_id INT PRIMARY KEY, i_quantity INT, i_data VARCHAR(1024) ) PARTITION BY GRID (s_w_id) TO 2 NODES WITH mod (2);
INSERT INTO item VALUES(1,66,’be cool’); INSERT INTO item VALUES(2,77,’so cool’); INSERT INTO item VALUES(3,88,’so far so good’); INSERT INTO item VALUES(4,99,’OK’);
查询: SELECT * FROM item;
i_id | i_quantity | i_data |
1 | 66 | Be cool |
2 | 77 | So cool |
3 | 88 | So far so good |
4 | 99 | OK |
查询: SELECT * FROM item WHERE i_id = 1;
i_id | i_quantity | i_data |
1 | 66 | Be cool |
查询: SELECT i_data FROM item WHERE i_id = 2;
i_data |
So cool |
更新: UPDATE item SET i_quantity=100 WHERE i_id = 2;
查询: SELECT * FROM item WHERE i_id = 2;
i_id | i_quantity | i_data |
2 | 100 | So cool |
Linux:~/RubatoDB_dist$ ./auto_installation.sh ------------------------------------------------------------------------- Please follow the on-screen instructions, step by step, to install RubatoDB (1) Pre-installation (2) Configuration (3) Check pre-conditions (4) Installation (5) Initialization (6) Start the server ------------------------------------------------------------------------- (1) Pre-installation Please read 3.1.1 Pre-installation of The Documentation of RubatoDB contained in RubatoDB_dist/docs/rubatodb.html Especially, make sure that the following facilities are supported 1.1 Installation and Configuration of Rsync on all servers, including This One RubatoDB server uses the rsync to communicate among all nodes, and thus the serve will not work at all without rsync installed and configured properly. 1.2 the limit on descriptors shall be at least 16384 Enter Y if the pre-installation 1.1 and 1.2 have been done: y Are you sure that the pre-installation 1.1 and 1.2 have been done: y ------------------------------------------------------------------------- (2) Configuration You will be asked in this step to enter the following information, including (2.1) the number of grids (2.2) the number of replication nodes per grid (2.3) the IP addresses and various sockets of each grid node (2.4) the installation directory of each grid node (2.5) the snapshot and log directories of each grid node (at this moment, it must be entered by editing the configuration file) Please note that a RubatoDB server consists of a few grids, and each grid consists of a few replication nodes. For example, you may configure the system with four (4) grid nodes and each grid node will have three (3) replications. In this case you have to specify the followings: (2.1) the number of grids: 4 (2.2) the number of replication nodes per grid: 3 (2.3) for each 4 x 3 = 12 nodes, specify the IP and sockets (2.4) for each 4 x 3 = 12 nodes, specify the installation directory (2.5) for each 4 x 3 = 12 nodes, specify the snapshot and log directories Please follow the on-screen instructions to enter the requited info for each and every replication node Enter Y if you are going to configure the server now: . . .