Advanced MySQL 8

Discover the full potential of MySQL and ensure high performance of your database

Nonfiction, Computers, Database Management, Data Processing, General Computing
Cover of the book Advanced MySQL 8 by Eric Vanier, Birju Shah, Tejaswi Malepati, Packt Publishing
View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart
Author: Eric Vanier, Birju Shah, Tejaswi Malepati ISBN: 9781788833790
Publisher: Packt Publishing Publication: January 31, 2019
Imprint: Packt Publishing Language: English
Author: Eric Vanier, Birju Shah, Tejaswi Malepati
ISBN: 9781788833790
Publisher: Packt Publishing
Publication: January 31, 2019
Imprint: Packt Publishing
Language: English

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL

Key Features

  • Explore the new and advanced features of MySQL 8.0
  • Use advanced techniques to optimize MySQL performance
  • Create MySQL-based applications for your enterprise with the help of practical examples

Book Description

Advanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential.

By the end of this book, you’ll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments.

What you will learn

  • Explore new and exciting features of MySQL 8.0
  • Analyze and optimize large MySQL queries
  • Understand MySQL Server 8.0 settings
  • Master the deployment of Group Replication and use it in an InnoDB cluster
  • Monitor large distributed databases
  • Discover different types of backups and recovery methods for your databases
  • Explore tips to help your critical data reach its full potential

Who this book is for

Advanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.

View on Amazon View on AbeBooks View on Kobo View on B.Depository View on eBay View on Walmart

Design cost-efficient database solutions, scale enterprise operations and reduce overhead business costs with MySQL

Key Features

Book Description

Advanced MySQL 8 teaches you to enhance your existing database infrastructure and build various tools to improve your enterprise applications and overall website performance. The book starts with the new and exciting MySQL 8.0 features and how to utilize them for maximum efficiency. As you make your way through the chapters, you will learn to optimize MySQL performance using indexes and advanced data query techniques for large queries. You will also discover MySQL Server 8.0 settings and work with the MySQL data dictionary to boost the performance of your database. In the concluding chapters, you will cover MySQL 8.0 Group Replication, which will enable you to create elastic, highly available, and fault-tolerant replication topologies. You will also explore backup and recovery techniques for your databases and understand important tips and tricks to help your critical data reach its full potential.

By the end of this book, you’ll have learned about new MySQL 8.0 security features that allow a database administrator (DBA) to simplify user management and increase the security of their multi-user environments.

What you will learn

Who this book is for

Advanced MySQL 8 is for database administrators, data architects, and database developers who want to dive deeper into building advanced database applications in the MySQL environment.

More books from Packt Publishing

Cover of the book Mastering XenApp® by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Ext JS Data-driven Application Design by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Learning PostgreSQL 10 - Second Edition by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Mobile Forensics – Advanced Investigative Strategies by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book jQuery Essentials by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Multithreading with C# Cookbook - Second Edition by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book MooTools 1.2 Beginner's Guide by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Mobile Artificial Intelligence Projects by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Instant Simple Botting with PHP by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Kali Linux 2 – Assuring Security by Penetration Testing - Third Edition by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Clojure for Data Science by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book PhoneGap 3 Beginner's Guide by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book SAP Business ONE Implementation: LITE by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Advanced Splunk by Eric Vanier, Birju Shah, Tejaswi Malepati
Cover of the book Learning Spring Boot 2.0 - Second Edition by Eric Vanier, Birju Shah, Tejaswi Malepati
We use our own "cookies" and third party cookies to improve services and to see statistical information. By using this website, you agree to our Privacy Policy