Items related to MySQL 9 Cookbook, Second Edition: Practical recipes...
MySQL 9 Cookbook, Second Edition: Practical recipes for installing, securing, optimizing, and scaling MySQL 9 in production - Softcover
Synopsis
This book is the perfect hands-on reference for any database administrator, backend developer or data engineer working with MySQL in production. It's organised into 75+ practical, task-driven recipes solving the real challenges that practitioners face every day. These include things like installing and hardening a MySQL 9 server, migrating from MySQL 5.7, MongoDB and PostgreSQL, diagnosing deadlocks and startup failures, tuning slow queries with EXPLAIN ANALYZE, configuring InnoDB Cluster for automatic failover, and implementing point-in-time recovery with the binary log and Clone Plugin.
This second edition looks at the most significant new features of MySQL 9, including the VECTOR data type for use with AI and machine learning workloads, the JavaScript Multilingual Engine powered by GraalVM, the updated InnoDB ClusterSet for high availability across multiple data centres, and the structured JSON error log. Every recipe is shown on a consistent, production-realistic sample platform, giving readers the context to apply each technique directly to their own environments. So, whatever you're doing, this cookbook's got you covered. It'll give you all the exact steps, commands, and explanations you need to get the job done.
Key Learnings
- Install, configure, and secure a production-ready MySQL 9 server on Linux.
- Migrate databases from MySQL 5.7, MongoDB, and PostgreSQL to MySQL 9.
- Tune InnoDB buffer pools, composite indexes, and slow queries for peak throughput.
- Configure GTID-based source-replica replication with automated health monitoring scripts.
- Build fault-tolerant InnoDB Clusters with automatic failover using MySQL Shell AdminAPI.
- Recover databases to a precise point in time using binary logs and mysqlbinlog.
- Secure MySQL 9 with AppArmor, transparent encryption, SSH tunneling, and RBAC roles.
- Store and search AI embedding vectors using MySQL 9's native VECTOR data type.
- Write JavaScript stored procedures using the MySQL Multilingual Engine and GraalVM.
- Diagnose deadlocks, table corruption, and startup failures with structured JSON logs.
Table of Content
- Installing and Configuring Database Server
- Migrating to New Server
- Managing MySQL Architecture and Storage Engines
- Securing Database Server
- Optimizing Queries and Performance
- MySQL Replication
- MySQL High Availability
- Backup, Recovery, and Maintenance
- Advanced Troubleshooting and Debugging
- Advanced Data Features
- JavaScript Stored Programs with MySQL MLE
"synopsis" may belong to another edition of this title.
Search results for MySQL 9 Cookbook, Second Edition: Practical recipes...
Stock Image
MySQL 9 Cookbook, Second Edition: Practical recipes for installing, securing, optimizing, and scaling MySQL 9 in production
Seller: California Books, Miami, FL, U.S.A.
Seller rating 4 out of 5 stars
Condition: New. Seller Inventory # I-9789349174955
Stock Image
MySQL 9 Cookbook, Second Edition
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # L2-9789349174955
Stock Image
MySQL 9 Cookbook, Second Edition
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
Seller rating 5 out of 5 stars
PAP. Condition: New. New Book. Shipped from UK. Established seller since 2000. Seller Inventory # L2-9789349174955
Buy New
US$ 72.85
US$ 5.66 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: Over 20 available
Stock Image
MySQL 9 Cookbook, Second Edition
Print on DemandSeller: BuchWeltWeit Ludwig Meier e.K., Bergisch Gladbach, Germany
Seller rating 5 out of 5 stars
Taschenbuch. Condition: Neu. This item is printed on demand - it takes 3-4 days longer - Neuware 168 pp. Englisch. Seller Inventory # 9789349174955
Buy New
US$ 78.04
US$ 26.85 shipping
Ships from Germany to U.S.A.
Ships from Germany to U.S.A.
Quantity: 2 available
Stock Image
MySQL 9 Cookbook, Second Edition (Paperback)
Print on DemandSeller: AussieBookSeller, Truganina, VIC, Australia
Seller rating 5 out of 5 stars
Paperback. Condition: new. Paperback. This book is the perfect hands-on reference for any database administrator, backend developer or data engineer working with MySQL in production. It's organised into 75+ practical, task-driven recipes solving the real challenges that practitioners face every day. These include things like installing and hardening a MySQL 9 server, migrating from MySQL 5.7, MongoDB and PostgreSQL, diagnosing deadlocks and startup failures, tuning slow queries with EXPLAIN ANALYZE, configuring InnoDB Cluster for automatic failover, and implementing point-in-time recovery with the binary log and Clone Plugin.This second edition looks at the most significant new features of MySQL 9, including the VECTOR data type for use with AI and machine learning workloads, the JavaScript Multilingual Engine powered by GraalVM, the updated InnoDB ClusterSet for high availability across multiple data centres, and the structured JSON error log. Every recipe is shown on a consistent, production-realistic sample platform, giving readers the context to apply each technique directly to their own environments. So, whatever you're doing, this cookbook's got you covered. It'll give you all the exact steps, commands, and explanations you need to get the job done.Key LearningsInstall, configure, and secure a production-ready MySQL 9 server on Linux.Migrate databases from MySQL 5.7, MongoDB, and PostgreSQL to MySQL 9.Tune InnoDB buffer pools, composite indexes, and slow queries for peak throughput.Configure GTID-based source-replica replication with automated health monitoring scripts.Build fault-tolerant InnoDB Clusters with automatic failover using MySQL Shell AdminAPI.Recover databases to a precise point in time using binary logs and mysqlbinlog.Secure MySQL 9 with AppArmor, transparent encryption, SSH tunneling, and RBAC roles.Store and search AI embedding vectors using MySQL 9's native VECTOR data type.Write JavaScript stored procedures using the MySQL Multilingual Engine and GraalVM.Diagnose deadlocks, table corruption, and startup failures with structured JSON logs.Table of ContentInstalling and Configuring Database ServerMigrating to New ServerManaging MySQL Architecture and Storage EnginesSecuring Database ServerOptimizing Queries and PerformanceMySQL ReplicationMySQL High AvailabilityBackup, Recovery, and MaintenanceAdvanced Troubleshooting and DebuggingAdvanced Data FeaturesJavaScript Stored Programs with MySQL MLE This item is printed on demand. Shipping may be from our Sydney, NSW warehouse or from our UK or US warehouse, depending on stock availability. Seller Inventory # 9789349174955
Buy New
US$ 91.11
US$ 37.00 shipping
Ships from Australia to U.S.A.
Ships from Australia to U.S.A.
Quantity: 1 available
Stock Image
MySQL 9 Cookbook, Second Edition (Paperback)
Print on DemandSeller: CitiRetail, Stevenage, United Kingdom
Seller rating 5 out of 5 stars
Paperback. Condition: new. Paperback. This book is the perfect hands-on reference for any database administrator, backend developer or data engineer working with MySQL in production. It's organised into 75+ practical, task-driven recipes solving the real challenges that practitioners face every day. These include things like installing and hardening a MySQL 9 server, migrating from MySQL 5.7, MongoDB and PostgreSQL, diagnosing deadlocks and startup failures, tuning slow queries with EXPLAIN ANALYZE, configuring InnoDB Cluster for automatic failover, and implementing point-in-time recovery with the binary log and Clone Plugin.This second edition looks at the most significant new features of MySQL 9, including the VECTOR data type for use with AI and machine learning workloads, the JavaScript Multilingual Engine powered by GraalVM, the updated InnoDB ClusterSet for high availability across multiple data centres, and the structured JSON error log. Every recipe is shown on a consistent, production-realistic sample platform, giving readers the context to apply each technique directly to their own environments. So, whatever you're doing, this cookbook's got you covered. It'll give you all the exact steps, commands, and explanations you need to get the job done.Key LearningsInstall, configure, and secure a production-ready MySQL 9 server on Linux.Migrate databases from MySQL 5.7, MongoDB, and PostgreSQL to MySQL 9.Tune InnoDB buffer pools, composite indexes, and slow queries for peak throughput.Configure GTID-based source-replica replication with automated health monitoring scripts.Build fault-tolerant InnoDB Clusters with automatic failover using MySQL Shell AdminAPI.Recover databases to a precise point in time using binary logs and mysqlbinlog.Secure MySQL 9 with AppArmor, transparent encryption, SSH tunneling, and RBAC roles.Store and search AI embedding vectors using MySQL 9's native VECTOR data type.Write JavaScript stored procedures using the MySQL Multilingual Engine and GraalVM.Diagnose deadlocks, table corruption, and startup failures with structured JSON logs.Table of ContentInstalling and Configuring Database ServerMigrating to New ServerManaging MySQL Architecture and Storage EnginesSecuring Database ServerOptimizing Queries and PerformanceMySQL ReplicationMySQL High AvailabilityBackup, Recovery, and MaintenanceAdvanced Troubleshooting and DebuggingAdvanced Data FeaturesJavaScript Stored Programs with MySQL MLE This item is printed on demand. Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability. Seller Inventory # 9789349174955
Buy New
US$ 79.12
US$ 50.32 shipping
Ships from United Kingdom to U.S.A.
Ships from United Kingdom to U.S.A.
Quantity: 1 available
Stock Image
MySQL 9 Cookbook, Second Edition
Print on DemandSeller: buchversandmimpf2000, Emtmannsberg, BAYE, Germany
Seller rating 5 out of 5 stars
Taschenbuch. Condition: Neu. This item is printed on demand - Print on Demand Titel. Neuware 168 pp. Englisch. Seller Inventory # 9789349174955
Buy New
US$ 78.04
US$ 70.04 shipping
Ships from Germany to U.S.A.
Ships from Germany to U.S.A.
Quantity: 1 available
Stock Image
MySQL 9 Cookbook, Second Edition : Practical recipes for installing, securing, optimizing, and scaling MySQL 9 in production
Seller: AHA-BUCH GmbH, Einbeck, Germany
Seller rating 5 out of 5 stars
Taschenbuch. Condition: Neu. Neuware. Seller Inventory # 9789349174955
Buy New
US$ 83.96
US$ 71.81 shipping
Ships from Germany to U.S.A.
Ships from Germany to U.S.A.
Quantity: 2 available
Seller Image
MySQL 9 Cookbook, Second Edition | Practical recipes for installing, securing, optimizing, and scaling MySQL 9 in production
Print on DemandSeller: preigu, Osnabrück, Germany
Seller rating 5 out of 5 stars
Taschenbuch. Condition: Neu. MySQL 9 Cookbook, Second Edition | Practical recipes for installing, securing, optimizing, and scaling MySQL 9 in production | Kyran Velos | Taschenbuch | Englisch | 2026 | GitforGits | EAN 9789349174955 | Verantwortliche Person für die EU: Libri GmbH, Europaallee 1, 36244 Bad Hersfeld, gpsr[at]libri[dot]de | Anbieter: preigu Print on Demand. Seller Inventory # 135647027
Buy New
US$ 74.67
US$ 81.72 shipping
Ships from Germany to U.S.A.
Ships from Germany to U.S.A.
Quantity: 5 available