Hadoop Hive local and remote MySQL database management mode installation manual

I. Environment Description

Mysql version: mysql-installer-community-5.5.27.1 32-bit

Mysql for Windows 7 32-bit: I installed the mysql database on my own Windows 7 laptop, the advantage is that it reduces the overhead and space used by the master server Load balancer of the Virtual Machine and allows you to use more resources of one machine. If your VM resources are insufficient, you can deploy them like this.

Linux ISO: CentOS-6.0-i386-bin-DVD.iso 32-bit

JDK version: "1.6.0 _ 25-ea"

Hadoop software version: hadoop-0.20.205.0.tar.gz

Hbase version: hbase-0.90.5

Hive version: hive-0.8.1.tar.gz

Ii. Considerations for Mysql Databases

1. The steps for installing the mysql database are skipped. The virtual machine network is set to host-only mode, and the firewall is disabled on both sides of the system. It is best to disable the 360 software in windows, which may affect communication.

Database User/password: root/root and hive/hive

Port: 3306

Mysqll service name: MySQL55

To install the MySQL server as a service. The MySQL Server can be automatically started when the system starts.

Currently, it is set not to start automatically when the operating system is started.

To start/Close the mysql database service command, you must start the service to operate the database.

Net start mysql net stop mysql

2. View Mysql version (note that V is capitalized)

3. log on to Mysql and log on from windows

4. Create a hive user in mysql and grant sufficient permissions

I am using a user who created the mysql workbench client software that comes with MySQL on windows.

Add Account: Add a user

Name: hive password hive

Limit Connectivity to Hosts Matching: % Percent indicates a wildcard, that is, you can log on from any client on a host that is not restricted to logon, if you enter an IP address, this user can only log on to the mysql database from the machine where the IP address is located.

Select all to grant all permissions.

Command method: Create user hive identified by hive;

Hadoop deployment Environment

Host Name	IP	Node name	Remarks
H1	192.168.2.102	Master	Namenode and jobtracker
H2	192.168.2.103	Slave1	Datanode and tasktracker
H4	192.168.2.105	Slave2	Datanode and tasktracker

1 2 3 4 5 Next Page