Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
MySQL Administrator's Bible (Bible (Wiley))

Buy
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.

Whether you're a novice or experienced DBA, this book has all you need to learn MySQL

MySQL Administrator's Bible is designed to provide a solid framework for a beginning MySQL DBA or an experienced DBA transitioning from another database platform. The book starts with the fundamentals of MySQL database management, including MySQL's unique approach to SQL queries, data and index types, stored procedures and functions, triggers and views, and transactions. The authors continue with comprehensive coverage of major MySQL Server components and processes for which DBAs are responsible—these include:

  • MySQL Server tuning

  • Query optimization and index tuning

  • Managing storage engines

  • Caching

  • Authentication and managing users

  • Partitioning; Replication; Logging

  • Database and performance monitoring

  • Security; Backup and Recovery

  • Managing availability and scaling

  • Fully covers MySQL 5.1

Companion Web Site

The book's Companion Web Site includes a tutorial on foundational SQL programming that all MySQL DBAs need to understand, plus code examples, scripts, and data schemas used in the book. You'll also learn about the latest changes in MySQL and find helpful links. Visit the site at www.wiley.com/go/mysqladminbible.

(HTML tags aren't allowed.)

Practical HTML5 Projects (Expert's Voice in Web Development)
Practical HTML5 Projects (Expert's Voice in Web Development)

Practical HTML5 Projects is a collection of valuable web techniques that any developer or designer can use. This book is all about saving time. Busy web developers should not have to plow through pages of theory or history only to discover that no practical applications are provided, nor should they have to read a paragraph five...

Making Sense of NoSQL: A guide for managers and the rest of us
Making Sense of NoSQL: A guide for managers and the rest of us

Summary

Making Sense of NoSQL clearly and concisely explains the concepts, features, benefits, potential, and limitations of NoSQL technologies. Using examples and use cases, illustrations, and plain, jargon-free writing, this guide shows how you can effectively assemble a NoSQL solution to replace or...

The Rough Guide to the Grand Canyon
The Rough Guide to the Grand Canyon

The Rough Guide to the Grand Canyon is the definitive practical guide to America's greatest natural wonder. It explores this stunning natural attraction and the surrounding area in its entirety, from the ruggedly beautiful inner canyon and the famous viewpoints of the North and South rims to the turquoise waters of Havasu Falls and...


Invasion of Privacy!  Big Brother and the Company Hackers
Invasion of Privacy! Big Brother and the Company Hackers

Pop-up ads, cookies, spyware, spam, junk mail, telemarketing calls. Rapidly evolving technology has made you a target and your personal information a desirable commodity. Your profile is out there and it’s available not just to the highest bidder, but to every bidder. Technology, advertising, the media, and government have converged to...

Juniper and Cisco Routing: Policy and Protocols for Multivendor Networks
Juniper and Cisco Routing: Policy and Protocols for Multivendor Networks
Obtain a clear understanding of how routing information and traffic flows on a multivendor network

Routing policies for networks are often complex and not well understood. Many books detail the operation of routing protocols such as OSPF or BGP, but none place the protocols in the context of routing policies and the real world of ISP peering...

The Moderator's Survival Guide: Handling Common, Tricky, and Sticky Situations in User Research
The Moderator's Survival Guide: Handling Common, Tricky, and Sticky Situations in User Research

The Moderator's Survival Guide is your indispensable resource for navigating the rocky shoals of your one-on-one user research sessions. Inside, you’ll find guidance for nearly 100 diverse situations (ranging from business-as-usual to tricky and sticky) that might occur during usability studies, contextual inquiries, or user...

©2019 LearnIT (support@pdfchm.net) - Privacy Policy