LEADER 03314nam 2200421 450 001 9910807416103321 005 20200520144314.0 035 $a(CKB)4970000000061414 035 $a(MiAaPQ)EBC5675584 035 $a(CaSebORM)9781788834445 035 $a(Au-PeEL)EBL5675584 035 $a(OCoLC)1086057392 035 $a(EXLCZ)994970000000061414 100 $a20190220d2019 uy| 0 101 0 $aeng 135 $aurcn| ||||| 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aAdvanced MySQL 8 $ediscover the full potential of MySQL and ensure high performance of your database /$fEric Vanier, Birju Shah, Tejaswi Malepati 205 $a1st edition 210 1$aBirmingham :$cPackt,$d2019. 215 $a1 online resource (286 pages) 300 $aIncludes index. 311 $a1-78883-444-5 330 $aDesign 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. 606 $aSQL (Computer program language) 615 0$aSQL (Computer program language) 700 $aVanier$b Eric$01605761 702 $aShah$b Birju 702 $aMalepati$b Tejaswi 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910807416103321 996 $aAdvanced MySQL 8$93931190 997 $aUNINA