Bn202 Internetworking Technologies: Xampp And Assessment Answer

Xampp and Mariadb: Installation of Xampp to open Mysql

Step 1: The link https://www.apachefriends.org/index.html is open on the web browser.

Step 2: The XAMPP for Windows option is selected for download.

Step 3: Double-click on ‘xampp-win32-7.2.7-0-VC15-installer’

Step 4: The OK button is clicked.

Step 5: The Xampp Setup dialogue box appear. Clicked on the ‘Next’ button.

Step 6: Clicked on the ‘Next’ button.

Step 7: The installation folder location is selected and clicked on the ‘Next’ button.

Step 8: Clicked the ‘Next’ button.

Step 9: Clicked the ‘Next’ button.

Step 10: Installation is processing.

Step 11: Clicked on the Finish button.

Step 12: Selected the Language option Clicked on ‘Save’.

Step 13: ‘Start’ option is selected for MySql.

Step 14: ‘Start’ option is selected for Apache

Step 15: Both Apache and MySQL is running on XAMPP.

Step 16: On the web browser ‘localhost’ is search to open the Xampp.

Step 17: The ‘MySQL’ dashboard’ is open.

Step 18: The new database will be created by click on the ‘New’ option.

Installation of MariaDB MSI Package to open Mysql

Step 1: MariaDB website need to open from the link https://downloads.mariadb.org/ in the web browser. Then had clicked on the green box shown in figure.

Step 2: The link that open https://downloads.mariadb.org/mariadb/10.3.8/ from it, MSI Package for Win 64 is selected.

Step 3: The MaraiDB 5.2 (x64) set up dialogue box appear. Then clicked on next.

Step 4:  The License Agreement dialogue box appear. Select the ‘I accept the terms in the License Agreement’ and click on Next button.

Step 5: In Custom Setup clicked the next button.

Step 6: For the Database Security or Authentication password is set for the “root” database.

Step 7: In Other properties of Database all the check box is selected and click on the next botton.

Step 8: The MariaDB is then ready to install. The Install button is clicked to install MariaDb.

Step 9: A popup appear for User Account Control (UAC) to enable. In it the Yes button is clicked.

Step 10:  The Finish button is clicked and the setup is ready for MariaDB.

Capabilities of MariaDB

The developers using MySQL can now migrate to MariaDB for the following reason:

1. The development of MariaDB is more open and vibrant.
2. Security releases are quicker and more transparent
3. The features that it has are more cutting edge
4. Storage engine are more
5. Performance are better
6. Galera provide master-master replication
7. Stewardship of oracle is uncertain
8. Popularity has leapt in MariaDB
9. Migrating to MariaDB is easy and Compatible
10. After 2015 migration become difficult

Approach to conceptual or logical model of the database structure in MariaDB

The commonly approach to conceptual model is the entity-relationship model. Depending on the requirement and the complexity of the data structure DBMS is chosen. For the logical and physical design, an attributes need to be added to create a relationship of the entities and the primary keys. There is no problem in selecting MaraiDB as DBMS. A simple approach can be made in creating a MariaDB tables. A simple database that will be created using the MariaDb is as follow:

CREATE DATABASE my_details;

CREATE TABLE profile (

  Id INT NOT NULL,

  first_name VARCHAR(30),

  last_name VARCHAR(40),

  address VARCHAR(80),

  postal_code VARCHAR(6),

  email_id VARCHAR(254),

  PRIMARY KEY(Id));

Bibliography

Friends, A. (2017). XAMPP Apache+ MariaDB+ PHP+ Perl. Haettu osoitteesta https://www. apachefriends. org/index.html (15.5. 2016).

Installing MariaDB MSI Packages on Windows. (2018). Retrieved from https://mariadb.com/kb/en/library/installing-mariadb-msi-packages-on-windows/