WAMP with Aurora on cloud

1-click AWS Deployment on 2012 R2 1-click AWS Deployment on 2016

Overview

Secured WAMP with Aurora on Windows Server  Zero Mysql Overhead

WAMP is a Web development platform on Windows that allows you to create dynamic Web applications with Apache2, PHP, and MySQL. This Stack Replaces Mysql with highly available Mysql Compliant Cluster -Aurora.
Enterprises are plagued with problem of maintaining a Mysql Cluster including backup, Security and overhead for administration. Amazon offers Highly scalable, Multiple AZ Mysql Cluster -Aurora. You can just replace Aurora Connection String inplace of Mysql and use. The respective trademarks mentioned in the offering are owned by the respective companies.
Due to the SysPrep of this image, it may take up to 20 minutes to launch.

WAMP is an acronym that stands for Windows, Apache, MySQL, and PHP. It’s a software stack which means installing WAMP installs Apache, MySQL, and PHP on your operating system (Windows in the case of WAMP). Even though you can install them separately, they are usually bundled up, and for a good reason too.

What’s good to know is that WAMP derives from LAMP (the L stands for Linux). The only difference between these two is that WAMP is used for Windows, while LAMP – for Linux based operating systems.

Let’s quickly go over what each letter represents:

  1. W” stands for Windows, there’s also LAMP (for Linux) and MAMP (for Mac).
  2. A” stands for Apache. Apache is the server software that is responsible for serving web pages. When you request a page to be seen by you, Apache grants your request over HTTP and shows you the site.
  3. M” stands for MySQL. MySQL’s job is to be the database management system for your server. It stores all of the relevant information like your site’s content, user profiles, etc.
  4. P” stands for PHP. It’s the programming language that was used to write WordPress. It acts like glue for this whole software stack. PHP is running in conjunction with Apache and communicating with MySQL.

Instead of installing and testing WordPress on your hosting account, you can do it on your personal computer (localhost).

WAMP acts like a virtual server on your computer. It allows you to test all WordPress features without any consequences since it’s localized on your machine and is not connected to the web.

First of all, this means that you don’t need to wait until files are uploaded to your site, and secondly – this makes creating backups much easier.

WAMP speeds up the work process for both developers and theme designers alike. What is more, you also get the benefit of playing around with your site to your heart’s content.

However, to actually make the website go live, you need to get some form of hosting service and a Domain. See our beginner-friendly article about web hosting for more information.

Or if you’re already prepared to go online, take a look at what Hostinger has to offer. We can guarantee you the best web hosting prices in the market for high-quality hosting solutions.

In essence, WAMP is used as a safe space to work on your website, without needing to actually host it online.

WAMP also has a control panel. Once you install the software package, all of the services mentioned above (excluding the operating system that is) will be installed on your local machine.

Whether you use WAMP or software packages for the other operating systems, it’s a great way to save time. You won’t have to upload files to a site and will be able to learn how to develop in a safe and care-free environment.

WAMP Server is a Web development platform on Windows that allows you to create dynamic Web applications with Apache2, PHP, and MySQL. WAMP Server automatically installs everything you need to intuitively develop Web applications.

WAMP is an acronym formed from the initials of the operating system Microsoft Windows and the main components of the package: ApacheMySQL & PHP.

As a reminder, Apache is the most popular open source web server, MySQL is the most popular open-source database, used by huge number of websites around the world (among them, you will find Google, YouTube, Wikipedia, Facebook, Flickr, etc) and PHP is a widely used general-purpose server-side scripting language designed to produce dynamic web pages.

By combining these components into a single installation package, WampServer allows users to set up a server locally on their Windows machine to create dynamic web applications with Apache, PHP and the MySQL database in the same development conditions as on the production server.

One of the great benefits of WampServer is that it allows you to develop, upgrade components, perform any web development task and carefully test everything offline first, which reduces the risks of creating problems on the live server.

WAMP is a Windows OS based program that installs and configures Apache web server, MySQL database server, PHP scripting language, phpMyAdmin (to manage MySQL database’s), and SQLiteManager (to manage SQLite database’s). WAMP is designed to offer an easy way to install Apache, PHP and MySQL package with an easy to use installation program instead of having to install and configure everything yourself. WAMP is so easy because once it is installed it is ready to go. You don’t have to do any additional configuring or tweaking of any configuration files to get it running.

There are usually two reasons why someone chooses to install WAMP. They are looking to install WAMP for development purposes or to run their own server.


Wamp Server Cointains

1-PHP Admin

Alows you to change or add users and for making new databasesphpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQLover the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

2-Apache
Apache Server deals with Server Side Includes, usually called simply SSI. In this article, I’ll talk about configuring your server to permit SSI, and introduce some basic SSI techniques for adding dynamic content to your existing HTML pages.
In the latter part of the article, we’ll talk about some of the somewhat more advanced things that can be done with SSI, such as conditional statements in your SSI directives.



3-SQL Server and Database System

SQL Server is a relational database management system  from Microsoft that’s designed for the enterprise environment. SQL Server runs on T-SQL (Transact -SQL), a set of programming extensions from Sybase and Microsoft that add several features to standard SQL, including transaction control, exception and error handaling, row processing, and declared variables.

 


Generically, any database management system (DBMS) that can respond toqueries from client machines formatted in the SQL language. When capitalized, the term generally refers to either of two database management products from Sybase and Microsoft. Both companies offer client-serverDBMS products called SQL Server.

Using WAMP as a Development Server

You can use WAMP to develop and test websites locally on their own computer instead of having to get a web hosting account to develop with. Most people will be using WAMP for development purposes such as learning how to create websites with HTML, PHP, and MySQL.


Using WAMP as a Production Server

WARNING: WAMP was designed to be a testing and development server, not an actual production server. WAMP does not come with any real security in place so it offers no protection from any kind of attack. Any 10 year old with access to the internet can easily hack your WAMP server. If your website(s) have hi ghly sensitive data (such as credit card numbers, social security numbers, user ids, passwords, etc.), you need to take this in consideration before your put this information online. Unless you are an experienced system administrator and can configure WAMP to be more secure, you should never user WAMP for a production server.

MySQL Configuration

To begin MySQL installation, first download latest version of MySQL 5.0 Windows Essentialsas an MSI package.
During MySQL installation, select Typical installation and use default configuration values except for Sign-Up where you probably want to select Skip Sign-Up. When Setup Wizard is completed, make sure the option Configure the MySQL Server now is set.
For MySQL Server Instance Configuration, select Standard Configuration. Next, you mustset option Include Bin Directory in Windows PATH. This setting is crucial, otherwise a required library, libMySQL.dll, will not be found later during Apache startup. Finally, enter a proper root password. There is no need to neither enable remote root access or create an Anonymous Account.
Please inspect messages during MySQL startup and verify that MySQL has been started successfully. Then, you must reboot the system. Otherwise, the required librarylibMySQL.dll will not be found during Apache startup when Apache is trying to load Apache’s PHP module and Apache will, perhaps a bit confusingly, complain that it is unable to load the PHP‘s MySQL library, php_mysql.dll. Therefore, it is necessary to reboot the system at this stage and then continue to PHP configuration.
 

PHP Configuration

PHP for Windows must be installed from the zip package, not using the installer because the installer does not work correctly when setting up the configuration files. Download the latest Windows binary version from the 5.x release series.
Create folder C:\Program Files\PHP5 and unzip the downloaded package there. Then, in folder C:\Program Files\PHP5 you need to copy the file php.ini-recommended asphp.ini and make two changes into the php.ini file. Change extension_dir to:
extension_dir = "C:/Program Files/PHP5/ext/"
and also uncomment the following line:
extension=php_mysql.dll
That is all what is needed for PHP configuration. Additionally, however, if you wish to runPHP from the command line it would be useful to add its installation directory to WindowsPATH but for WAMP to operate it is not required. After Apache is installed and configured, also PHP configuration can be tested.

Apache Configuration

Official apache website provides also binaries for Windows. Download the latest availableMSI package from the 2.2.x release series.
During Apache installation, use default values for all configuration queries. Make sure, though, that you fill in a valid e-mail address to Administrator's Email Address field, otherwise Apache will fail to start due to a configuration error. After the installation has finished a tray icon should appear to indicate that Apache server is up and running.
To configure Apache server edit configuration via a Start Menu item or open the fileC:\Program Files\Apache Software Foundation\Apache2.2\conf\httpd.conf in a text editor and change the following line:
       DirectoryIndex index.html
to include index.php so that the result will look like:
       DirectoryIndex index.php index.html
This will cause Apache to serve page index.php by default, if present. Then, add into the same file after all the LoadModule directives the following lines 
# Enable PHP5
LoadModule php5_module "C:/Program Files/PHP5/php5apache2_2.dll"
AddType application/x-httpd-php .php
PHPIniDir "C:/Program Files/PHP5"
 
These lines cause Apache to load and use PHP module and its configuration. The last directive, PHPIniDir, is crucial, without it Apache will fail to read the PHP configuration file.
Apache is now configured. For changes to take effect, Apache must be restarted either from Start Menu or using the Apache Monitor that can be started from the tray icon. No error messages will appear if configuration has been done as instructed.
Before finally proceeding to MediaWiki configuration it is a good idea to check at this stage that WAMP really is working properly. This can be done simply by creating file C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\test.php that contains only the following line:
<?php phpinfo(); ?>
The result can then be seen by opening the page http://localhost/test.php in a browser. Make sure that PHPLoaded Configuration File is C:\Program Files\PHP5\php.ini and that MySQL has its own section in the configuration details noting that MySQL support is enabled. As could be noticed, the default content location, DocumentRoot, for Apache to serve content is C:\Program Files\Apache Software Foundation\Apache2.2\htdocs.

Working With Wamp Server To Create A Database And Host A Website

WAMP Server is a server which is used to host PHP pages. PHP is a server-side scripting language developed by Rasmus Lerdorf.

WAMP stands for – Window Apache MySQL and PHP.
Developed by – Romain Bourdon
Operating system – Windows

Now we are going to discuss the steps for WAMP Server Installation.

Step 1:

WAMP Server download

In this website download WAMP Server 32 BITS & PHP 5.6.15.

On clicking the download link, the following window will open for download. In this click the following.

link
                                                 Figure 1: Direct link to download

After clicking that link the following downloading process window will open.

download
                                                Figure 2: Downloading Window.

Now your file is downloaded and save that *.exe file in your system drive location.

save
                                    Figure 3: Save the file

After the file has downloaded the following tray icon file is visible and stored at your system location

wamp
Figure 4

Step 2:

Now double click that exe file.

The following window will open

warning
      Figure 5: Security warning window for running process

Click Run button and the installation process window will open. First you have to choose the language default as English and then hit ok. Then the step up process wizard will open. In that window click Next button to proceed the installation.

Then the License agreement window will open, click I accept the agreement and then hit next. Next the set up information window will open, then hit next.

The destination location window will open to save where the WAMP folder wants to be located. By default it takes C:\wamp, then hit next and then Install button to install the WAMP Server.

install
                           Figure 6: Installation processed window.

After installation click finish button to navigate WAMP Server.

Now the orange color try Icon placed at the start menu is visible.

icon
                                             Figure 7: Tray Icon in orange color

The tray icon is visible in orange because there are two applications running at localhost using same port number, like 80. Left click the tray Icon, select local host and it shows the following window IIS.

If you face the error, then click the link to download the file (VCRUNTIME140.dll) as shown below and paste it into C:\Windows folder

api-ms-win-crt-runtime-l1-1-0.dll (cannot start error means)

wamp
                                                                                 Figure 8

iis7
                                                                  Figure 9: IIS7

So now we are going to stop IIS port 80 or we could change the WAMPSERVER LISTEN PORT value 80 to 81 in the following way.

Left click the tray Icon and do the following steps

config
                           Figure 10: httpd.conf

After selecting httpd.conf file one notepad window will open and search the text Listen by using CTRL+F.

port
                                                               Figure 11: Listen Port

Here change the listen portfrom 80 to 81.

Right click the tray Icon and choose refresh then left click the icon restart all services. Now your tray icon turned to green. WAMP Server is now ready.

Now left click the icon and choose localhost

The IIS logo window will open in your browser. In your address bar near your localhost mention the following like localhost:81, then the window will appear in the following manner.

homepage
                                                   Figure 12: WAMP SERVER home page

Step 3:

After installation is completed host a simple PHP website via WAMPSERVER. The following steps to be noted.

The folder of wampis placed into your C:\wamp system location.

In this wamp folder navigate to www root folder and there two files appear; one is index.php and another one is testmysql.php those files are built-in type files.

Now we have to place our sample website folder into that www root directory like the following:

directory
                              Figure 13: Place website folder into www root directory

Now refresh our localhost in browser and we find our sample website appears under projects title.

project
                                     Figure 14: Projects

Now click that folder in our browser and our sample project home page will open like this

sample
                                 Figure 15: Sample website home page.

Step: 4

Before you create your database in SQL server try to backup the file in *.sql format. In your WAMP Server home page PhpMyAdmin link appears. Click that link and the database connectivity form will open in the following format.

myadmin
                                                            Figure 16: PHP my admin page

Set the username as root and make empty password column and hit go. The admin page window will open like the following,

connectivity
                                 Figure 17: php my admin database connectivity page

After the page opens in your right side window, click database and choose to create database.

connection
                                                               Figure 18: Database creativity

Now your database will present at left side php mydmin page,

page
Figure: 19

Choose your database and create table or you have to restore your SQL database.
Restore SQL Server database in the following format.

Click import link the following window will open

import
                                                         Figure 20: Import Database

In this window browse your *.sql backup file, choose character set and then hit Go button it takes some time to import so please be patient until the database is imported.

After importing you will get the following message box:

import
                                             Figure 21: Importing successful window.

Now your website is ready to connect the database and now browse your site in localhost:81

Enter your username and password and then hit to login,

login
                                   Figure 22: Login page

Features

Major Features Of WAMP with Aurora

  • Manage your Apache and MySQL services
  • Switch online/offline (give access to everyone or only localhost)
  • Install and switch Apache, MySQL and PHP releases
  • Manage your servers settings
  • Access your logs
  • Access your settings files
  • Create alias
  • Reconfigured WAMP-System with Apache, PHP, MySQL, phpMyAdmin, Mercury/32 Mail-Server and SQLite
  • Equally useful for developers as for productive usagee thanks to switchable settings between security- and developer-functionality
  • Centralized GUI for all important features of the above applications
  • Assistant to operate the applications as a restricted user
  • Add-on system for reloading and integration of other applications (such as Tomcat, Python, SVN, etc.) from the network
  • 1-Click Installer for popular web applications such as phpBB, WordPress u.v.a.
  • Assistant for performance tuning with automatic Evaluation of the System configuraton (number of CPUs, RAM, etc.)
  • Editor for the Windows HOSTS file to create “virtual domains”
  • dynamic and automatic updates of individual components (Apache, MySQL, etc.) directly from the software
  • Focus on a lightweight and fast system – the complete setup consists of only a 33MB file
  • Intuitive web interface
  • Support for most MySQL features:
    • browse and drop databases, tables, views, fields and indexes
    • create, copy, drop, rename and alter databases, tables, fields and indexes
    • maintenance server, databases and tables, with proposals on server configuration
    • execute, edit and bookmark any SQL-statement, even batch-queries
    • manage MySQL users and privileges
    • manage stored procedures and triggers
  • Import data from CSV and SQL
  • Export data to various formats: CSVSQLXMLPDFISO/IEC 26300 – OpenDocument Text and Spreadsheet, Word, LATEX and others
  • Administering multiple servers
  • Creating PDF graphics of your database layout
  • Creating complex queries using Query-by-example (QBE)
  • Searching globally in a database or a subset of it
  • Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link

AWS Template WAMP on Aurora - WAAP

Secured WAMP with Aurora on Windows Server – Zero Mysql Overhead

Instructions for using installed components with AWS Template for WAMP on Aurora – RDS – WAAP

Note: Please do not choose Single Ami option for First time deployment

A) Application URL: Template Output provides the Application URL as well as Database details.

Access the application via a browser at the load balancer URL which is the WebSiteURL from the template output.

B) RDS Cluster / Aurora Details:

RDS Cluster / Aurora Details can be obtained from the Output of the template.

Please enter the RDS Cluster / Aurora details in the configuration of Database stage.

Details are also available in

C:\Install\Aurora_credentials.txt in the ec2 Instance.

Readme file is present on the Administrator desktop.

C) RDP Connection: To connect to the operating system,

1) Connect to virtual machine using following RDP credentials :

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password : Please Click here  to know how to  get password .

D) Other Information:

1.Default installation path: 

Location of Apache Bin : C:\Apache24\bin
Location of PHP: C:\PHP
Location of htdocs: C:\Apache24\htdocs
Location of Aurora Conn Strings: C:\install\Aurora_credentials.txt

2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

To begin configuration of WAMP please refer above.

When you open the WebSiteURL you shall see the below screen

WAMP with Aurora on cloud

Related Posts