MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration - Image 1

£41.99

Packt Publishing MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration

Name: MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration
Brand: Packt Publishing
Price: 41.99 GBP
Availability: InStock

Database Management Systems

Price History & Forecast

Last 30 days • 30 data points (No recent data available)

Historical

Generating forecast...

Price Distribution

Price distribution over 30 days • 1 price levels

Days at Price

Price Analysis

Most common price: £42 (30 days, 100.0%)

Price range: £42 - £42

Price levels: 1 different prices over 30 days

Description

Design and administer enterprise-grade MySQL 8 solutions Key Features 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 Book Description 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 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. Table of Contents Installation Using MySQL Using MySQL (Advanced) Configuring MySQL Transactions Binary Logging Backup Restoring data Replication Table Maintenance Managing Tablespace Managing Logs Performance Tuning Security

Product Specifications

Brand: Packt Publishing
Format: paperback
ASIN: 1788395808
Category: Books > Subjects > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
Domain: Amazon UK
Release Date: 25 January 2018
Listed Since: 08 August 2017

Barcode

No barcode data available

Packt Publishing MySQL 8 Cookbook: Over 150 recipes for high-performance database querying and administration

Price History & Forecast

Price Distribution

Price Analysis

Description

Product Specifications

Barcode

Similar Products You Might Like

Mastering MySQL Administration: High Availability, Security, Performance, and Efficiency

Hands-On MySQL Administration: Managing MySQL on Premises and in the Cloud

MySQL Cookbook: Solutions for Database Developers and Administrators

Hacking MySQL: Breaking, Optimizing, and Securing MySQL for Your Use Case

PHP and MySQL: The Comprehensive Guide

MySql Database Usage & Administration (PROGRAMMING & WEB DEV - OMG)

The complete set of definitive guides from MySQL Press

PHP 8 for Absolute Beginners: Basic Website and Web Application Development

MySQL Administrator's Bible

Modern Python Cookbook: 133 recipes to develop flawless and expressive programs in Python 3.8

MySQL Workbench: Data Modeling & Development (Oracle Press)

Data Engineering with Advanced Python: Learn to Build Production Data applications using Modern Cloud Data tools (Data Engineering with Python cookbook series)

PostgreSQL 16 Administration Cookbook: Solve real-world Database Administration challenges with 180+ practical recipes and best practices

PostgreSQL 14 Administration Cookbook: Over 175 proven recipes for database administrators to manage enterprise databases effectively

Beginning PHP and MySQL: From Novice to Professional (Expert's Voice in Web Development)

Professional Azure SQL Managed Database Administration: Efficiently manage and modernize data in the cloud using Azure SQL, 3rd Edition

Relational Database and Transact SQL Second Edition

Mastering PostgreSQL 15: Advanced techniques to build and manage scalable, reliable, and fault-tolerant database applications

Php and MySql Web Development: A Beginner's Guide

MySQL Concurrency: Locking and Transactions for MySQL Developers and DBAs

Web API Development with ASP.NET Core 8: Learn techniques, patterns, and tools for building high-performance, robust, and scalable web APIs

Murach's PHP and MySQL

Database Performance at Scale: A Practical Guide

Microsoft® SQL Server 2008 New Features