hypertable 알아볼꺄?

2012. 4. 7. 12:39 from Cloud/etc

Hadoop을 이용한 또다른 데이타베이스이다.  Hbase보다 성능이 좋다고 한다. HQL이라는 sql같은 명령어를 지원해준다. c++ API도 제공해준다. http://www.hypertable.org 개발하게된 내용의 블로그 http://blog.hypertable.com/?p=4 hbase와 성능 비교한 결과로, c++로 개발되어서 java도된 hbase보다 성능이 좋다고 한다. http://blog.hypertable.com/?p=14

설치 방법

wget http://cdn.hypertable.com/download/packages/0.9.5.0/hypertable-0.9.5.0-linux-x86_64.rpm
rpm -ivh hypertable-0.9.5.0-linux-x86_64.rpm


설치 화면

[root@xxxxx]# wget http://cdn.hypertable.com/download/packages/0.9.5.0/hypertable-0.9.5.0-linux-x86_64.rpm
--11:07:30--  http://cdn.hypertable.com/download/packages/0.9.5.0/hypertable-0.9.5.0-linux-x86_64.rpm
Resolving cdn.hypertable.com... 184.172.3.51
Connecting to cdn.hypertable.com|184.172.3.51|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 76510278 (73M) [text/plain]
Saving to: `hypertable-0.9.5.0-linux-x86_64.rpm'

100%[==================================================================>] 76,510,278  2.45M/s   in 37s    
11:08:08 (1.98 MB/s) - `hypertable-0.9.5.0-linux-x86_64.rpm' saved [76510278/76510278]

[root@xxxxx]# rpm -ivh hypertable-0.9.5.0-linux-x86_64.rpm
Preparing...                ########################################### [100%]
   1:hypertable             ########################################### [100%]



cd /opt/hypertable/0.9.5.0
[root@ucpbx 0.9.5.0]# ls 
bin  conf  examples  include  lib  Monitoring


mkdir /etc/opt/hypertable /var/opt/hypertab
#chown doug:staff /etc/opt/hypertable /var/opt/hypertable

/opt/hypertable/0.9.5.0/bin/fhsize.sh 

cd /opt/hypertable
ln -s 0.9.5.0 current

/opt/hypertable/current/bin/ht start all-servers local


/opt/hypertable/current/bin/ht shell
create namespace bar;
use bar;

create table foo ( c1, c2 );

show tables;
insert into foo values("001", "c1", "totally"), ("000", "c1", "Hypertable"), ("001", "c2", "awesome"), ("000", "c2", "is");

select * from foo;
drop table foo;

use "/";
drop namespace bar;

quit
/opt/hypertable/current/bin/ht stop-servers
 

hypertable> create namespace bar;
Elapsed time:  0.02 s
hypertable> use bar;

Elapsed time:  0.00 s
hypertable> 
hypertable> create table foo ( c1, c2 );

Elapsed time:  0.06 s
hypertable> 
hypertable> show tables;
foo

Elapsed time:  0.01 s
hypertable> 
hypertable> insert into foo values("001", "c1", "totally"), ("000", "c1", "Hypertable"), ("001", "c2", "awesome"), ("000", "c2", "is");

Elapsed time:  0.01 s
Avg value size:  6.50 bytes
   Total cells:  4
    Throughput:  298.78 cells/s
       Resends:  0
hypertable> 
hypertable> select * from foo;
000 c1 Hypertable
000 c2 is
001 c1 totally
001 c2 awesome

Elapsed time:  0.00 s
Avg value size:  6.50 bytes
  Avg key size:  4.00 bytes
    Throughput:  62407.13 bytes/s
   Total cells:  4
    Throughput:  5943.54 cells/s

hypertable> drop table foo;

Elapsed time:  0.02 s
hypertable> 
hypertable> use "/";

Elapsed time:  0.00 s
hypertable> drop namespace bar;

Elapsed time:  0.01 s

[root@ucpbx hypertable]# /opt/hypertable/current/bin/ht stop-servers
Killing ThriftBroker.pid 32248
Shutdown master complete
Sending shutdown command
Shutdown range server complete
Killing DfsBroker.local.pid 31825
Killing Hyperspace.pid 31824
Shutdown thrift broker complete
Shutdown DFS broker complete
Shutdown hyperspace complete
Shutdown hypertable master complete


DEVELOPER GUIDE

This page contains links to the Hypertable developer guide in each supported programming language.


Posted by 신공표 트랙백 0 : 댓글 0

댓글을 달아 주세요