nuodb的安装，试用

介绍
NuoDB发布可扩展的云关系型数据库 http://www.infoq.com/cn/news/2013/03/nuodb

1.下载

wget http://www.nuodb.com/latest/nuodb-1.0.1.linux.x64.tar.gz

 


2.解压，安装

 tar -zxvf nuodb-1.0.1.linux.x64.tar.gz
 cd nuodb-1.0.1.128.linux.x86_64/

 

[phoenix@ays1 nuodb-1.0.1.128.linux.x86_64]$ sudo ./run-quickstart
[sudo] password for phoenix:
[phoenix@ays1 nuodb-1.0.1.128.linux.x86_64]$ sudo ./run-quickstart
[sudo] password for phoenix:
Setting PATH to /home/phoenix/heming/nuodb-1.0.1.128.linux.x86_64/bin:/sbin:/bin:/usr/sbin:/usr/bin
Unable to find the NuoDB demo-archives directory, check that /var/opt/nuodb/demo-archives exists and is writable
Press [enter] to continue ....

[phoenix@ays1 nuodb-1.0.1.128.linux.x86_64]$ sudo mkdir -p /var/opt/nuodb/demo-archives
[phoenix@ays1 nuodb-1.0.1.128.linux.x86_64]$ sudo ./run-quickstart
Setting PATH to /home/phoenix/heming/nuodb-1.0.1.128.linux.x86_64/bin:/sbin:/bin:/usr/sbin:/usr/bin
This script sets up NuoDB processes and a sample database.

Starting up a database named: test
Checking for a valid version of java
Found java at: /usr/bin/java
Found compatible version of Java for NuoDB
Starting a NuoDB Broker
Waiting for NuoDB Broker to start...
Starting a NuoDB Storage Manager
Initializing a new archive: /var/opt/nuodb/demo-archives/test
Started: [SM] ays1.phoenix/192.168.1.111:9574 [ pid = 4270 ] ACTIVE
Starting a NuoDB Transaction Engine
Started: [TE] ays1.phoenix/192.168.1.111:39067 [ pid = 4321 ] ACTIVE
Creating Sample Quickstart Schema
Importing Sample Quickstart Data
Capturing Sample Quickstart Database to /tmp/quickstart_capture.txt
Use the 'restart' command with this file to restart the database

Starting NuoDB Web Console, access via: http://localhost:8080
Starting an interactive SQL session with nuosql
Domain name: "domain"
User: "quickstart", Password: "quickstart"

Database name: "test"

DBA Username: "dba", DBA Password: "goalie"

Start executing SQL commands at the SQL prompt, such as:

SQL> show hockey;
SQL> select * from hockey;

SQL>

 

登陆界面


 

http://192.168.1.111:8080
用户名:密码 domain:bird
管理首页


 

文档位置
http://www.nuodb.com/community/documentation.php
数据库操作
SQL> help
      ALTER DOMAIN            Change definition of a domain (not yet implemented)
      ALTER SEQUENCE          Change definition of a sequence
      ALTER TABLE             Change definition of a table
      ALTER TRIGGER           Change definition of a trigger
      ALTER USER              Change definition of a user
      AUTOCOMMIT              ON by default. If AUTOCOMMIT is specified as ON, the changes made by each statement are automatically committed as soon as the statement is run. To enable grouping of multiple data manipulation SQL commands into a single atomic transaction, specify AUTOCOMMIT OFF instead.
      COMMIT                  Commit the current transaction
      CREATE DATABASE         Use NuoDB Console or NuoDB Manager to create and drop databases; you cannot use the NuoDB SQL client for this purpose.
      CREATE DOMAIN           Define a new domain
      CREATE INDEX            Define a new index
      CREATE PROCEDURE        Return the exact string to use to recreate a stored procedure (Not Yet Implemented)
      CREATE ROLE             Define a new database role
      CREATE SCHEMA           Define a new schema
      CREATE SEQUENCE         Define a new sequence
      CREATE TABLE            Define a new table
      CREATE TRIGGER          Define a new trigger
      CREATE USER             Define a new database user account
      CREATE VIEW             Define a new view. Note limitations with SELECT.
      DELETE                  Remove table rows as specified by WHERE. See also TRUNCATE.
      DROP DATABASE           Use NuoDB Console to create and drop databases; you cannot use the NuoDB SQL client for this purpose.
      DROP DOMAIN             Remove a domain from the database
      DROP INDEX              Remove an index
      DROP PROCEDURE          Remove a specified procedure or function from storage
      DROP ROLE               Remove a role from the database
      DROP SCHEMA             Remove a schema
      DROP SEQUENCE           Remove a sequence
      DROP TABLE              Remove a table. See also TRUNCATE.
      DROP TRIGGER            Remove a trigger
      DROP USER               Remove a database user account
      DROP VIEW               Remove a view
      EXPLAIN                 Determine whether or not an index is used in processing a SELECT statement.
      GRANT                   Define access
      INSERT                  Create new rows in a table
      RELEASE                 Release a savepoint. See SAVEPOINT.
      RENAME TABLE            Rename one or more tables
      REPLACE                 Replace values in a table with new values
      REVOKE                  Remove access privileges
      ROLLBACK                Stop and end the current transaction.
      SAVEPOINT               Mark and name a point within a transaction to use with ROLLBACK and RELEASE.
      SELECT                  Retrieve rows from a table or view
      SET                     Set variables that define system behavior
      SHOW                    Display information about schemas, tables, domains, and status of AUTOCOMMIT isolation level.
      START TRANSACTION       Start a transaction block
      TRUNCATE                Empty a table
      UPDATE                  Update rows of a table
      UPGRADE                 Change or create tables and indexes. (NuoDB extension)
      USE                     Specify a schema as the default for the current connection to the NuoDB SQL client
SQL>

数据库管理界面