You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by bl...@apache.org on 2014/01/24 03:14:25 UTC

git commit: TAJO-545: MySQLStore Documentation. (jaehwa)

Updated Branches:
  refs/heads/master 5828b752f -> a6d9cbe60


TAJO-545: MySQLStore Documentation. (jaehwa)


Project: http://git-wip-us.apache.org/repos/asf/incubator-tajo/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-tajo/commit/a6d9cbe6
Tree: http://git-wip-us.apache.org/repos/asf/incubator-tajo/tree/a6d9cbe6
Diff: http://git-wip-us.apache.org/repos/asf/incubator-tajo/diff/a6d9cbe6

Branch: refs/heads/master
Commit: a6d9cbe60b4f98f4f8452b319c496b734e9d3ad2
Parents: 5828b75
Author: blrunner <jh...@gruter.com>
Authored: Fri Jan 24 11:14:18 2014 +0900
Committer: blrunner <jh...@gruter.com>
Committed: Fri Jan 24 11:14:18 2014 +0900

----------------------------------------------------------------------
 CHANGES.txt                                     |  2 ++
 .../src/site/markdown/tajo-0.8.0-doc.md         | 33 ++++++++++++++++++++
 2 files changed, 35 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/a6d9cbe6/CHANGES.txt
----------------------------------------------------------------------
diff --git a/CHANGES.txt b/CHANGES.txt
index 731b815..f9b6fba 100644
--- a/CHANGES.txt
+++ b/CHANGES.txt
@@ -363,6 +363,8 @@ Release 0.8.0 - unreleased
 
   TASKS
 
+    TAJO-545: MySQLStore Documentation. (jaehwa)
+
     TAJO-526: HCatalogStore Documentation. (jaehwa)
 
     TAJO-535: Fix warnings in tajo-rpc. (jinho)

http://git-wip-us.apache.org/repos/asf/incubator-tajo/blob/a6d9cbe6/tajo-project/src/site/markdown/tajo-0.8.0-doc.md
----------------------------------------------------------------------
diff --git a/tajo-project/src/site/markdown/tajo-0.8.0-doc.md b/tajo-project/src/site/markdown/tajo-0.8.0-doc.md
index 1989e7b..ddc81e1 100644
--- a/tajo-project/src/site/markdown/tajo-0.8.0-doc.md
+++ b/tajo-project/src/site/markdown/tajo-0.8.0-doc.md
@@ -415,6 +415,39 @@ If you want to customize the catalog service, copy $TAJO_HOME/conf/catalog-site.
     * tajo.catalog.store.MemStore - this is the in-memory storage. It is only used in unit tests to shorten the duration of unit tests.
     * tajo.catalog.store.HCatalogStore - this storage class uses HiveMetaStore.
 
+### MySQLStore Configuration
+
+If you want to use MySQLStore, you must create database and user on mysql for tajo. 
+
+And then, you need to prepare mysql jdbc driver on host which can be ran TajoMaster. If you do, you should set TAJO_CLASSPATH variable in conf/tajo-env.sh with it as follows:
+
+```
+export TAJO_CLASSPATH=/usr/local/mysql/lib/mysql-connector-java-x.x.x.jar
+```
+
+Or you just can copy jdbc driver into $TAJO_HOME/lib.
+
+Finally, you should add the following config to *conf/catalog-site.xml* :
+
+```
+  <property>
+    <name>tajo.catalog.store.class</name>
+    <value>org.apache.tajo.catalog.store.MySQLStore</value>
+  </property>
+  <property>
+    <name>tajo.catalog.jdbc.connection.id</name>
+    <value><mysql user name></value>
+  </property>
+  <property>
+    <name>tajo.catalog.jdbc.connection.password</name>
+    <value><mysql user password></value>
+  </property>
+    <property>
+    <name>tajo.catalog.jdbc.uri</name>
+    <value>jdbc:mysql://<mysql host name>:<mysql port>/<database name for tajo>?createDatabaseIfNotExist=true</value>
+  </property>
+```
+
 ### HCatalogStore Configuration
 
 Tajo support HCatalogStore to integrate with hive. If you want to use HCatalogStore, you just do as follows.