The database is a
collection of data which is organized to be easily accessed, managed and
updated for a particular company. It is necessary to gather information,
description, images, and details of the products and services in a sorted way.
At bikroy.com, MySQL and PHP are used for website management and the database
MySQL is a very
useful tool for comprehensive purposes due to its architectural features. It is
a very flexible database server for working in demand of the environment such
as web applications. This is a very important server in Bikroy.com. Anyone can
configure it to run on a wide range of hardware and it is compatible with
various types of data. MySQL storage engine architecture is the main feature
and its design separates query processing from data storage and retrieval.
Bikroy.com was found very suitable for users.
We can get detailed
information about MySQL through the logical approach of MySQL’s architecture.
Some of the common services in the first layer are that they are mostly
network-based client/server tools of the service or the server requires
connection handling, authentication, security etc.
However, the main
interesting part of MySQL starts with the second layer. The brains of all MySQL
are located on the second layer which includes code for query parsing,
analysis, optimization, caching and all underlying functions (such as date,
time, math and encryption). Some examples of stored procedures, triggers, and
visual functionality are provided in storage engines at this stage.
In addition, the
storage engines are contained with the third layer of MySQL. All the data that
are stored in MySQL are stored and recovered from this layer. On the contrary,
there are some drawbacks with the storage engine with its own benefits. Through
the storage engine API, the server mainly interacts with them. With the help of
interface, the difference between the storage engines is hidden. This interface
makes them transparent to the query layer. The API includes a few dozen
lower-level functions that work like doing transactions or get the row that has
this primary key. The storage engines do not describe SQL or communicate with
each other. Generally, they only respond to requests from the server.
uses MyISAM as well as InnoDB. MyISAM is a default storage engine for MySQL,
which is a relational database management system version prior to 5.5. 1. As a
matter of fact, MyISAM is based on the old ISAM code. But there are many useful
extensions in it. The absence of transaction support is the major shortage of
MyISAM. InnoDB provides standard ACID-compatible transaction features, together
with foreign key support. The first big visual difference we can see is that
the InnoDB locates the row-level, while the MyISAM can do only a table-level
lock. InnoDB comes with the updated MySQL which has a better crash recovery. However,
MyISAM has FULLTEXT search indexes, InnoDB did not have that until MySQL
version 5.6 came out. Additionally,
InnoDB implements transactions, foreign keys, and relationship constraints but
MyISAM does not.
PHP is known as
server scripting language and it is also a powerful tool for creating dynamic
and interactive web pages. Eventually using PHP is free, widely used and
efficient alternative to competitors such as Microsoft’s ASP.