Design and administer enterprise-grade mysql8 solutionsAbout This Book• Store, retrieve, and manipulate your data using the latest mysql8 features• Practical recipes on effective administration in mysql, with a focu...
详细信息
ISBN:
(数字)9781788398442
ISBN:
(纸本)9781788395809
Design and administer enterprise-grade mysql8 solutions
About This Book
• Store, retrieve, and manipulate your data using the latest mysql8 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 mysql8 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 mysql8 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 mysql8 instance without any hassle
• Get to grips with new features of mysql8 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 mysql8 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 mysql8 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 mysql8 and gives you hands-on experience in managing high-t
暂无评论