Key FeaturesStore, retrieve and manipulate you data, and design efficient database solutions with latest MySQL 8 featuresPractical recipes on efficient MySQL administration, with tips on effective user management, security, database monitoring, performance tuning, troubleshooting and more.Practical tips and tricks to give you the edge over others while designing, developing and administering your database.Book DescriptionMySQL is one of the most popular and widely used relational databases in the world today. With the recently released MySQL 8, it promises to be better and more efficient than ever, giving you high performance, more features and additional support as document store.This book contains everything you need to know to be the go-to person in your organization when it comes to MySQL. Starting with a quick installation and configuration of your MySQL instance, the book quickly jumps into the querying aspects of MySQL, shows you the newest improvements in MySQL 8 and gives you experience in managing high-transaction, real-time and huge data sets. If you’ve already worked with MySQL before and are looking to migrate your application to MySQL 8, this book will also show you how to do that. The book also contains practical recipes on efficient MySQL administration, with tips on effective user management, security, database monitoring, performance tuning, troubleshooting and more. Right from quick solutions to the common problems you might encounter while working with MySQL, the book contains practical tips and tricks to give you the edge over others while designing, developing and administering your database.What you will learnInstall and configure your MySQL 8 instance without any hassleConnect and query MySQL using drivers of different languagesPerform backup tasks and set up replication for your databaseRecover data from mysqldump and mydumperManage and monitor your MySQL instance and implement efficient performance tuning tasksTroubleshoot your MySQL database for any issues and ensure high performanceAbout the AuthorKarthik Appigatla is a highly reputed MySQL Database Architect and is very famous for performance tuning. He has been working on various large scale data stores for 9 years primarily focused on MySQL. He started his career as a Systems Engineer at Yahoo, where he was responsible for managing most critical databases like advertising, mail, flickr etc. Later he worked as Sr. Database Consultant at Percona and helped clients scale/tune their high-transaction databases. He was consulted by many startups all over the world for designing, performance tuning and buidling the database infrastructure. From last 5 years, he has been providing online and onsite corporate trainings for many companies. Currently he is working as Sr. Database Engineer building the database as a service model at LinkedIn.
Author: Karthik Appigatla