ebook img

MySQL Administrator's Bible (Bible (Wiley)) PDF

891 Pages·2009·4.5 MB·English
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview MySQL Administrator's Bible (Bible (Wiley))

MySQL® Administrator’s Bible MySQL® Administrator’s Bible Sheeri Cabral Keith Murphy Wiley Publishing, Inc. ® MySQL Administrator’s Bible Published by Wiley Publishing, Inc. 10475 Crosspoint Boulevard Indianapolis, IN 46256 www.wiley.com Copyright © 2009 by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada ISBN: 978-0-470-41691-4 Manufactured in the United States of America 10 9 8 7 6 5 4 3 2 1 Library of Congress Cataloging-in-Publication Data: Cabral,Sheeri, 1978- MySQL administrator’s bible / Sheeri Cabral, Keith Murphy. p. cm. Includes index. ISBN 978-0-470-41691-4 (paper/website) 1. MySQL (Electronic resource) 2. Database management.3. Relational databases. I. Cabral, Sheeri, 1970- II. Title. QA76.9.D3C3178 2009 005.75(cid:2)65 — dc22 2009005633 No part of this publication may be reproduced, stored in a retrievalsystem or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permit- ted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copy- right Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with respect to the accuracyor completeness of the contents of this work and specifically disclaim all warranties, including without limitation warrantiesof fitness for a particular purpose. No warrantymay be createdor extended by sales or promotional materials. The advice and strategies contained herein may not be suitable for everysituation. This work is sold with the understanding that the publisher is not engagedin rendering legal, accounting, or other professional services.If professional assistance is required, the servicesof a competent professional person should be sought. Neither the publisher nor the author shall be liable for damagesarising herefrom.The factthat an organization or Web site is referredto in this work as a citation and/or a potential source of further information does not meanthat the author or the publisher endorses the information the organization or Web site may provide or recommendations it may make.Further, readersshould be awarethat Internet Web sites listed in this work may have changed or disappeared between whenthis work waswritten and when it is read. For generalinformation on our other products and servicesplease contact our Customer Care Department within the United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002. Trademarks: Wiley and the Wiley logo are trademarksor registeredtrademarksof John Wiley & Sons, Inc. and/or its affiliates, in the United States and other countries, and may not be used without written permission. MySQL is a registeredtrademark of MySQL AB Company. All other trademarksare the property of their respec- tive owners. Wiley Publishing, Inc. is not associated with any product or vendor mentioned in this book. Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books. To Mitch Cherniack, who taught me databasesand inspired my love of them. In memory of Zvi Kramer and Yehoshua Kritzer — may I be able to echo their strength and spirit. — Sheeri Cabral For Rachel, the love of my life. — Keith Murphy About the Authors SheeriK. Cabralis a Database Team Lead at the Pythian Group, a remote database administra- tion solution. She has a master’s degree in computer science specializing in databases from Bran- deis University and a career background in systems administration.Unstoppableas a volunteer and activist since she was 14, Sheeri founded and organizes theBoston MySQL User Group.She also produces OurSQL: TheMySQL Database Podcast for the Community,By the Community and manyworkshop videos. These resources are freely available at www.technocation.org, the website of Technocation, Inc. Sheeri is the Treasurer of Technocation, Inc, a not-for-profit organization providingresources and educational grants for IT professionals. Sheeri currently lives in the Boston area with her husband TonyCabral and a myriad assortment of Muppets™ . When she’s not workingor volunteering,she reads, knits, listens to podcasts, and enjoys time with her nieces and nephews. Keith Murphy is a MySQL database administratorwho has been using MySQL server since 1998. A long-time Linux system administrator,he worked with a numberof Internet companies solving systems issues. More recentlyhe formed Paragon ConsultingServices (http://www.paragon-cs.com)to provideconsultingservices for companies seeking training for MySQL and help with MySQL solutionsranging from everyday database administration tasks to utilizing‘‘cloud’’ computingservices, performancetuning, and scaling. In addition to informationabout the company, Keith blogs at http://blog.paragon-cs.com,which he updates as frequentlyas possible with tricks, tips, and general informationabout MySQL server. In addition he is theeditor of MySQL Magazine (http://www.mysqlzine.net),the MySQL community’sdigital magazine about all thingsMySQL. It is his pleasure to work with some of the finest people in the communityin this collaborativeeffort to increase both the amount and qualityof the available informationon MySQL server. Readers are invited to contact Keith by email at [email protected].

Description:
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 da
See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.