MySQL – Structure Introduction

13
2



Find code and diagrams at:

The structure of a MySQL Backend can be designed however the administrator thinks is logical. There are few hard rules for how the structure has to be designed.

Front End/ Back End

With modern applications there is a “front” and “back” end. The Back End is the database and infrastructure that allows users to access data through a Front End which would be the web based interface or native application on their mobile device.
Database Servers

Database servers are either physical or virtual servers with an operating system installed and then the database software installed on the OS.
For the database to be accessed by a front end not only does the database need to be configured properly, but the OS needs to be configured for the proper firewall rules and permissions.
MySQL Schema

Database – is the highest unit in a database system. You can have a single database for your company, or many. Having separate databases can be useful for security and reliability. Separate databases can be connected to by a single front end.
Tables – contain the records in the database. Tables should store “like” data. Such as a Users Table, and a Parts Table.
Columns Name – is the name of the data to be stored such as “firstName”.
Primary Keys – Every record in a database table must be unique. A Primary Key is a unique entry for each record. generally the Primary Key column is setup to auto increment.
Rows/ Records – Are the individual Records that are stored in a table
Data Types – You assign a data type to the Column in a Table. Such as INT, TEXT, FLOAT. This means that an INT field will not accept “bob” as an entry.
Schema – is the design and naming convention in the database. A front end can not store data to a database if the
Storage Engine

DON’T TOUCH!!!
Storage Engines are the component of MySQL that actually does the inserting and sorting actions. There can be reasons to change the Engine, but generally just leave it as the default which is currently InnoDB.
Users

Databases have user accounts and permissions like other software. You can secure your database by having front ends access the database with only user accounts with the specific permissions that are required.

Nguồn: https://saesrpg.net/

Xem thêm bài viết khác: https://saesrpg.net/giai-tri/

13 comments

  1. danny southern 6 July, 2020 at 06:52 Reply

    Hi, talking about MYSQL database, what about if the databes loading become slow because of lets say 20K categories and lots of values connected to the categories, how would you go about speeding it up, would you have each category tree and its values under its own table.

  2. So CoOoL 6 July, 2020 at 06:52 Reply

    Thanks Eli for the Video,

    You are my first IT source of information, I am in a IT Security team and I have a question to you please.

    To handle IT Database Security solutions (Oracle & IBM Guardium), what are Database skills you need ?

    I never worked with Databases.

    Please Eli I really need your advise .

    Thanks and regards

  3. T S 6 July, 2020 at 06:52 Reply

    are you doing in the future a video where the content will be operating systems? it would be great to understand how operating systems are connected to the World Wide Web.

  4. Oscar A 6 July, 2020 at 06:52 Reply

    Thank you Eli, great work. This content is very valuable; that's why I donate monthly. I encourage others to donate as well.

Leave a reply