Design and administer enterprise-grade mysql 8 solutionsAbout This Book• Store, retrieve, and manipulate your data using the latest mysql 8 features• Practical recipes on effective administration in mysql, with a focu...
详细信息
ISBN:
(数字)9781788398442
ISBN:
(纸本)9781788395809
Design and administer enterprise-grade mysql 8 solutions
About This Book
• Store, retrieve, and manipulate your data using the latest mysql 8 features
• Practical recipes on effective administration in mysql, with a focus on security, performance tuning, troubleshooting, and more
• Contains tips, tricks, and best practices for designing, developing, and administering your mysql 8 database solution without any hassle
Who This Book Is For
If you are a mysql developer or administrator looking for quick, handy solutions to solve the most common and not-so-common problems in mysql, this book is for you. mysql DBAs looking to get up-to-speed with the latest mysql 8 development and administration features will also find this book very useful. Prior knowledge of Linux and RDBMS is desirable.
What You Will Learn
• Install and configure your mysql 8 instance without any hassle
• Get to grips with new features of mysql 8 like CTE, Window functions and many more
• Perform backup tasks, recover data and set up various replication topologies for your database
• Maximize performance by using new features of mysql 8 like descending indexes, controlling query optimizer and resource groups
• Learn how to use general table space to suit the SaaS or multi-tenant applications
• Analyze slow queries using performance schema, sys schema and third party tools
• Manage and monitor your mysql instance and implement efficient performance-tuning tasks
In Detail
mysql is one of the most popular and widely used relational databases in the World today. The recently released mysql 8 version promises to be better and more efficient than ever before.
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. It shows you the newest improvements in mysql 8 and gives you hands-on experience in managing high-t
暂无评论