"MySQL Administrator's Bible" - это ресурс с особым фокусом на следующем крупном релизе MySQL, который предоставляет надежную основу для любого, кто только начинает работать с MySQL или переходит с другой платформы баз данных, а также для опытных администраторов MySQL. Авторы предоставляют необходимое покрытие основ управления базами данных MySQL - включая уникальный подход MySQL к основным функциям баз данных - а также покрытие запросов SQL, типов данных и индексов, хранимых процедур и функций, триггеров и представлений, а также транзакций. Они также представляют всестороннее покрытие таких тем, как настройка сервера MySQL, управление хранилищем данных, кэширование, резервное копирование и восстановление, управление пользователями, настройка индексов, мониторинг баз данных и производительности, безопасность и многое другое.
The book draws special attention on the upcoming cutting-edge edition of MySQL beside offering a firm framework to newcomers to MySQL or those changing over from a different managing database, including experts in MySQL managing. This valuable publication provides eminent initiation to MySQL database administration, explaining MySQL's peculiarity in elementary database specifics and instruments, similarly as depicting SQL inquiries, data types interlinked with indexes, information investigation systems (stored procedures and functioning systems, triggers, views and operations). In addition, it includes comprehensive coverage to subjects like MySQL server control, managing engines of storage, buffering, back-up and recuperation, managing clients, enhancers, database examination and activity observing, assurance and other points.
Written with special emphasis on the soon-to-be released MySQL 5, this book serves as a valuable resource for novice MySQL users or those upgrading from other database platforms and for experienced administrators. It conveniently covers all the basics regarding MySQL's data management principles - covering the unique approach of the software to primary database features, all the way to SQL query manipulation, different types of data and indices, stored procedures and functions, trigger management and factoring routine use. Also covered very thoroughly are subjects such as efficient server administration, optimising storage engines and caching, creating effective backups and recovering from potential loss, user management including optimised indexing strategies, database performance monitoring and the importance of securing access to sensitive information.
Электронная Книга «MySQL Administrator's Bible» написана автором Keith Murphy в году.
Минимальный возраст читателя: 0
Язык: Английский
ISBN: 9780470506615
Описание книги от Keith Murphy
With special focus on the next major release of MySQL, this resource provides a solid framework for anyone new to MySQL or transitioning from another database platform, as well as experience MySQL administrators. The high-profile author duo provides essential coverage of the fundamentals of MySQL database management—including MySQL’s unique approach to basic database features and functions—as well as coverage of SQL queries, data and index types, stores procedure and functions, triggers and views, and transactions. They also present comprehensive coverage of such topics as MySQL server tuning, managing storage engines, caching, backup and recovery, managing users, index tuning, database and performance monitoring, security, and more.
