I have installed "Mysql Workbench 6.3 CE" on my windows 7 laptop, I have my Hadoop 3 node cluster setup on Amazon EC2 Instance. Now I want to import data from Mysql which is installed on my windows 7 laptop to my Hadoop Instance on Amazon EC2.
I have gone through this article:
Connect to remote mysql via terminal
the above article says :
Try to comment the bind-address = 127.0.0.1 in your /etc/mysql/my.cnf
C:\Program Files\MySQL\MySQL Server 5.7/my.ini
So the setup is something like this :
# Local notebook : Mysql server + Mysql workbench # AWS : EC2 Hadoop instance
And you want to EXPORT data from your local notebook to EC2 Hadoop?
I assume you want to do this (replace the indicator name with your own)
# 1. export your database table to a file # execute "mysqldump -u your_db_username -p your_dbname > dbname.sql" # 2. copy the file to ec2 hadoop instance # ssh copy to remote host "scp dbname.sql ubuntu@your_hadoop_ip -i your_hapoop_pem_key" # 3. ssh to your_hadoop_ip and do the import.
If you intend to connect FROM AWS EC2 to your LOCAL laptop, that is another story.
Short answer : Not your way. If you just want to put data to hadoop, use above export and import step.
Longer answer : you can create a temporary SSH reverse tunnel to allow the cloud EC2 server connect to your local notebook. It is tedious and you need good network knowledge to fix it if it doesn't work.
Here is an example : reverse ssh tunneling. This is not as easy because you need to know i. you notebook public IP address ii. Allow inbound for that inbound port inside VPC security group ,etc.