In this article we will describe how to create a couple of EC2 instances and how to deploy ClusterControl on EC2.
We will use MySQL Cluster here, but the same steps are applicable to Galera and MySQL Replication.
We assume you already have an EC2 account.
We will not cover how you add extra disk capacity in this tutorial.
It looks like a lot but takes approximately 20 minutes to get a running Cluster.
Creating the Instances
After having logged in on the EC2 Console ( https://console.aws.amazon.com/ec2 ) the first screen you will see is the following.
Press Launch Instance and the following screen shows up:
We will be using "Launch Classic Wizard",so make sure it is selected.
Here you can also select an AMI to use. We strongly recommend that you chose a 64-bit AMI, for this exercise we use the Basic 64-bit Amazon Linux AMI (it is a Redhat inspired image, and uses RPMs to install software). If you prefer to use an Ubuntu AMI, you can press "Community AMIs" , and in the search box you can enter the AMI id ami-8eb584fa and then you will be presented with this AMI: 881935613136/ylastic-base-ubuntu-10.10-maverick-amd64-20110704-1604. Select that one if you want to use Ubuntu, you can also use various RighScale images as well. Just make sure that the "Root Device" says "EBS".
Finally, press "Continue"
In the next screen we chose the number of instances. We will create five m1.large instances (m1.micro does not work with MySQL Cluster), we specify also that we want the servers in the same availability group (here you have some more advanced options, perhaps have 50% of the nodes in availability zone A and the other 50% in availability zone B. For now we don't consider using more than one availability zone):
- 1 instance for ClusterControl
- 2 instances for Data Nodes
- 2 instances for SQL Nodes
Press "Continue".
Press "Continue".
Next we get to a screen where some other fine adjustments can be made. We will skip this part too.
Press "Continue".
Now we have to create a keypair. Here we have written 'severalnines', but you can give it basically any name you want. The keypair is used to login to the EC2 instances we are about to launch.
Press the "Create & Download your Key Pair" and save the keypair. We will soon copy the keypair, so remember where you put it!
Then press "Continue".
On the next screen we define the firewall, select the default security group (you can add more security rules later).
Press "Continue".
Finally, we are ready to launch the instances.
Press "Launch".
You will be presented with a new screen and just press Continue. You will now return to the EC2 Dashboard, and then press "Running Instances" (upper right). You will see the follow screen:
Select the instance on the top. In the lower frame (you will see Private IP Address):
The top instance we will use for ClusterControl. Click through the instances one at a time and record the PRIVATE IP addresses. Here is an example how we will layout MySQL Cluster nodes on the instances (the ip addresses will most likely be different in your setup):
10.202.58.20 - ClusterControl Server (also note the public DNS for this one, e.g, ec2-107-22-127-220.compute-1.amazonaws.com).
10.32.11.164 - Management Node 1
10.202.163.0 - Management Node 2
10.80.237.132 - Data Node 1
10.10.223.14 - Data Node2
10.32.11.164 - SQL Node 1
10.202.163.0 - SQL Node 2
Please note that the SQL Node (mysql server) is colocated with one management server, and that is perfectly fine.
At this stage we can go and select a Configurator: http://www.severalnines.com/resources/configurator
We will use the Cluster Configurator to setup a MySQL Cluster.
Preparations
Before we actually start using the Configurator we need to upload the keypair to the EC2 ClusterControl server.
Locate the severalnines.pem file you created and downloaded.
Put it in a good place e.g, in your home catalog for convenience, and do:
chmod 400 severalnines.pem
If using the Amazon AMI:
johan@goldfish:~$ scp -i severalnines.pem severalnines.pem ec2-user@ec2-72-44-55-2.compute-1.amazonaws.com:
The authenticity of host 'ec2-72-44-55-2.compute-1.amazonaws.com (72.44.55.2)' can't be established.
RSA key fingerprint is e0:cf:55:c4:d9:94:dc:80:c1:9b:f6:fe:5d:ea:3e:1d.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'ec2-72-44-55-2.compute-1.amazonaws.com,72.44.55.2' (RSA) to the list of known hosts.
severalnines.pem 100% 1696 1.7KB/s 00:00
Ubuntu AMI:
johan@goldfish:~$ scp -i severalnines.pem severalnines.pem ubuntu@ec2-72-44-55-2.compute-1.amazonaws.com:
The output should be the same as above.
If you can't connect with either ubuntu or ec2-user, then try root. Some AMIs uses this.
The user you can log in with to the instance is called the OS User. The OS User will be needed in the Configurator.
At this stage you have copied the keypair (the .pem file) to the home catalog on the ClusterControl Server. That is great, because now we can use this to ssh without password from the ClusterControl instance/server and all the other instances
Remember this:
If using Amazon AMI:
EC2 Keypair location /home/ec2-user/severalnines.pem
If using Ubuntu AMI:
EC2 Keypair location /home/ubuntu/severalnines.pem
Cluster Configurator
In the Cluster Configurator you will have to set (this is the same options you have to enter for any Configurator you use):
- Cloud Provider - select Amazon EC2
- OS : If you use
Amazon AMI select RHEL6
An Ubuntu AMI, then select Ubuntu - If prompted for Use RPM, select Yes (default) -- applies only to RHEL5/RHEL6.
- OS User:
Amazon AMI: enter ec2-user , without single quotes
Ubuntu: enter ubuntu - If you want to change passwords for the mysql database and the cmon (clustercontrol) user, then you should do it now. Please don't use strange characters like " or \ or $ (behavior is unknown/untested)
- System Memory (Data nodes): m1.large
On the next screen "Map nodes to hostnames, setting directories, and specifying EC2 keypair" you will need to add the ip addresses you recorded a couple of steps back.
Leave data directories and WWWROOT to the suggested values.
For the Keypair enter either:
/home/ec2-user/severalnines.pem
or (if using Ubuntu)
/home/ubuntu/severalnines.pem
When you have entered the IP addresses, press "Next".
You have now reached the screen "Configuration Files".
Enter your email address. Tick the box if you want to have emails from us on updates etc (sent about once per month).
Press "Generate Deployment Scripts".
You will get to a new page and the deployment package will be emailed to you.
Deploying
Copy the deployment package to the ClusterControl Server:
johan@goldfish:~$ scp -i severalnines.pem mysqlcluster-71-rpm.tar.gz ec2-user@ec2-72-44-55-2.compute-1.amazonaws.com:
# or
johan@goldfish:~$ scp -i severalnines.pem mysqlcluster-71.tar.gz ubuntu@ec2-72-44-55-2.compute-1.amazonaws.com:
Log in to the Cluster Control server:
johan@goldfish:~$ ssh -i severalnines.pem ec2-user@ec2-72-44-55-2.compute-1.amazonaws.com
# or
johan@goldfish:~$ ssh -i severalnines.pem ubuntu@ec2-72-44-55-2.compute-1.amazonaws.com
chmod 400 severalnines.pem
tar xfvz mysqlcluster-71-rpm.tar.gz
cd mysqlcluster-71-rpm/cluster/scripts/install
./deploy.sh
# answer yes on the questions and off you go!
Comments
66 comments
This worked fantastically guys! Thanks for making this tool - I was able to get a MySQL Cluster up and running on Amazon EC2 by following these instructions exactly. It was indeed about 20 minutes, much much less than it would have taken me to set it up manually.
Great post! I am actually getting ready to across this information, It’s very helpful for this blog.Also great with all of the valuable information you have Keep up the good work you are doing well.
https://www.besanttechnologies.com/training-courses/cloud-computing-training/amazon-web-services-training-institute-in-chennai
Outstanding blog thanks for sharing such wonderful blog with us ,after long time came across such knowlegeble blog. keep sharing such informative blog with us.
https://www.credosystemz.com/training-in-chennai/best-big-data-training-in-chennai/
Of course and why not! EC2 is one of the pillar stones of AWS. I guess at least 99% of EC2 instances running must be used by AWS customers only.
http://aptronnoida.in/best-amazon-web-services-aws-training-in-noida.html
machine learning training in noida
sap sd training in noida
data analytics training in noida
data science training in noida
hadoop training in noida
openstack training in noida
devops training in noida
This content is very much informative and very useful.keep posting.
Film Institutes in Chennai.
Find Latest Bollywood News and Celebrity Gossips News from Bollywood Industry.Stay tuned for more updates on breaking bollywood gossips, Movie Trailers, Reviews.
Thanks for your efforts in sharing this post with us. This was really awesome. kindly keep continuing the great work.
BRD Infotach
Thanks for sharing valuable information.
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> Digital Marketing training Course in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing training institute in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing training in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing course in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing course training in omr</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing certification in omr</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing course training in velachery</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing training center in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing courses with placement in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing certification in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing institute in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing certification course in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing course training in Chennai</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> Digital Marketing course in Chennai with placement</a>
<a href="https://www.credosystemz.com/courses/digital-marketing-training/"/> digital marketing courses in Chennai</a>
Hi Very Nice Blog I Have Read Your Post It Is Very Informative And Useful Thanks For Posting And Sharing With Us.
Over the years we have employed our skilled professionals to the service of thousands of customers around the world with high-class, magnificent and responsive services to help them enjoy a pleasant user experience as far as gadget performance is concerned. Due its relentless excellence in providing a superlative range of holistic services, we have achieved a cult status in our target market.
New Extender Setup
www.mywifiext.net ex6100
mywifiext.net ex2700
Hi Very Nice Blog I Have Read Your Post It Is Very Informative And Useful Thanks For Posting And Sharing With Us.
Carpet Cleaning Sunshine Coast | Carpet Cleaners Sunshine Coast
Thanks for sharing the information with us. Keep on updating us regularly.
Possum Removal Melbourne | Termite Control Melbourne
Amazing Content! Thank you, I’ve recently been looking for info about this topic for a long time and yours is the best I’ve come upon till now. I have a few suggestions about the play school in Chennai
Took me time to read all the comments, but I really enjoyed the article. It proved to be Very helpful to me and I am sure to all the commenters here! It’s always nice when you can not only be informed, but also entertained!
digital marketing blog
skartec's digital marketing blog
skartec digital marketing academy
skartec digital marketing
best seo service in chennai
best seo services in chennai
high pr dofollow directory submission sites
high da dofollow directory submission sites
what is relevant in digital marketing
what is sales
digital marketing course
link building strategies
digital marketing strategies for small business
how to create a social media plan
what is digital marketing
email marketing strategies
digital marketing terms
content marketing
internet marketing resources
digital marketing resources
This Blog is really informative!! keep update more about this…
<a href="https://www.zeftaviation.in/aviation-academy-in-bangalore/">Aviation Courses in Bangalore</a>
<a href="https://www.zeftaviation.in/air-hostess-training-in-bangalore/">Air Hostess Training in Bangalore</a>
<a href="https://www.zeftaviation.in/airport-management-courses-in-bangalore/">Airport Management Courses in Bangalore</a>
<a href="https://www.zeftaviation.in/ground-staff-training-in-bangalore/">Ground Staff Training in Bangalore</a>
<a href="https://www.zeftaviation.in/aviation-academy-in-bangalore/">Best Aviation Academy in Bangalore</a>
<a href="https://www.zeftaviation.in/air-hostess-training-in-bangalore/">Air Hostess Training Institute in Bangalore</a>
<a href="https://www.zeftaviation.in/airport-management-courses-in-bangalore/">Airline and Airport Management Courses in Bangalore</a>
Nice informative article thanks for sharing.
<a href="https://www.fivotech.com/services/seo/">SEO Company in Chennai</a>
<a href="https://www.fivotech.com/services/sem/">Best SEO Company in Chennai</a>
Amazon Web Services (AWS) is the most popular and most widely used Infrastructure as a Service (IaaS) cloud in the world. AWS has four core feature buckets—Compute, Storage & Content Delivery, Databases, and Networking. At a high level, you can control all of these with extensive administrative controls accessible via a secure Web client.For more information visit
https://www.acte.in/amazon-web-services-training-in-chennai
Wow, it is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. it is really explainable very well and I got more information from your blog.
Digital Marketing Online Course
AWS Online CoursePython Online Course
Selenium Online Course
Data Science Online Course
DevOps Online Course
Prashidigitech: India largest online website designing company in Ghaziabad. We're supplying best website designing, web designing and development services in Ghaziabad.
Web Designing Company in Ghaziabad
Read your blog, Excellent informative post on
Installing on Amazon EC2
If you are looking for AWS job with unexpected Pay, then visit below link
AWS Training in Chennai | AWS Online Training
FITA Talend Training in Chennai is designed to teach students with Big Data knowledge. This open-source tool helps to create end-to-end solutions and offers features to build visual aids to understand and see business data quickly by using data integration and cloud by Talend Course.
if you are looking for talend and HR course then visit below link:
Talend Training in Chennai
HR courses in Chennai
HR Training in Chennai
Really an informative blog...Thanks for sharing an informative article with us...
content writing course in Chennai
content writing training in Chennai
best content writing course in Chennai
Node JS Training in Chennai
Node JS Course in Chennai
Xamarin Training in Chennai
Xamarin Course in Chennai
It was an informative post indeed. Now It's the time to make the switch to solar power,
contact us(National Solar Company) today to learn more about how solar power works.
<a href="https://www.nationalsolarcompany.com.au/panels.html">solar panels</a>
<a href="https://www.nationalsolarcompany.com.au/inverters.html">solar inverter</a>
<a href="https://www.nationalsolarcompany.com.au/batteries.html">solar batteries</a>
<a href="https://www.nationalsolarcompany.com.au/panels.html">solar panels adelaide</a>
<a href="https://www.nationalsolarcompany.com.au/inverters.html">best solar panels</a>
<a href="https://www.nationalsolarcompany.com.au/batteries.html">solar power</a>
<a href="https://www.nationalsolarcompany.com.au/panels.html">battery storage solar</a>
<a href="https://www.nationalsolarcompany.com.au/inverters.html">battery charger solar</a>
<a href="https://www.nationalsolarcompany.com.au/batteries.html">solar regulators</a>
<a href="https://www.nationalsolarcompany.com.au/panels.html">solar charge controllers</a>
<a href="https://www.nationalsolarcompany.com.au/inverters.html">solar battery storage</a>
<a href="https://www.nationalsolarcompany.com.au/batteries.html">instyle solar</a>
<a href="https://www.nationalsolarcompany.com.au/panels.html">solar panels melbourne</a>
<a href="https://www.nationalsolarcompany.com.au/inverters.html">solar panels for sale</a>
<a href="https://www.nationalsolarcompany.com.au/batteries.html">solar battery charger</a>
<a href="https://www.nationalsolarcompany.com.au/panels.html">solar panels cost</a>
<a href="https://www.nationalsolarcompany.com.au/inverters.html">buy solar panels</a>
This Blog is really informative!! keep update more about this
jual boiler vertikal
jual burner riello R40
jual control burner simens
jual control burner honeywell
jual hot water boiler
jual pompa ksb lengkap
jual thermal oil murah
making steam boilers
thermal oil heater 400.000 kcal
Distributor boiler
It looks like a lot but takes approximately 20 minutes to get a running Cluster.
jual thermal oil heater
Jual thermal oil pengering kayu
jual boiler oil 2 jt kcal
jual burner amp aspalt
jasa cleaning thermal oil
jasa service boiler murah
jual boiler 1 ton
Really an informative blog...Thanks for sharing an informative article with us
distributor Burner Incinerator
Jual burner incinerator
distributor-burner-weishaupt
Jual Burner weishaupt
jual boiler pengering kayu
jual tangki solar custme
jual tangki mixer aspal amp
jual chimney boiler
jual burner riello G20
distributor sprepart boiler
jual pipa boiler bersertifikat
jual pompa KSB terbaik murah
jual burner riello dua fuel
Jual buner Riello gas LPG
agen pompa KSB jakarta
jual boiler kettel uap
jual thermal oil di jakarta
fabrikasi mesin boiler sawit
jual pompa KSB jerman
jual steam boiler mini
<a href=https://jualthermaloil.com/shop/>jual thermal oil shop</a>
<a href=https://jualthermaloil.com/about-us/>jual thermal oil about us</a>
<a href=https://jualthermaloil.com/contact-us/jual thermal oil kontak></a>
<a href=https://jualthermaloil.com/product/distributor-steam-boiler-furnace/>jual boiler furnace</a>
<a href=https://jualthermaloil.com/product/distributor-thermal-oil-hetaer/>distributor thermal oil heater</a>
<a href=https://jualthermaloil.com/product/hot-oil-pump-ksb-germany/>jual hot oil pump KSB jerman</a>
<a href=https://jualthermaloil.com/product/jual-boiler-kapal-pemanas-cpo/>jual boiler kapal CPO</a>
<a href=https://jualthermaloil.com/product/jual-boiler-steam-gas/>jual steam boiler gas</a>
<a href=https://jualthermaloil.com/product/jual-burner-riello-gas-modulating/>jual burner riello modulating</a>
<a href=https://jualthermaloil.com/product/jual-pompa-oli-panas-ksb/>jual pompa KSB oli panas</a>
<a href=https://jualthermaloil.com/product/jual-thermal-oil-boiler-jakarta/>jual thermal oil boiler jakarta</a>
<a href=https://jualthermaloil.com/product/pabrik-boiler-steam-di-jakarta/>pabrik boiler steam tangerang</a>
<a href=https://jualthermaloil.com/product/sales-pompa-thermal-oil-ksb/>sales pompa thermal oil KSB</a>
<a href=https://jualthermaloil.com/product/steam-boiler-water-tube/>jual boiler water tube</a>
Cool post on aws
http://www.traininginchennai.co.in/java-training-in-chennai/
http://www.traininginchennai.co.in/aws-training-in-chennai/
http://www.traininginchennai.co.in/windows-azure-training-in-chennai/
http://www.traininginchennai.co.in/ccna-training-in-chennai/
http://www.traininginchennai.co.in/qtp-training-in-chennai/
Well great! informative post you wrote, happy with your article. How to Optimize Instagram Account for SEO
Please sign in to leave a comment.