Название: MySQL Made Easy
Автор: Joseph C. Scott
Издательство: Independently published
Год: 2020
Страниц: 986
Язык: английский
Формат: pdf, mobi, epub
Размер: 10.1 MB

MySQL has grown up. Once dismissed as a lightweight toy for websites, MySQL is now a viable mission-critical data-management solution. Whereas before it was the ideal choice for websites, now it contains many of the features needed in other environments, all while maintaining its impressive speed. It has long been able to outperform many commercial solutions for raw speed and has an elegant and powerful permissions system, but now version has the ACID-compliant InnoDB transactional storage engine.

MySQL is faster, has online backup facilities, and has a multitude of new features. There is little reason not to consider MySQL for your database solution. MySQL AB, the company behind MySQL, offers efficient and low-cost support, and, like most open-source
communities, you'll find lots of free support on the Web. Standard features not yet included in MySQL (such as views and stored procedures) are currently under development and may even be ready by the time you read this book.

Who This Book Is For:
This book is for developers, database administrators (DBAs), and MySQL users. It contains the following topics:
Exploring Structured Query Language (SQL) as implemented by MySQL. Understanding and using the data and table types.
Optimizing your queries and indexes.
Backing up the database.
Managing users and security.
Administering and configuring MySQL (and optimizing the configuration for performance).
Replicating MySQL onto multiple servers.
Understanding database design and database normalization, and walking you through a complete case study. Knowledge of this topic is vital if you plan to use MySQL in serious applications.
Programming with MySQL.
Writing your own extensions to MySQL.
Installing MySQL.
The book's appendixes contain the following:
A thorough MySQL reference
References containing PHP, Perl, C, Java, Python, and ODBC functions and methods for interacting with MySQL