Suggestion to chapter "Tutorial: The Druid Cluster'

This chapter (http://druid.io/docs/latest/tutorials/tutorial-the-druid-cluster.html) doesn’t contain Setting up MySQL part, which will casue the failure of “start a coordinate node” with sql table not found.

Suggest to add up MySQL part, for example:

Download MySQL from http://dev.mysql.com/downloads/mysql/

cd MySQL/

tar xvf mysql-server_5.6.25-1ubuntu14.10_amd64.deb-bundle.tar

ls

libmysqlclient18_5.6.25-1ubuntu14.10_amd64.deb mysql-community_5.6.25-1ubuntu14.10_amd64.changes mysql-community-test_5.6.25-1ubuntu14.10_amd64.deb

libmysqlclient-dev_5.6.25-1ubuntu14.10_amd64.deb mysql-community-bench_5.6.25-1ubuntu14.10_amd64.deb mysql-server_5.6.25-1ubuntu14.10_amd64.deb

libmysqld-dev_5.6.25-1ubuntu14.10_amd64.deb mysql-community-client_5.6.25-1ubuntu14.10_amd64.deb mysql-server_5.6.25-1ubuntu14.10_amd64.deb-bundle.tar

mysql-client_5.6.25-1ubuntu14.10_amd64.deb mysql-community-server_5.6.25-1ubuntu14.10_amd64.deb mysql-testsuite_5.6.25-1ubuntu14.10_amd64.deb

mysql-common_5.6.25-1ubuntu14.10_amd64.deb mysql-community-source_5.6.25-1ubuntu14.10_amd64.deb

sudo dpkg -i mysql-common_5.6.25-1ubuntu14.10_amd64.deb

sudo dpkg -i mysql-community-server_5.6.25-1ubuntu14.10_amd64.deb

sudo dpkg -i mysql-server_5.6.25-1ubuntu14.10_amd64.deb

sudo dpkg -i mysql-community-client_5.6.25-1ubuntu14.10_amd64.deb

sudo dpkg -i libmysqlclient18_5.6.25-1ubuntu14.10_amd64.deb

mysql -uroot -proot (set the password as ‘root’ of root user during installing the mysql server).

create database druid CHARACTER
SET utf8 ;

create user druid identified by ‘druid’;

grant all privileges on druid.* to druid@"%" identified by “druid”;

After setting up mysql database, the coordinate node can create tables when they don’t exist, otherwise exceptions will be thrown.

I thought about this one a little bit, and filed https://github.com/druid-io/druid/issues/1556 to help get the community together on a solution to handle it. There definitely seems to be some lacking documentation regarding db dependent configuration needs, but it is not immediately clear to me the best way to capture these idiosyncrasies.

I could have sworn set up instructions for MySQL existed before… I am adding them back.

Just checked, this step was definitely in older tutorials and got removed at some point…

https://github.com/druid-io/druid/pull/1570/files fixes the problem.

Ah, I see what happened. We changed the tutorials to use Derby instead of MySQL. This is problematic as we now no longer have any setup steps for MySQL

So, according to http://druid.io/docs/0.8.0/tutorials/tutorial-the-druid-cluster.html, the information to set up mysql is still there. The latest docs no longer have this information as we changed the default metadata store for the tutorials.

I’ve added https://github.com/druid-io/druid/pull/1571/files to include this information

But in this page http://druid.io/docs/latest/tutorials/tutorial-loading-batch-data.html , there is a link of The Druid Cluster that implies how to set up Zookeeper and MySQL, but when click the link, we get nothing about setting up MySQL.
"

Set Up a Druid Cluster

To index the data, we are going to need an indexing service, a historical node, and a coordinator node.

Note: If Zookeeper and MySQL aren’t running, you’ll have to start them again as described in The Druid Cluster.

"

在 2015年7月29日星期三 UTC+8上午2:38:33,Fangjin Yang写道:

Hi, we will update that tutorial.