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
67 comments
Great! I like to share it with all my friends and hope they will also like this information.
https://www.realtimeexperts.in/Manual-Testing-Training-in-Bangalore.html
Thanks for sharing such useful information on the blog and refer the best.
visit: https://www.realtimeexperts.in/
ADF training institute are very limited and we are one of the best Azure data factory training institute in Hyderabad more details visit my website linkhttps://brollyacademy.com/azure-data-factory-training-in-hyderabad/
its help my research and thanks a lot for sharing
React Training in Hyderabad
Interdisciplinary plan proposal entails multiple disciplines from within a healthcare office teaming up to deal with organizational issues and accomplish wanted patient outcomes. This assignment will incorporate an evaluation of best practices of interprofessional nurs fpx 4010 assessment 3 interdisciplinary plan proposal, change theories, and leadership strategies.
For example, interdisciplinary rounds increase communication effectiveness among healthcare professionals at the emergency division, which can help reduce the number of Foley catheters and overall mortality rates.
Nice Article!
Thanks for sharing with us 🙂
<a href="https://brollyacademy.com/snowflake-training-in-hyderabad/">snowflake Training in Hyderabad</a>
Thanks for the informative article you shared. This is one of the best resources I have found recently.
SAP Fico Training In Bangalore
Wow, it is very excellent and awesome, and it has much aided me in understanding numerous topics. It is very nicely explained, and your blog provided me with further information.
https://www.vcubesoftsolutions.com/python-training/
Chennai Embedded System Training
Comprehensive Embedded System Training is available in Chennai from IntelliMindz. Participants receive thorough practical training in live projects from IntelliMindz, Embedded Systems. Our candidates were able to land jobs in various MNCs thanks to their training in embedded systems. The instructors at IntelliMindz Chennai are corporate professionals with specialised knowledge in the field who offer Embedded Systems Training in Chennai with in-depth research. Candidates who earn our Embedded Systems certification will be eligible for a variety of jobs in the sector. The course curriculum for embedded systems spans a wide range of levels, from fundamental to professional. Beginners and intermediate-level individuals can benefit from the IntelliMindz Embedded System training programme. Enroll in our Embedded System Training in Chennai to begin learning with us and expand your knowledge about embedded systems.
Informatica Cloud Training is a comprehensive training program offered by Informatica to help users learn how to use the features of the Informatica Cloud platform. The training includes courses on how to use the various components of the platform such as data integration, data security, and data privacy features.https://brollyacademy.com/iics-training-in-hyderabad/
Azure DevOps is the most advanced solution for continuous integration, delivery and deployment of software projects.Azure Devops training in hyderabad visit our link to get more informationhttps://azuretrainings.in/azure-devops/
its help my research and thanks a lot for sharing
<a href="https://fullstackmasters.in/react-training-in-hyderabad/">React Training in Hyderabad</a>
ADF training institute are very limited and we are one of the best Azure data factory training institute in Hyderabad more details visit my website linkhttps://azuretrainings.in/azure-data-factory-training-in-hyderabad/
There will be best course in Hyderabad, duck creek policy program,duck creek can earn a salary 130000 per annum.it is useful to students career in the field you have interest visit my website link.thanks youhttps://duckcreektraining.com/
Azure data factory (ADF) is a cloud-based ETL and Data Integration service. ADF training institutes are very limited and we are one of the few best Azure data factory training institutes in Hyderabad. https://azuretrainings.in/azure-data-factory-training-in-hyderabad/
Mule masters Hyderabad, provides 100% job assistance, extending real time projects for practical knowledge this is best course you have interest visit my website link https://mulemasters.in/
nice thanks for sharing informative post like this keep posting if like more details about duck creek visit it https://duckcreektraining.com/
Digital Classroom or Smart Classroom is a text independent e-learning material for learners, teachers and administrators who are in the field of administration. In this way, optimal delivery of learning experience can be ensured by the instructor
This is a wonderful article, Given so much info in it, These type of articles keeps the users interest in the website, and keep on sharing more ... good luck.
<a href="https://https://www.credosystemz.com/training-in-chennai/react-js-training/">Reactjs Training in Chennai</a> |
<a href="https://https://www.credosystemz.com/training-in-chennai/react-js-training/">Best Reactjs Training Institute in Chennai</a> |
<a href="https://https://www.credosystemz.com/training-in-chennai/react-js-training/">Reactjs course in Chennai</a>
Looking to master Spring Boot and build robust Java applications? Join Login360's Spring Boot Training in Chennai, where expert trainers guide you with hands-on sessions, real-world projects, and industry-relevant skills. Whether you're a beginner or looking to upskill, our course is designed to help you become a job-ready professional in no time!
Interesting stuff to read. Keep it up. Luxury Amarnath package
<a href="https://skill-centre.com/azure-devops-training-in-hyderabad/">Azure DevOps Training In Hyderabad-Bangalore</a>
<a href="https://skill-centre.com/azure-devops-training-in-hyderabad/">Azure DevOps Training In Hyderabad</a>
It seems like you're asking for a comment or feedback on the provided tutorial. Here's a possible response:
---
This tutorial provides a detailed step-by-step guide for setting up EC2 instances and deploying Cluster Control for MySQL Cluster on AWS. The instructions are clear and well-organized, making it relatively easy for readers to follow along.
One suggestion for improvement could <a href="https://pmpacademy.in/" > PMP certification course in Hyderabad</a> be to include more explanations or context for certain steps, especially for readers who might be new to AWS or database clustering. For example, elaborating on the purpose of certain configurations or commands could enhance understanding for beginners.
Additionally, it might be helpful to include troubleshooting tips or common pitfalls that users might encounter during the setup process. This could help prevent frustration and assist users in resolving issues quickly.
It seems like you're asking for a comment or feedback on the provided tutorial. Here's a possible response:
---
This tutorial provides a detailed step-by-step guide for setting up EC2 instances and deploying ClusterControl for MySQL Cluster on AWS. The instructions are clear and well-organized, making it relatively easy for readers to follow along.
One suggestion for improvement could <a href="https://embeddedhash.in/embedded-systems-course-in-hyderabad/"> Embedded Systems Course in Hyderabad</a> be to include more explanations or context for certain steps, especially for readers who might be new to AWS or database clustering. For example, elaborating on the purpose of certain configurations or commands could enhance understanding for beginners.
Additionally, it might be helpful to include troubleshooting tips or common pitfalls that users might encounter during the setup process. This could help prevent frustration and assist users in resolving issues quickly.
Overall, it's a comprehensive guide that covers the essentials for deploying ClusterControl on EC2, and with a few enhancements, it could be even more user-friendly for a broader audience.
"Brolly Ai's Custom GPT course is top-notch! The comprehensive content and hands-on approach provide an excellent learning experience for anyone interested in diving deep into GPT customization. Highly recommended!"
<a href="https://brollyai.com/custom-gpt-application/">Custom GPT Applications </a>
nice article
thanks for sharing with us
<a href="https://brollyacademy.com/azure-data-factory-training-in-hyderabad/">Azure Data Factory Training In Hyderabad</a>
thanks for valuable info
<a herf="https://gcpmasters.in/">gcp training in hyderabad</a>
its help my research and thanks a lot for sharing
<a href="https://fullstackmasters.in/angular-training-in-hyderabad/">Angular Training In Hyderabad</a>
Please sign in to leave a comment.