메뉴 건너뛰기

Bigdata, Semantic IoT, Hadoop, NoSQL

Bigdata, Hadoop ecosystem, Semantic IoT등의 프로젝트를 진행중에 습득한 내용을 정리하는 곳입니다.
필요한 분을 위해서 공개하고 있습니다. 문의사항은 gooper@gooper.com로 메일을 보내주세요.



1. mysql설치

root@master:/usr/local# apt-get install mysql-server

(404오류가발생시 https://www.gooper.com/ss/index.php?mid=bigdata&category=2772&document_srl=2995를 참조하여 조치후 설치한다)


Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libc-dev-bin libc6 libc6-dev libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl libnih-dbus1 libnih1 libplrpc-perl libterm-readkey-perl mysql-client-5.5
mysql-client-core-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
glibc-doc tinyca mailx
Recommended packages:
manpages-dev libhtml-template-perl
The following NEW packages will be installed:
libdbd-mysql-perl libdbi-perl libmysqlclient18 libnet-daemon-perl libplrpc-perl libterm-readkey-perl mysql-client-5.5 mysql-client-core-5.5 mysql-common mysql-server
mysql-server-5.5 mysql-server-core-5.5
The following packages will be upgraded:
libc-dev-bin libc6 libc6-dev libnih-dbus1 libnih1
5 upgraded, 12 newly installed, 0 to remove and 537 not upgraded.
1 not fully installed or removed.
Need to get 31.1 MB/31.2 MB of archives.
After this operation, 84.8 MB of additional disk space will be used.
Do you want to continue [Y/n]? Y
WARNING: The following packages cannot be authenticated!
libnih-dbus1 libnih1 libc6-dev libc-dev-bin libc6 mysql-common libmysqlclient18 libnet-daemon-perl libplrpc-perl libdbi-perl libdbd-mysql-perl mysql-client-core-5.5
libterm-readkey-perl mysql-client-5.5 mysql-server-core-5.5 mysql-server-5.5 mysql-server
Authentication warning overridden.
Get:1 http://old-releases.ubuntu.com/ubuntu/ raring/main libnih-dbus1 armhf 1.0.3-4ubuntu16 [15.1 kB]
Get:2 http://old-releases.ubuntu.com/ubuntu/ raring/main libnih1 armhf 1.0.3-4ubuntu16 [51.2 kB]
Get:3 http://old-releases.ubuntu.com/ubuntu/ raring-security/main libc6-dev armhf 2.17-0ubuntu5.1 [2216 kB]
Get:4 http://old-releases.ubuntu.com/ubuntu/ raring-security/main libc-dev-bin armhf 2.17-0ubuntu5.1 [69.0 kB]
Get:5 http://old-releases.ubuntu.com/ubuntu/ raring-security/main libc6 armhf 2.17-0ubuntu5.1 [3894 kB]
Get:6 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-common all 5.5.34-0ubuntu0.13.04.1 [13.3 kB]
Get:7 http://old-releases.ubuntu.com/ubuntu/ raring-security/main libmysqlclient18 armhf 5.5.34-0ubuntu0.13.04.1 [858 kB]
Get:8 http://old-releases.ubuntu.com/ubuntu/ raring/main libdbi-perl armhf 1.622-1 [846 kB]
Get:9 http://old-releases.ubuntu.com/ubuntu/ raring/main libdbd-mysql-perl armhf 4.021-1 [91.4 kB]
Get:10 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-client-core-5.5 armhf 5.5.34-0ubuntu0.13.04.1 [1740 kB]
Get:11 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-client-5.5 armhf 5.5.34-0ubuntu0.13.04.1 [7649 kB]
Get:12 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-server-core-5.5 armhf 5.5.34-0ubuntu0.13.04.1 [5370 kB]
Get:13 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-server-5.5 armhf 5.5.34-0ubuntu0.13.04.1 [8321 kB]
Get:14 http://old-releases.ubuntu.com/ubuntu/ raring-security/main mysql-server all 5.5.34-0ubuntu0.13.04.1 [11.5 kB]
Fetched 31.1 MB in 1min 9s (448 kB/s)
Preconfiguring packages ...

Package configuration


+-----------------------------------------+ Configuring mysql-server-5.5 +-----------------------------------------+
| While not mandatory, it is highly recommended that you set a password for the MySQL administrative "root" user. |
| |
| If this field is left blank, the password will not be changed. |
| |
| New password for the MySQL "root" user: |
| |
| ****_________________________________________________________________________________ |
| |
| <Ok> |
| |
+------------------------------------------------------------------------------------------------------------------+


+------+ Configuring mysql-server-5.5 +-------+
| |
| |
| Repeat password for the MySQL "root" user: |
| |
| ___________________________________________ |
| |
| <Ok> |
| |
+---------------------------------------------+

(Reading database ... 59905 files and directories currently installed.)
Preparing to replace libnih-dbus1:armhf 1.0.3-4ubuntu11 (using .../libnih-dbus1_1.0.3-4ubuntu16_armhf.deb) ...
Unpacking replacement libnih-dbus1:armhf ...
Preparing to replace libnih1:armhf 1.0.3-4ubuntu11 (using .../libnih1_1.0.3-4ubuntu16_armhf.deb) ...
Unpacking replacement libnih1:armhf ...
Preparing to replace libc6-dev:armhf 2.15-0ubuntu20 (using .../libc6-dev_2.17-0ubuntu5.1_armhf.deb) ...
Unpacking replacement libc6-dev:armhf ...
Preparing to replace libc-dev-bin 2.15-0ubuntu20 (using .../libc-dev-bin_2.17-0ubuntu5.1_armhf.deb) ...
Unpacking replacement libc-dev-bin ...
Preparing to replace libc6:armhf 2.15-0ubuntu20 (using .../libc6_2.17-0ubuntu5.1_armhf.deb) ...

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

Package configuration


+-------------------------------------------------------------------------+ Configuring libc6 +-------------------------------------------------------------------------+
| |
| xscreensaver and xlockmore must be restarted before upgrading |
| |
| One or more running instances of xscreensaver or xlockmore have been detected on this system. Because of incompatible library changes, the upgrade of the GNU libc |
| library will leave you unable to authenticate to these programs. You should arrange for these programs to be restarted or stopped before continuing this upgrade, to |
| avoid locking your users out of their current sessions. |
| |
| <Ok> |
| |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------+ Configuring libc6 +-------------------------------------------------------------------------+
| |
| There are services installed on your system which need to be restarted when certain libraries, such as libpam, libc, and libssl, are upgraded. Since these restarts |
| may cause interruptions of service for the system, you will normally be prompted on each upgrade for the list of services you wish to restart. You can choose this |
| option to avoid being prompted; instead, all necessary restarts will be done for you automatically so you can avoid being asked questions on each library upgrade. |
| |
| Restart services during package upgrades without asking? |
| |
| <Yes> <No> |
| |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------+ Configuring libc6 +-------------------------------------------------------------------------+
| Running services and programs that are using NSS need to be restarted, otherwise they might not be able to do lookup or authentication any more (for services such |
| as ssh, this can affect your ability to login). Please review the following space-separated list of init.d scripts for services to be restarted now, and correct it |
| if needed. |
| |
| Note: restarting sshd/telnetd should not affect any existing connections. |
| |
| Services to restart for GNU libc library upgrade: |
| |
| cron_________________________________________________________________________________________________________________________________________________________________ |
| |
| <Ok> |
| |
+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------+

Stopping some services possibly affected by the upgrade (will be restarted later):
cron: stopping...done.

Unpacking replacement libc6:armhf ...
Processing triggers for man-db ...
Setting up libc6:armhf (2.17-0ubuntu5.1) ...
Generating locales...
ko_KR.EUC-KR... done
Generation complete.
Checking for services that may need to be restarted...
Checking init scripts...
Restarting services possibly affected by the upgrade:
cron: restarting...done.

Services restarted successfully.
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
Selecting previously unselected package mysql-common.
(Reading database ... 59918 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.5.34-0ubuntu0.13.04.1_all.deb) ...
Selecting previously unselected package libmysqlclient18:armhf.
Unpacking libmysqlclient18:armhf (from .../libmysqlclient18_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Selecting previously unselected package libnet-daemon-perl.
Unpacking libnet-daemon-perl (from .../libnet-daemon-perl_0.48-1_all.deb) ...
Selecting previously unselected package libplrpc-perl.
Unpacking libplrpc-perl (from .../libplrpc-perl_0.2020-2_all.deb) ...
Selecting previously unselected package libdbi-perl.
Unpacking libdbi-perl (from .../libdbi-perl_1.622-1_armhf.deb) ...
Selecting previously unselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.021-1_armhf.deb) ...
Selecting previously unselected package mysql-client-core-5.5.
Unpacking mysql-client-core-5.5 (from .../mysql-client-core-5.5_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Selecting previously unselected package libterm-readkey-perl.
Unpacking libterm-readkey-perl (from .../libterm-readkey-perl_2.30-4build4_armhf.deb) ...
Selecting previously unselected package mysql-client-5.5.
Unpacking mysql-client-5.5 (from .../mysql-client-5.5_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Selecting previously unselected package mysql-server-core-5.5.
Unpacking mysql-server-core-5.5 (from .../mysql-server-core-5.5_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Processing triggers for man-db ...
Setting up mysql-common (5.5.34-0ubuntu0.13.04.1) ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 60296 files and directories currently installed.)
Unpacking mysql-server-5.5 (from .../mysql-server-5.5_5.5.34-0ubuntu0.13.04.1_armhf.deb) ...
Selecting previously unselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.5.34-0ubuntu0.13.04.1_all.deb) ...
Processing triggers for ureadahead ...
Processing triggers for man-db ...
Setting up libaio1:armhf (0.3.109-2ubuntu1) ...
Setting up libnih1:armhf (1.0.3-4ubuntu16) ...
Setting up libnih-dbus1:armhf (1.0.3-4ubuntu16) ...
Setting up libc-dev-bin (2.17-0ubuntu5.1) ...
Setting up libc6-dev:armhf (2.17-0ubuntu5.1) ...
Setting up libmysqlclient18:armhf (5.5.34-0ubuntu0.13.04.1) ...
Setting up libnet-daemon-perl (0.48-1) ...
Setting up libplrpc-perl (0.2020-2) ...
Setting up libdbi-perl (1.622-1) ...
Setting up libdbd-mysql-perl (4.021-1) ...
Setting up mysql-client-core-5.5 (5.5.34-0ubuntu0.13.04.1) ...
Setting up libterm-readkey-perl (2.30-4build4) ...
Setting up mysql-client-5.5 (5.5.34-0ubuntu0.13.04.1) ...
Setting up mysql-server-core-5.5 (5.5.34-0ubuntu0.13.04.1) ...
Setting up mysql-server-5.5 (5.5.34-0ubuntu0.13.04.1) ...
190519 12:11:16 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
mysql start/running, process 14399
Processing triggers for ureadahead ...
Setting up mysql-server (5.5.34-0ubuntu0.13.04.1) ...
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
localepurge: Disk space freed in /usr/share/locale: 0 KiB
localepurge: Disk space freed in /usr/share/man: 0 KiB
localepurge: Disk space freed in /usr/share/gnome/help: 0 KiB
localepurge: Disk space freed in /usr/share/omf: 0 KiB

Total disk space freed by localepurge: 0 KiB



2. reboot후 확인

hadoop@master:~$ mysql

Welcome to the MySQL monitor.  Commands end with ; or g.

Your MySQL connection id is 36

Server version: 5.5.34-0ubuntu0.13.04.1 (Ubuntu)


Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.


Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.


Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.


mysql> show databases;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| test               |

+--------------------+

2 rows in set (0.01 sec)


mysql> 

번호 제목 글쓴이 날짜 조회 수
197 solr 인스턴스 기동후 shard에 서버가 정상적으로 할당되지 않는 경우 해결책 총관리자 2016.04.29 653
196 collection생성시 -shards와 -replicationFactor값을 잘못지정하면 write.lock for client xxx.xxx.xxx.xxx already exists오류가 발생한다. 총관리자 2016.04.28 88
195 solrdf초기 기동시 "Caused by: java.lang.IllegalAccessError: tried to access field org.apache.solr.handler.RequestHandlerBase.log from class org.gazzax.labs.solrdf.handler.update.RdfUpdateRequestHandler" 오류가 발생시 조치사항 총관리자 2016.04.22 157
194 solrcloud에 solrdf1.1설치하고 테스트 하기 총관리자 2016.04.22 113
193 Spark 2.1.1 clustering(5대) 설치(YARN기반) 총관리자 2016.04.22 1880
192 Hadoop 완벽 가이드 정리된 링크 총관리자 2016.04.19 205
191 cumulusRDF 1.0.1설치및 "KeyspaceCumulus" keyspace확인하기 file 총관리자 2016.04.15 228
190 bin/cassandra -f -R로 startup할때 NullPointerException오류가 나면 조치할 내용 총관리자 2016.04.14 70
189 Cassandra 3.4(3.10) 설치/설정 (5대로 clustering) 총관리자 2016.04.11 397
188 딥러닝 수학/알고리즘 '한국어' 강의 총관리자 2016.04.10 110
187 서버 5대에 solr 5.5.0 설치하고 index data를 HDFS에 저장/search하도록 설치/설정하는 방법(SolrCloud) 총관리자 2016.04.08 654
186 서버 5대에 solr 5.5.0 설치하고 index data를 HDFS에 저장/search하도록 설치/설정하는 방법 총관리자 2016.04.08 54
185 failed to read local state, exiting...오류발생시 조치사항 총관리자 2016.04.06 141
184 elasticsearch 1.3.0에서 rdf및 hadoop plugin설치 총관리자 2016.04.06 108
183 Elastic Search For Hadoop 2.2.0설치하기(5대 클러스터링) 총관리자 2016.04.04 447
182 Incompatible clusterIDs오류 원인및 해결방법 총관리자 2016.04.01 481
181 namenode오류 복구시 사용하는 명령 총관리자 2016.04.01 372
180 "java.net.NoRouteToHostException: 호스트로 갈 루트가 없음" 오류시 확인및 조치할 사항 총관리자 2016.04.01 2984
179 bash는 PS1 변수를 통해 프롬프트의 모양을 바꿀 수 있다. 총관리자 2016.03.30 38
178 CentOS의 서버 5대에 yarn(hadoop 2.7.2)설치하기-ResourceManager HA/HDFS HA포함, JobHistory포함 총관리자 2016.03.29 1138

A personal place to organize information learned during the development of such Hadoop, Hive, Hbase, Semantic IoT, etc.
We are open to the required minutes. Please send inquiries to gooper@gooper.com.

위로