Advanced MySQL 8 2019.pdf

(12287 KB) Pobierz
Advanced MySQL 8
Discover the full potential of MySQL and ensure high
performance of your database
Eric Vanier
Birju Shah
Tejaswi Malepati
BIRMINGHAM - MUMBAI
Advanced MySQL 8
Copyright
©
2019 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form
or by any means, without the prior written permission of the publisher, except in the case of brief quotations
embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the information presented.
However, the information contained in this book is sold without warranty, either express or implied. Neither the
authors, nor Packt Publishing or its dealers and distributors, will be held liable for any damages caused or alleged to
have been caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the companies and products
mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy
of this information.
Commissioning Editor:
Pravin Dhandre
Acquisition Editor:
Namrata Patil
Content Development Editor:
Chris D'cruz
Technical Editor:
Nilesh Sawakhande
Copy Editor:
Safis Editing
Project Coordinator:
Namrata Swetta
Proofreader:
Safis Editing
Indexer:
Mariammal Chettiyar
Graphics:
Jisha Chirayil
Production Coordinator:
Nilesh Mohite
First published: January 2019
Production reference: 1310119
Published by Packt Publishing Ltd.
Livery Place
35 Livery Street
Birmingham
B3 2PB, UK.
ISBN 978-1-78883-444-5
www.packtpub.com
mapt.io
Mapt is an online digital library that gives you full access to over 5,000 books and videos, as
well as industry leading tools to help you plan your personal development and advance
your career. For more information, please visit our website.
Why subscribe?
Spend less time learning and more time coding with practical eBooks and Videos
from over 4,000 industry professionals
Improve your learning with Skill Plans built especially for you
Get a free eBook or video every month
Mapt is fully searchable
Copy and paste, print, and bookmark content
Packt.com
Did you know that Packt offers eBook versions of every book published, with PDF and
ePub files available? You can upgrade to the eBook version at
www.packt.com
and as a print
book customer, you are entitled to a discount on the eBook copy. Get in touch with us at
customercare@packtpub.com
for more details.
At
www.packt.com
, you can also read a collection of free technical articles, sign up for a
range of free newsletters, and receive exclusive discounts and offers on Packt books and
eBooks.
Contributors
About the authors
Eric Vanier
is one of the few DBAs worldwide specializing in MySQL performance, and is
an expert with large architectures such as those for Air Miles, Cogeco, McGill University,
Bombardier Aerospace, and many more. As a senior DBA and instructor for 18 years, he
has a track record in performance and troubleshooting on dozens of high-profile MySQL
systems, including complex cluster environments.
I want to thank my wife, Sia, who helped edit this book, and for her encouragement as well.
Birju Shah
is the principal architect for Endurance International Group. He has a bachelor's
degree in computer engineering from Gujarat University. He has the experience and
expertise to build scalable products for hosting domains. He is passionate about the latest
architectural patterns, tools, and technologies, and he helps organizations to follow best
practices. He is also passionate about technical training and sessions.
I would like to thank my father, Bhupendra Shah; mother, Sheela Shah; my wife, Chiragi
Shah; and my cutie pie, Dhanya Shah, for their help and continuous support. I would also
like to thank my friends Jignesh Raval, Gopal Rohara, Rajeev Sahu, and Arnav Chaudhry
for their support and guidance. Special thanks to Ali and Chris for their continuous
support, and the Packt team for giving me the opportunity to contribute to a few chapters
of my first ever book.
Tejaswi Malepati
is the Cassandra Tech Lead for Target. He has been instrumental in
designing and building custom Cassandra integrations, including a web-based SQL
interface and data validation frameworks between Oracle and Cassandra. Tejaswi earned a
master's degree in computer science from the University of New Mexico, and a bachelor's
degree in electronics and communication from Jawaharlal Nehru Technological University
in India. He is passionate about identifying and analyzing data patterns in datasets using R,
Python, Spark, Cassandra, and MySQL.
I'd like to thank my family, friends, and team for their constant support and
encouragement in completing my second book.
Zgłoś jeśli naruszono regulamin