메뉴 건너뛰기

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> 

번호 제목 글쓴이 날짜 조회 수
101 로그 파일에 대해 Elasticsearch 사용하기 총관리자 2014.09.25 1127
100 호튼웍스 하둡을 검색엔진과 연동하는 방법과 아키텍쳐 총관리자 2014.09.25 1147
99 hadoop 기반 문서 검색 총관리자 2014.09.25 961
98 하둡 분산 파일 시스템을 기반으로 색인하고 검색하기 총관리자 2014.09.25 953
97 lateral view 예제 총관리자 2014.09.18 700
96 root가 localhost에서 mysql로 접근하지 못하는 경우의 해결방법(패스워드) 총관리자 2014.09.10 603
» mysql 5.5.34-0ubuntu0.13.04용 설치/진행 화면 총관리자 2014.09.10 702
94 apt-get install mysql-server수행시 "404 Not Found" 오류발생시 조치방법 총관리자 2014.09.10 1459
93 banana pi에 hive 0.13.1+mysql(metastore)설치 file 총관리자 2014.09.09 2412
92 원격지에서 zio공유기를 통해서 노트북의 mysql접속을 허용하는 방법 총관리자 2014.09.07 499
91 sqoop작업시 hdfs의 개수보다 더많은 값이 중복되어 oracle에 입력되는 경우가 있음 총관리자 2014.09.02 4107
90 java.util.NoSuchElementException발생시 조치 총관리자 2014.08.27 493
89 hadoop의 data디렉토리를 변경하는 방법 총관리자 2014.08.24 540
88 시스템날짜를 현재 정보로 동기화 하는 방법(rdate, ntpdate이용) 총관리자 2014.08.24 493
87 FAILED: IllegalStateException Variable substitution depth too large: 40 오류발생시 조치사항 총관리자 2014.08.19 1529
86 원보드 컴퓨터 비교표 file 총관리자 2014.08.04 414
85 외부 기기(usb, 하드)등 mount(연결)하기 총관리자 2014.08.03 550
84 데이타 제공 사이트 링크 총관리자 2014.08.03 509
83 lubuntu 호스트 네임변경 총관리자 2014.08.03 607
82 oozie 에서 sqoop action실행 에러 - 컬럼개수 차이 총관리자 2014.07.17 1009

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.

위로