MariaDB 11 Essentials: Deploying and Managing Databases with MariaDBКНИГИ » ОС И БД
Название: MariaDB 11 Essentials: Deploying and Managing Databases with MariaDB Автор: Neil Smyth Издательство: Payload Media Год: 2025 Страниц: 282 Язык: английский Формат: epub (true) Размер: 18.4 MB
Databases form the core of modern applications, powering everything from websites and mobile apps to complex enterprise systems. MariaDB 11 Essentials provides a concise guide to MariaDB, one of the most highly regarded database management systems in use today, covering fundamental concepts, advanced techniques, and best practices.
The book begins by installing and configuring MariaDB on Windows and Linux before outlining the fundamentals of relational database management systems. The essentials of relational database management are covered, including table design, SQL queries, joins, and transaction handling. Beyond the fundamentals, this book covers advanced MariaDB features, such as indexing for performance optimization, automation with triggers and events, and creating and restoring database backups.
In addition to covering the command-line tools provided by MariaDB, several chapters introduce the phpMyAdmin and MySQL Workbench tools, which offer user-friendly graphical interfaces for database management.
MariaDB is derived from the MySQL source code (a concept known as a “fork” in open-source parlance). Originally intended as a fully compatible alternative to MySQL, MariaDB has started to diverge from MySQL in recent years, but the two systems remain highly compatible. MariaDB continues to evolve and increase in popularity and is considered to be faster and more scalable than MySQL. K1 Investment Management acquired the company behind MariaDB, and like MySQL, MariaDB is available in free community and subscription-based enterprise editions. The name MySQL comes from a combination of “My” and “SQL.” In this context, “My” is a proper noun rather than a possessive adjective and is named after My, the daughter of Michael Widenius. SQL stands for Structured Query Language, the language used for managing databases. MariaDB, on the other hand, is named after Widenius’ younger daughter Maria.
MariaDB is classified as a client-server database management system (DBMS). This type of DBMS consists of two main components. The server, which usually resides on the same physical computer as the database files, is responsible for all interactions with the database. The second component is the client, which sends database requests to the server. The server processes these requests and returns the results to the client. There are several key advantages to using a client-server architecture for a database management system (DBMS). First, the client does not need to run on the same computer as the server. Instead, clients can send requests over a network or internet connection to a server located on a remote host. This setup makes the database accessible to a large number of clients. In large-scale enterprise environments, it also allows for fault tolerance, high performance, and load balancing to be implemented effectively. Second, separating the client from the server allows a wider range of client types to be used to access the database. Typical clients include MariaDB tools, desktop and mobile apps, web-based applications, web servers, and even other database servers.
This book explains each topic in detail and includes practical examples that provide hands-on experience. e chapters also contain quick-reference summaries highlighting key points for easy review.
By the end of this book, you will have the confidence to design, build, and manage MariaDB databases.
Скачать MariaDB 11 Essentials: Deploying and Managing Databases with MariaDB
Навигация
Вход на сайт
Реклама
MariaDB 11 Essentials: Deploying and Managing Databases with MariaDB 
