MySQL Database definition

Mysql

MSYQL Database

What is a database? Warehouse where data is stored

Traditional relational databases: MySQL, Oracle, DB2, Sysbase

Internet hottest MySQL, Oracle

What is a relational database?

1. Two-dimensional table

2, the Internet operation is the most commonly used MySQL

3. Accessing data through SQL Structured query statements

4, maintain a strong data consistency, acid theory.

Features: Read and write more is to deal with the disk. Data consistency Security

Cons: Slow speed

Non-relational database

Nosql,not only SQL for efficient, high-performance purposes

All factors unrelated to efficiency performance are discarded as far as possible

is a complement to the relational database

More and more fire

memcached software for pure memory caching

Key-->value Key-value pair form stu001--->oldboy

Redis Memory plus persistent software (disk)

Data type key---->values Key-value pair form stu001--->oldboy

Data types MORE:

Key--->values collection set list .....

A summary of NoSQL non-relational databases

1, NoSQL is not a negative relational database, but as an important complement to the relational database

2, NoSQL for high performance. High concurrency.

3. NoSQL Typical product memcahed (pure memory), Redis (persistent) mongdb (database of documents)

Why Choose MySQL

1, Mysql performance excellence, service stability, rarely abnormal redundancy machine

2, MySQL open source code and no copyright restrictions, autonomy and use of cost to

3, MySQL has a long history, the community and users are very active encounter problems, you can seek the Orb

4, MySQL software small size, easy to install and use, and easy to maintain, installation and maintenance costs are low

5, MySQL brand word-of-mouth effect, so that enterprises do not have to consider the direct use of LNMP LEMP Popular architecture

6, MySQL support a variety of language operating systems, provide a variety of API interface, support a variety of development languages, especially for the popular PHP language has a good support.

MySQL genealogy

Business Edition and Community Edition * * * *

Community Edition:

The first product is new: 5.0xxxx and upgrade to 5.1XXXX product line, which continues to improve and improve its user experience and performance, while adding new features, this line can be said to be MySQL early product continuation series

The first line of the product: the root of the red seedling

Version: 4.0---5.0---5.1---5.2

Second product line:

Second product line: For better integration of MySQL

AB's community and third-party companies have developed new storage engines, as well as absorbing new implementation algorithms, to better support SMP architectures, improve performance and do a lot of code refactoring. Version number: 5.4xxx started, and currently developed to 5.6XX

Mainstream internet companies use mysql.5.5

This article is from "gilt Son" blog, please be sure to keep this source http://19930412.blog.51cto.com/6974556/1913066

MySQL Database definition