The database is acollection of data which is organized to be easily accessed, managed andupdated 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 databasemanagement system.MySQL is a veryuseful tool for comprehensive purposes due to its architectural features. It isa very flexible database server for working in demand of the environment suchas web applications. This is a very important server in Bikroy.com.
Anyone canconfigure it to run on a wide range of hardware and it is compatible withvarious types of data. MySQL storage engine architecture is the main featureand its design separates query processing from data storage and retrieval.Bikroy.com was found very suitable for users.
We can get detailedinformation about MySQL through the logical approach of MySQL’s architecture.Some of the common services in the first layer are that they are mostlynetwork-based client/server tools of the service or the server requiresconnection handling, authentication, security etc.However, the maininteresting part of MySQL starts with the second layer. The brains of all MySQLare 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, andvisual functionality are provided in storage engines at this stage.In addition, thestorage engines are contained with the third layer of MySQL.
All the data thatare 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. Throughthe storage engine API, the server mainly interacts with them. With the help ofinterface, the difference between the storage engines is hidden. This interfacemakes them transparent to the query layer. The API includes a few dozenlower-level functions that work like doing transactions or get the row that hasthis primary key. The storage engines do not describe SQL or communicate witheach other. Generally, they only respond to requests from the server.
Generally, bikroy.comuses 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 amatter of fact, MyISAM is based on the old ISAM code. But there are many usefulextensions in it. The absence of transaction support is the major shortage ofMyISAM. InnoDB provides standard ACID-compatible transaction features, togetherwith foreign key support. The first big visual difference we can see is thatthe InnoDB locates the row-level, while the MyISAM can do only a table-levellock.
InnoDB comes with the updated MySQL which has a better crash recovery. However,MyISAM has FULLTEXT search indexes, InnoDB did not have that until MySQLversion 5.6 came out. Additionally,InnoDB implements transactions, foreign keys, and relationship constraints butMyISAM does not.PHP is known asserver scripting language and it is also a powerful tool for creating dynamicand interactive web pages. Eventually using PHP is free, widely used andefficient alternative to competitors such as Microsoft’s ASP.