PDF Download MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy
MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy. Negotiating with reading practice is no demand. Reviewing MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy is not sort of something marketed that you can take or otherwise. It is a thing that will alter your life to life a lot better. It is the thing that will give you many points around the world and this cosmos, in the real life as well as below after. As exactly what will be made by this MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy, exactly how can you negotiate with the many things that has lots of benefits for you?
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy
PDF Download MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy
Why must pick the problem one if there is easy? Obtain the profit by buying guide MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy here. You will certainly get different means to make a deal and obtain guide MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy As known, nowadays. Soft file of the books MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy come to be incredibly popular with the viewers. Are you among them? As well as right here, we are offering you the new compilation of ours, the MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy.
As one of guide collections to recommend, this MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy has some solid reasons for you to check out. This book is very suitable with just what you need now. Besides, you will certainly additionally like this book MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy to review since this is one of your referred books to review. When going to get something brand-new based on experience, entertainment, and other lesson, you could use this book MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy as the bridge. Starting to have reading habit can be undertaken from numerous means as well as from alternative kinds of books
In reading MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy, currently you could not likewise do traditionally. In this modern era, gadget as well as computer system will certainly help you so much. This is the time for you to open up the device as well as stay in this website. It is the appropriate doing. You could see the link to download this MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy below, cannot you? Just click the link and make a deal to download it. You could reach purchase the book MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy by on-line and also ready to download and install. It is extremely different with the old-fashioned way by gong to guide store around your city.
Nonetheless, reading the book MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy in this site will lead you not to bring the published book everywhere you go. Simply keep the book in MMC or computer system disk as well as they are offered to check out any time. The thriving system by reading this soft data of the MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy can be leaded into something new routine. So currently, this is time to confirm if reading could enhance your life or otherwise. Make MySQL Administrator's Bible, By Sheeri K. Cabral, Keith Murphy it surely work and also obtain all benefits.
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.
- Sales Rank: #176456 in Books
- Published on: 2009-05-11
- Original language: English
- Number of items: 1
- Dimensions: 9.28" h x 1.96" w x 7.40" l, 3.30 pounds
- Binding: Paperback
- 888 pages
From the Back Cover
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.
Most helpful customer reviews
17 of 18 people found the following review helpful.
The best guide I've found to setting up and administering MySQL databases
By rdubbs
Some background first: I've used MySQL for two decently-sized programming projects in the past, on the developer side. More recently I was hired to design, build and administer the back-end of a web application. MySQL seemed the natural choice. With background only in the developer's role, I had a huge amount to learn.
I started out by buying the MySQL Administrator's Guide and Reference:
http://www.amazon.com/MySQL-Administrators-Guide-Language-Reference/dp/0672328704/ref=sr_1_4?ie=UTF8&s=books&qid=1244855803&sr=8-4
and a more general book on Database Administration:
http://www.amazon.com/Database-Administration-Complete-Practices-Procedures/dp/0201741296/ref=sr_1_1?ie=UTF8&s=books&qid=1244855921&sr=8-1
The former was pretty terrible, and it's all available online anyways so there's absolutely no reason to buy it. Why is it so bad? Despite being written by MySQL, it is completely impractical and totally bogged down with details. I defy you to figure out how to efficiently back up your database by using that guide. I couldn't.
The latter was very useful for introducing concepts like data normalization and, while a little out of date, gives a quick sense of the products that are out there. I highly recommend it as a first read. but it's not MySQL specific - so where to go then?
Finally, I found this book. It took me about 1 minute to find the tools I would need to back up a database and another 10 seconds to find a detailed discussion of what's going on when you back up a database.
It's also very recent (as of 2009/06) - it really reflects the state of the tools out there and I was pleasantly surprised to find that all of the developments I had been reading about in my online research were reflected in the book. Instead of glossing over complex topics like MySQL Cluster, memcached, DRBD, Linux HA (see, I wasn't kidding about its coverage), it points you to external resources that are actually helpful.
I haven't yet read all of it but, to my knowledge, there is nothing comparable out there. If you have a good idea of the basics behind database administration and need a practical guide to how to actually administer a MySQL database, including the tools available to you, I'd seriously recommend that you take a look at this book.
LIMITATIONS:
- I was a bit concerned about the book's information on early-stage tools like MySQL Proxy and MySQL 6.0. They haven't been released for general use and are not certified as stable, but the book just lists them with other tools as if you could just drop them in. Be careful.
- As another reader pointed out, it's not the easiest read. But then, if you've never used SQL, never mind MySQL before, then trying to understand concepts like the difference between READ COMMITTED and SERIALIZABLE isolation levels will surely result in pain and death. This book is much better if you have a question like "How do I backup a MySQL database?", "How do I make a trigger", or "How do I set up replication?"
9 of 9 people found the following review helpful.
MySQL Administrator's Bible - Review
By Mark Schoonover KA6WKE
On the front cover of MySQL Administrator's Bible is a sentence that reads:
"The book you need to succeed!"
I must say, I do agree. Authored by two very experienced DBAs, Sheeri Cabral and Keith Murphy, they've combined their talents to cover what you really need to know to succeed. This book is very versatile. If you're new to MySQL, or experienced in another database and have to start administrating MySQL, you need this book. I can honestly say, even if you have years of MySQL experience, you will learn something new. I did. Divided into four parts, MySQL Administrator's Bible covers your First Steps with MySQL, Developing with MySQL, Core MySQL Administration and Extending Your Skills.
First Steps with MySQL starts with a gentle introduction to MySQL with company information, which seems to be changing annually, and most importantly, the MySQL community itself. What makes MySQL so fantastic is the community. After that, you'll be lead into installing and configuring MySQL on various platforms including Linux, Windows and Solaris while touching on post installation configuration too. Basic security is covered as well as some tips on troubleshooting and accessing your new MySQL installation using tools included with MySQL or using third party software.
Developing with MySQL covers the MySQL Language Structure and if you're coming from another RDBMS, it covers how MySQL deviates from the SQL standard by extending that standard to make MySQL the number one open source database used on the Internet. After that, this section covers the same type of topics covering just about any other mainstream databases such as using stored procedures, cursors, events, views and transactions.
The Core MySQL Administration is the heart of this book. It covers MySQL server tuning, covering all major storage engines including MyISAM, InnoDB, Falcon, PBXT, and NDB engines including the first time I've seen in print, the Maria storage engine. An entire chapter is devoted to implementing cache tables and using the query cache. Memcached is also mentioned, and mentioned again in the final section. Continuing on with what I consider the most important job of a DBA, backup and recovery. Databases are very central to running a business, any data loss could put a company out of business. Be prepared.
This section gives a solid introduction to the topic of dealing with users, and how they are managed within MySQL. Count on covering GRANT/REVOKE, using SHOW GRANTS and mk-show-grants MaatKit tool. Partitioning, logging and replication and measuring performance rounds out this section.
If you have experience with another RDBMS, plan on spending a significant amount of time in this section. Not that the other sections aren't important, they are, but this is the bread and butter of what a MySQL DBA does on a daily basis.
Extending You Skills section can be considered getting your Masters in Database Administration. Just about every DBA will have to tackle improving queries and the tuning of indexes. The second most important job of a DBA is monitoring performance of your MySQL server. Don't let your users be your first line of monitoring! Be proactive, there are plenty of open source monitoring tools available. The most popular are discussed, as well as MySQL Enterprise and third party companies too. MySQL Data Dictionary is covered in in detail over 58 pages. This is the most I've read in any book about the data dictionary.
Last but not least, most high performance MySQL systems involve scaling up or out. It covers the usual suspects of replication, MySQL Cluster, and memcached. MySQL Proxy is initially covered and has an appendix to expand on that information. MySQL Proxy itself is worthy of its own book. (hint, hint :) ) Two more appendices cover MySQL Functions and Operators, and additional resources.
Even though this book targets MySQL 5.1/6.0, there is plenty of information that will apply to 5.0. If you're still on 5.0, don't hesitate to pick up a copy. This will be a book that can stay with you as your upgrade to 5.1 and beyond. The companion website - [...]contains all the code from the book too, rounding out this fine tome.
What didn't I like about the book? There are only a couple of things, all personal I'm sure. First, I really don't care too much for tables of options from the various tools. Most open source tools are developed rather quickly and options change. This could render portions of the book out of date quickly.
The other thing I noticed that wasn't mentioned in the book was the community versions of MySQL supported by Open Query and Percona. The latter has their own storage engine, XtraDB and backup solution, XtraBackup.
All in all, this is a very solid book on administering MySQL. This book digs deeper, the experience of the authors really show. Well done Sheeri and Keith!
Disclaimer: The publisher provided me with a copy of MySQL Administrator's Bible.
5 of 5 people found the following review helpful.
A good balance of reference and how-to
By B3n S6z
This is a comprehensive reference guide to MySQL that's accessible to beginning DBAs or DBAs familiar with another database. It has enough detail to be a useful companion throughout a DBA's career. It also covers many related technologies, such as memcached, at a moderate-but-useful level of detail. This isn't exactly a how-to book, and it isn't exactly a reference manual; it's more of a blend of the two.
The audience will depend on personal preferences. Some of the reference material is the type of thing I would look up with command-line --help options or the MySQL manual. But there are times when the reference aspect of the book is uniquely valuable. For example, the online documentation tends to list things alphabetically; the book might break them down into groups by function. An example is the sql_mode parameters, which it groups into categories like "Getting rid of silent failures, silent conversions, and silently allowing invalid data."
The book is divided into four parts: first steps, developing with MySQL, core administration, and a set of chapters and appendixes grouped under extending your skills. I think this organization works well.
Coverage is for MySQL 5.1 and 6.0. As far as I know, this book contains the most complete coverage of MySQL 5.1 in print.
By the way, I'm the lead author of High Performance MySQL: Optimization, Backups, Replication, and More and I think the two books are very complementary. If you're new to MySQL, then start with this book, and later you might consider reading mine as well.
See all 17 customer reviews...
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy PDF
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy EPub
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy Doc
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy iBooks
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy rtf
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy Mobipocket
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy Kindle
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy PDF
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy PDF
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy PDF
MySQL Administrator's Bible, by Sheeri K. Cabral, Keith Murphy PDF
