Category: LAMP Stack

Posted in AWS, LAMP Stack, Linux, Windows

CREATING MY AIMs IN AWS

Posted on by Akhil

A fantasy or even might be a necessity in some cases to have our own created AMIs. The use of different resources in EC2 in AWS allows an individual to reach their desired targets. An individual can create a clown image of a server in two different ways.

  • An instance of Ubuntu 18.04 is created for a reference in the following practical.
  • An Apache server and also a database with some data were installed and created for the cross verification purpose.

Method One :

  • Select the instance that needed to be clowned > Actions > Image > Create image. // As shown below.
  • The clowned image can be seen in the My AIMs, while launching an instance.
  • Launch the number of instances using the created AIM and connect to any of the instance created.
  • Compare to the original instance // If needed.

Method Two :

  • EC2 > Volumes (Elastic Block Store) > Select the volume > Actions > Create Snapshot as shown below.
  • Created snapshots can be seen in the EC2 > snapshots (Elastic Block Store).
  • Select the desired snapshot > Actions > Create image.
  • The clowned image can be seen in the My AIMs, while launching an instance or in EC2 > AMIs (Images).
  • Launch the number of instances using the created AIM and connect to any of the instance created.
  • Compare to the original instance // If needed.

Posted in AWS, LAMP Stack, Linux

MYSQL DATABASE

Posted on by Akhil

Database : A database is an organized collection of data.

Installing MySQL-server in Ubuntu

  • sudo apt-get install mysql-server // Installing the mysql
  • sudo mysql_secure_installation // securing the mysql server
A permission followed by the choice of strength of the password, type the password and continue with the default settings.

Creating a database in MySQL

  • sudo mysql -u root -p
  • enter the password // Connecting to MySQL
  • create database Akhil0087 // Creating a database in mysql
  • use Akhil0087 // Entering into the database
  • create table Topics(
  • Topic VARCHAR(255) NOT NULL,
  • created_on DATE,
  • Author VARCHAR(255) NOT NULL
  • ) ENGINE=INNODB; // Creating a table in the database
  • describe Topics; // To get the following output.
  • insert into Topics (Topic, created_on, Author) values ('AWS', '2019-11-21', 'Akhil'); // Providing the values for each described field.

Interested in further more operation related to database

Posted in AWS, LAMP Stack, Linux

INSTALLING AN APACHE SERVER ON UBUNTU IN AWS

Posted on by Akhil

The IP Address (public) of the created instance is used to get access remotely either using putty or windows remote access control. In the following case putty is used to get access on a Ubuntu 18.04 (Created EC2 instance) remotely. The downloaded key-pair has been converted from .ppm to .ppk using puttyGen and loaded as shown in the figure.

  • sudo apt-get install apache2 // Installing Apache2
  • sudo systemctl status apache2 // Checking the status of Apache which display active (running)
  • http://server_IP_address // Testing of Apache server, server IP address should be entered in any browser which should result in the following output.

If someone could not be able to get the output please allude:

https://phoenixnap.com/kb/ubuntu-start-stop-restart-apache