-
Notifications
You must be signed in to change notification settings - Fork 86
Expand file tree
/
Copy pathREADME
More file actions
40 lines (31 loc) · 1.3 KB
/
Copy pathREADME
File metadata and controls
40 lines (31 loc) · 1.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
To build the software from source, consult the file INSTALL.
Brief Install Instructions:
1. Install the 3 Calpont infinidb RPMs or unpack the binary tar file into /usr/local.
2. Setup the software to run: /usr/local/Calpont/bin/install-infinidb.sh
3. Start the Database: service infinidb start
or /usr/local/Calpont/bin/infinidb start
4. Setup some aliases: . /usr/local/Calpont/bin/calpontAlias
5. Run the following upgrade script to create calponsys schema and upgrade the syscolumn table: /usr/local/Calpont/bin/upgrade-infinidb.sh
6. Connect to MySQL: idbmysql
7. As an example to get you started, try this:
create database calpont;
use calpont;
create table caltest (col1 int, col2 int) engine=infinidb;
show create table caltest;
set autocommit=0;
insert into caltest values (1, 2);
insert into caltest values (3, 4);
commit;
select * from caltest;
Note:
Examine the output of the show create table command carefully and
make sure the table is in fact a calpont table.
If the table is MyISAM type:
drop table caltest;
install plugin infinidb soname 'libcalmysql.so';
and retry the example.
To uninstall infinidb:
service infinidb stop
or /usr/local/Calpont/bin/infinidb stop
chkconfig --del infinidb
rm -rf /usr/local/Calpont