18.1 Database management system

A database is a data warehouse that stores data data in a specific structure. I n today's era of the rapid rise of big data technology, the Internet generates a large amount of data information every day, and database technology has moved from a single centralized storage model that initially could only store simple table data to a large distributed model that now stores a large amount of data. I n the information society, it is an important prerequisite for scientific research and decision-making management to manage and utilize all kinds of data and tap the value of it. At the same time, database technology is also the core component of management information system, office automation system, decision support system and other information systems, and is an important technical means for scientific research and decision management.

Database management system is a kind of software program that can establish, modify, delete, find and maintain the data stored in the database. I t effectively lowers the technical threshold for database management by converting specific physical data from the computer into abstract logical data suitable for user understanding, so that even engineers working on Linux operations can perform basic management operations on the database. H owever, It is necessary for Mr. Liu to remind readers that the technical main line of this book is still the operation of Linux system, and the database management system is only a branch of the main line of content scale-out, vertical deepening, can not be expected to be proficient in database management technology within a day or two. If you have a reader who has developed a keen interest in database management techniques after completing this chapter and wants to get a job, you need to customize an additional study plan for yourself.

Figure 18-1 MariaDB and Mysql database management system famous LOGO

Since it's about database management, you can't get around MySQL. M ySQL is a database management system with a very high market share, mature technology, relatively simple configuration steps, and good scalability. H owever, since Oracle acquired MySQL's parent company Sun in 2009, the MySQL database project has evolved into a software system that retains its identity as open source software but has filed multiple commercial patents. O pen source software is the global hacker, geek, programmer and other technical experts in the open source community under the banner of the public wisdom crystallization, their own labor results by other companies commercialization naturally also hurt a large number of open source workers, so the mySQL project founder re-developed a new database management system called MariaDB. The software, currently maintained by the open source community, is a branch of MySQL and is almost fully compatible with MySQL.

At the same time, many companies have abandoned MySQL because of competition or interests between companies, coupled with MySQL's gradual shift from open source to closed source software after its acquisition. C urrently, Google, Wikipedia and other technology areas decided to transfer business on the MySQL database to the MariaDB database, Linux open source system leader Red Hat also decided to RHEL 7, CentOS 7 and the latest Fedora system, MariaDB as the default database management system, and Red Hat is the first time to add database knowledge to the RHCE certification exam content. Dozens of other common Linux systems, such as OpenSUSE, Slackware, and others, have since made similar statements.

But, frankly, while IT giants have decided to adopt MariaDB database management systems, that doesn't mean MariaDB has a clear advantage over MySQL. M r. Liu spent nearly two weeks testing the difference between MariaDB and MySQL, and conducted a number of performance tests, without finding the obvious advantages that the media had described. I t can be said that MariaDB and MySQL are basically consistent in performance, and the operational commands of the two are very similar. F rom a pragmatic point of view, after mastering the commands and basic operations of the MariaDB database, even if you encounter the MySQL database in future work, you can get started quickly. Therefore, these two database systems regardless of which to choose to learn to listen to Jun, and this book chose to explain to MariaDB database, mainly from the RHCE certification examination and technology monopoly point of view of the decision.

Have a problem? Ask bold questions!

Because readers have different hardware or operation errors may lead to experimental configuration errors, please be patient and take a closer look at the operation steps, do not be discouraged

Linux technical exchange please add Group A: 560843 (full), Group B: 340829 (recommended), Group C: 463590 (recommended), click here to view the national group.

This group features: through password verification to ensure that each group member is "Linux should learn" readers, more targeted, from time to time free to receive customized gifts.