MySQL and SQL Server: April 2017

[root@garey1 default.conf]# service cassandra stop
Shutdown Cassandra: OK
[root@garey1 default.conf]# cd /usr/local/
[root@garey1 local]# mkdir cassandra
[root@garey1 local]# mkdir cassandra/data
[root@garey1 local]# cp -r /var/lib/cassandra/data/* /usr/local/cassandra/data/
[root@garey1 local]# ls -lah /usr/local/cassandra/data/
total 36K
drwxr-xr-x. 9 root root 4.0K Apr 29 07:50 .
drwxr-xr-x. 3 root root 4.0K Apr 29 07:50 ..
drwxr-xr-x. 6 root root 4.0K Apr 29 07:50 demo
drwxr-xr-x. 3 root root 4.0K Apr 29 07:50 experiments
drwxr-xr-x. 24 root root 4.0K Apr 29 07:50 system
drwxr-xr-x. 6 root root 4.0K Apr 29 07:50 system_auth
drwxr-xr-x. 5 root root 4.0K Apr 29 07:50 system_distributed
drwxr-xr-x. 12 root root 4.0K Apr 29 07:50 system_schema
drwxr-xr-x. 4 root root 4.0K Apr 29 07:50 system_traces
[root@garey1 local]# chown -R cassandra:cassandra /usr/local/cassandra/data
[root@garey1 local]# ls -lah /usr/local/cassandra/data/
total 36K
drwxr-xr-x. 9 cassandra cassandra 4.0K Apr 29 07:50 .
drwxr-xr-x. 3 root root 4.0K Apr 29 07:50 ..
drwxr-xr-x. 6 cassandra cassandra 4.0K Apr 29 07:50 demo
drwxr-xr-x. 3 cassandra cassandra 4.0K Apr 29 07:50 experiments
drwxr-xr-x. 24 cassandra cassandra 4.0K Apr 29 07:50 system
drwxr-xr-x. 6 cassandra cassandra 4.0K Apr 29 07:50 system_auth
drwxr-xr-x. 5 cassandra cassandra 4.0K Apr 29 07:50 system_distributed
drwxr-xr-x. 12 cassandra cassandra 4.0K Apr 29 07:50 system_schema
drwxr-xr-x. 4 cassandra cassandra 4.0K Apr 29 07:50 system_traces
[root@garey1 local]# vim /etc/cassandra/default.conf/cassandra.yaml
find the key data_file_directories
data_file_directories:
- /var/lib/cassandra/data

and set to
data_file_directories:
- /usr/local/cassandra/data
[root@garey1 local]# service cassandra start

Cassandra 3.9

[root@garey-mysql2 ~]# yum install java-1.8.0-openjdk

Loaded plugins: fastestmirror

* updates: mirror.ehost.vn

Resolving Dependencies

--> Running transaction check

---> Package java-1.8.0-openjdk.x86_64 1:1.8.0.121-0.b13.el6_8 will be installed

。。。。

Dependency Installed:

giflib.x86_64 0:4.1.6-3.1.el6 java-1.8.0-openjdk-headless.x86_64 1:1.8.0.121-0.b13.el6_8 jpackage-utils.noarch 0:1.7.5-3.16.el6 libXfont.x86_64 0:1.5.1-2.el6

libfontenc.x86_64 0:1.1.2-3.el6 ttmkfdir.x86_64 0:3.0.9-32.1.el6 tzdata-java.noarch 0:2017a-1.el6 xorg-x11-font-utils.x86_64 1:7.2-11.el6

xorg-x11-fonts-Type1.noarch 0:7.2-11.el6

Complete!

[root@garey-mysql2 ~]# java -version

openjdk version "1.8.0_131"

OpenJDK Runtime Environment (build 1.8.0_131-b11)

OpenJDK 64-Bit Server VM (build 25.131-b11, mixed mode)

[root@garey-mysql2 ~]# vi /etc/yum.repos.d/datastax.repo

[datastax-ddc]

name = DataStax Repo for Apache Cassandra

baseurl = http://rpm.datastax.com/datastax-ddc/3.9

enabled = 1

gpgcheck = 0

[root@garey-mysql2 ~]# yum install datastax-ddc

Loaded plugins: fastestmirror

---> Package datastax-ddc-tools.noarch 0:3.9.0-1 will be installed

--> Finished Dependency Resolution

Dependencies Resolved

===========================================================================

Package Arch Version Repository Size

Installing:

datastax-ddc noarch 3.9.0-1 datastax-ddc 28 M

Installing for dependencies:

datastax-ddc-tools noarch 3.9.0-1 datastax-ddc 5.3 k

Transaction Summary

===========================================================================

(1/2): datastax-ddc-3.9.0-1.noarch.rpm | 28 MB 00:43

(2/2): datastax-ddc-tools-3.9.0-1.noarch.rpm | 5.3 kB 00:00

---------------------------------------------------------------------------------------------------------------------------

Total 658 kB/s | 28 MB 00:43

Installing : datastax-ddc-tools-3.9.0-1.noarch 1/2

Installing : datastax-ddc-3.9.0-1.noarch 2/2

Verifying : datastax-ddc-3.9.0-1.noarch 1/2

Verifying : datastax-ddc-tools-3.9.0-1.noarch 2/2

…….

Complete!

[root@garey-mysql2 ~]# service cassandra status

cassandra is stopped

[root@garey-mysql2 ~]# service cassandra start

Starting Cassandra: OK

[root@garey-mysql2 ~]# nodetool status

nodetool: Failed to connect to '127.0.0.1:7199' - ConnectException: 'Connection refused (Connection refused)'.

[root@garey-mysql2 ~]# vi /etc/hosts

[root@garey-mysql2 ~]# nodetool status

nodetool: Failed to connect to '127.0.0.1:7199' - ConnectException: 'Connection refused (Connection refused)'.

[root@garey-mysql2 ~]# find / -name cassandra.yaml

/etc/cassandra/default.conf/cassandra.yaml

[root@garey-mysql2 ~]# vi /etc/cassandra/default.conf/cassandra.yaml

Find rpc_address and set to

rpc_address: 127.0.0.1

[root@garey-mysql2 ~]# service cassandra restart

Shutdown Cassandra: bash: line 0: kill: (12030) - No such process

ERROR: could not stop cassandra: cassandra dead but pid file exists

Starting Cassandra: OK

[root@garey-mysql2 ~]# service cassandra status

cassandra (pid 12400) is running...

[root@garey-mysql2 ~]# nodetool status

Datacenter: datacenter1

=======================

Status=Up/Down

|/ State=Normal/Leaving/Joining/Moving

-- Address Load Tokens Owns (effective) Host ID Rack

UN 127.0.0.1 103.5 KiB 256 100.0% 56a87427-0ca2-4afe-97df-56bd9498b2bd rack1

[root@garey default.conf]# python -V

Python 2.6.6

Cassandra 3.9 need python 2.7 for cqlsh

yum install scl-utils

yum install centos-release-scl-rh

yum install python27

[root@garey default.conf]# python -V

Python 2.6.6

[root@garey default.conf]# scl enable python27 bash

[root@garey default.conf]# python -V

Python 2.7.8

[root@garey ~]# cqlsh -h

Traceback (most recent call last):

File "/usr/bin/cqlsh.py", line 167, in <module>

from cqlshlib import cql3handling, cqlhandling, pylexotron, sslhandling

ImportError: No module named cqlshlib

[root@garey ~]# pip install cqlsh

You are using pip version 7.1.0, however version 9.0.1 is available.

You should consider upgrading via the 'pip install --upgrade pip' command.

Collecting cqlsh

Downloading cqlsh-5.0.4.tar.gz (99kB)

100% |████████████████████████████████| 102kB 926kB/s

Collecting cql (from cqlsh)

Downloading cql-1.4.0.tar.gz (76kB)

100% |████████████████████████████████| 77kB 1.5MB/s

Collecting cassandra-driver (from cqlsh)

Downloading cassandra-driver-3.9.0.tar.gz (216kB)

100% |████████████████████████████████| 217kB 474kB/s

Collecting thrift (from cql->cqlsh)

Downloading thrift-0.10.0.zip (87kB)

100% |████████████████████████████████| 90kB 1.1MB/s

Collecting six>=1.6 (from cassandra-driver->cqlsh)

Downloading six-1.10.0-py2.py3-none-any.whl

Successfully built cqlsh cql cassandra-driver thrift

……

Successfully installed cassandra-driver-3.9.0 cql-1.4.0 cqlsh-5.0.4 futures-3.1.1 six-1.10.0 thrift-0.10.0

[root@garey ~]# cqlsh

Connection error: ('Unable to connect to any servers', {'127.0.0.1': ProtocolError("cql_version '3.3.1' is not supported by remote (w/ native protocol). Supported versions: [u'3.4.2']",)})

[root@garey ~]# cqlsh --cqlversion='3.4.2'

Connected to Test Cluster at 127.0.0.1:9042.

[cqlsh 5.0.1 | Cassandra 3.9.0 | CQL spec 3.4.2 | Native protocol v4]

Use HELP for help.

MySQL and SQL Server

Friday, 28 April 2017

Cassandra change data_file_directories

Cassandra create new super user and change default user password

Cassandra 3.9 installation