MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration
by: Karthik Appigatla
ISBN-10: 1788395808
ISBN-13: 9781788395809
Released: 2018-01-25
Pages: 446
MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration
Design and administer enterprise-grade MySQL 8 solutions
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-transaction and real-time datasets. 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 recipes on efficient MySQL administration,with tips on effective user management,data recovery,security,database monitoring,performance tuning,troubleshooting,and more.
With quick solutions to common and not-so-common problems you might encounter while working with MySQL 8,the book contains practical tips and tricks to give you the edge over others in designing,developing,and administering your database effectively.
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
MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration
未经允许不得转载:finelybook » MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration
相关推荐
- Microsoft 365 Copilot At Work: Using AI to Get the Most from Your Business Data and Favorite Apps
- Real-World Edge Computing: Scale, secure, and succeed in the realm of edge computing with Open Horizon
- Salesforce DevOps for Architects: Discover tools and techniques to optimize the delivery of your Salesforce projects
- Segment Routing in MPLS Networks: Transition from traditional MPLS to SR-MPLS with TI-LFA FRR
- Unveiling NIST Cybersecurity Framework 2.0: Secure your organization with the practical applications of CSF
- Mastering DevOps on Microsoft Power Platform: Build, deploy, and secure low-code solutions on Power Platform using Azure DevOps and GitHub