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.

For database developers, administrators, engineers, and backend developers, MySQL 8 Cookbook provides solution-focused recipes. This book takes a practical approach to solving real-world problems by showing readers how to increase database security, enhance performance, and fix common MySQL issues through the use of numerous examples. You will learn how to install, configure, and tune MySQL for optimal performance in Linux environments. Important topics like backup strategies, security measures, query optimization, high availability, and replication are covered in each chapter. You will learn to partition and index datasets in a way that improves query performance, and the book provides step-by-step solutions to help them manage big datasets. With the help of this book, you can convert MySQL into a schema-less database that can manage unstructured data with ease, and it even handles modern data types like JSON. You can build fault-tolerant and scalable database systems including the implementation of multi-source replication, master-slave replication, and master-master replication. Problems like table corruption, excessive CPU and memory usage, deadlocks, and replication lag are addressed in the troubleshooting sections. Also shown are methods for automating and monitoring database security using Linux tools, cron jobs, and MySQL's performance schema. Whether you're managing enterprise databases or developing backend applications, this book will teach you to improve your database management skills and ensure peak performance for systems that are critical to business. Key Learnings Discover the ins and outs of installing, configuring, and optimizing MySQL 8 for high-performance database systems. Maximize database availability by implementing advanced replication setups, including master-master and multi-source. Take advantage of partitioning and indexing techniques to efficiently manage massive datasets and improve query performance. Use MySQL's relational and NoSQL features in combination to manage dynamic and schema-less data using JSON support. Use cron jobs and Linux-native tools to automate backups, recovery, and security audits. Find the cause of MySQL problems like table corruption, deadlocks, and replication lag and fix them. Implement strong firewall settings, encryption, and user access control to protect your MySQL environment. Use memory tuning and full-text search indexing to optimize MySQL performance and speed up queries. Use MySQL's performance schema in conjunction with Linux tools to keep an eye on system performance and resource usage. Table of Content Installing and Configuring MySQL 8 Optimizing MySQL Architecture and Storage Engines Securing MySQL Optimizing Queries and Performance Configuring MySQL Replication Enhancing MySQL High Availability Automating MySQL Maintenance and Updates Advanced MySQL Troubleshooting and Debugging Monitoring and Tuning MySQL Performance

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.

DESCRIPTION MySQL Cookbook – MySQL is a popular open-source database, and SQL is the top language for querying, creating, and managing data in databases. Developers and administrators widely use it for general and specific applications. MySQL powers business IT applications like CRM and ERP, APIs, web and e-commerce platforms, database management, data analytics, and increasingly, big data and data science projects. It starts with MySQL Workbench for beginners and moves to MySQL Shell for advanced scripting. Learn data redundancy, disaster recovery, and server connections in various languages. Core functions like SELECT, JOINs, INSERT, UPDATE, and DELETE are explained. Explore string, date, and time functions, sorting, stored procedures, triggers, and data manipulation. Finally, it covers user management, backups, performance, and security best practices. By the end of this book, you will be adept at interacting with MySQL databases, crafting efficient queries, and confidently managing your data for optimal performance and security. KEY FEATURES ● Gain confidence and skills to solve data problems with hands-on MySQL exercises. ● Learn practical MySQL skills by solving common database issues. ● Connect to servers, issue queries, retrieve data, and manage MySQL tasks. WHAT YOU WILL LEARN ● Connect to a server, issue queries, and retrieve results from MySQL Server. ● Store, retrieve, and manipulate strings and work with dates and times. ● Sort query results and generate aggregations. ● Use stored routines, triggers, and scheduled events. ● Perform basic MySQL administration tasks and monitoring fundamentals. WHO THIS BOOK IS FOR Whether you are a developer, an administrator, a faculty member teaching databases, or a student aiming to enhance your skills, this book provides valuable insights and hands-on knowledge to tackle database-related questions and problems effectively. TABLE OF CONTENTS 1. Using the MySQL Client Program 2. Using MySQL Shell 3. Using MySQL Replication 4. Writing MySQL-based Programs 5. Querying Data from Tables: Tables Management 6. Working with Strings 7. Working with Dates and Times 8. Sorting Query Results 9. Using Stored Routines, Triggers, and Scheduled Events 10. Importing and Exporting Data 11. Validating and Reformatting Data 12. Generating and Using Sequences 13. Working with JSON 14. Server Administration 15. Monitoring the Database Server and Security

Master Node.js 22 through expert-led recipes in async programming, app development, Fastify, modules, testing, debugging, and optimization Key Features Explore the latest Node.js 22 features to stay at the forefront of modern development Learn to build, debug, and deploy Node.js applications flawlessly Gain expertise in Fastify Web Framework, Node.js module creation, and advanced testing techniques Purchase of the print or Kindle book includes a free PDF eBook Book DescriptionNode.js is a game-changing technology for building modern web applications and tooling, bringing the power of JavaScript to the server and enabling full-stack development in a unified language. This updated edition of this Node.js cookbook, featuring Node.js 22, equips you with the latest advancements and enhancements in the Node.js framework ecosystem. From Bethany Griggs, who has served on the Node.js Technical Steering Committee and participated in the Node.js Release Working Group, and Manuel Spigolon, a core maintainer of Fastify, comes this fifth edition of the Node.js Cookbook to help you master Node.js 22. This book guides you step by step through crafting reusable code with Node.js modules, streamlining development using the Fastify web framework, and implementing data persistence in databases and rigorous testing practices for robust applications. You’ll address security concerns, optimize performance with worker threads, deploy Node.js microservices using containerization and orchestration, and tackle troubleshooting with effective debugging strategies. Packed with real-world examples, this guide empowers you to harness Node.js 22's full potential for creating secure, performant, and dynamic applications.What you will learn Grasp Node.js' async/sync programming to optimize code execution Build your coding skills from scratch by creating basic Node.js apps Debug and troubleshoot Node.js apps proficiently, ensuring smooth functionality Deploy apps confidently to production, reaching a wider user base Harness Fastify for web development to craft efficient frameworks Develop Node.js modules and enhance code reusability and project structure Who this book is for If you have basic knowledge of JavaScript or another programming language and want to build a solid understanding of Node.js, this book is for you. It provides the foundational knowledge you need to navigate the Node.js and npm ecosystem and start building applications. For readers with some Node.js experience, it offers the opportunity to deepen and expand their skills, while beginners can use practical recipes to quickly acquire a strong foundation in Node.js concepts and features.

Automation through Chef Opscode provides an in-depth understanding of Chef, which is written in Ruby and Erlang for configuration management, cloud infrastructure management, system administration, and network management. Targeted at administrators, consultants, and architect, the book guides them through the advanced features of the tool which are necessary for infrastructure automation, devops automation, and reporting. The book presumes knowledge of Ruby and Erlang which are used as reference languages for creating recipes and cookbooks and as a refresher on them to help the reader get on speed with the flow of book. The book provides step by step instructions on installation and configuration of Chef, usage scenarios of Chef, in infrastructure automation by providing common scenarios like virtual machine provisioning, OS configuration for Windows, Linux, and Unix, provisioning and configuration of web servers like Apache along with popular databases like MySQL. It further elaborates on the creation of recipes, and cookbooks, which help in deployment of servers and applications to any physical, virtual, or cloud location, no matter the size of the infrastructure. The books covers advanced features like LWRPs and Knife and also contains several illustrative sample cookbooks on MySQL, Apache, and CouchDB deployment using a step by step approach.

The Beginner Cookbook You've Been Searching For! ◆21 full recipes! ◆Powerful skills interestingly presented! ◆Zero CLI! ◆100% Management Console! ◆Core AWS Services In a desire to garner practical skills, AWS beginners often find themselves combing through stacks of instructional videos, blogs and documentation, that run through confusing lines of commands and codes which leave them wondering if AWS is really as simple as they say it is. This recipe book contains 21 thorough recipes that are all deliberately cooked through the AWS Management Console, in order to spare you the frustration of copying and pasting commands that are to you, at this stage, incomprehensible jargons which give you the finished product but still leave you clueless on the real process. In this book, you will fix recipes with a wide range of AWS services including DynamoDB, AWS Lambda, EC2, Amplify, S3, IAM, VPC, Transfer Family, API Gateway, RDS, EFS, Route 53 and more. Each recipe is carefully designed to stand independent of the rest while remaining somewhat connected, thus achieving the effect of both building the skills you’ve acquired from other recipes, and at the same introducing you to new concepts, methods and skills as you go along. The end product of this book is that, not only will you no longer be in a position where you have theoretical cloud knowledge without practical cloud skills, you will have 21 defendable and repeatable real world projects under your belt! When you’re done with this book, you would have become one with the process, and like a real Master Chef, you will be able to light the fire anywhere and fix the meals without opening the book.

Discover practical recipes to help you efficiently monitor enterprise IT infrastructure for Microsoft Windows, Linux, networking, and more Key Features Find out how you can leverage some of the most exciting features of Zabbix 6 Perform professional IT infrastructure and application monitoring on multiple platforms Discover easy-to-follow, practical solutions to problems in network monitoring with Zabbix Book DescriptionThis updated second edition of the Zabbix 6 IT Infrastructure Monitoring Cookbook brings you new recipes, updated with Zabbix 6 functionality. You'll learn how to set up Zabbix with built-in high availability, use the improved Business Service Monitoring, set up automatic reporting, and create advanced triggers. Zabbix offers useful insights into your infrastructure performance and issues and enables you to enhance your monitoring setup with its powerful features. This book covers hands-on, easy-to-follow recipes for using Zabbix 6 to monitor effectively the performance of devices and applications over the network. You'll start by working your way through the installation and most prominent features of Zabbix and make the right design choices for building a scalable and easily manageable environment. This Zabbix book contains recipes for building items and triggers for different types of monitoring, building templates, and using Zabbix proxies. Next, you'll use the Zabbix API for customization and manage your Zabbix server and database efficiently. Finally, you'll find quick solutions to the common and not-so-common problems that you may encounter in your Zabbix monitoring work. By the end of this book, you'll be able to use Zabbix for all your monitoring needs and build a solid Zabbix setup by leveraging its key functionalities.What you will learn Implement your high-availability Zabbix setup Build templates and explore the different types of monitoring available in Zabbix 6 Use Zabbix proxies to scale your environment effectively Work with custom integrations and the Zabbix API Set up advanced triggers and effective alerting Maintain your Zabbix setup for scaling, backups, and upgrades Discover how to perform advanced Zabbix database management Monitor cloud-based products such as Amazon Web Services (AWS), Azure, and Docker Who this book is for This book is for IT engineers who want to get started with Zabbix and anyone with an intermediate-level understanding of Zabbix looking to extend their knowledge. Although not necessary, prior experience with Zabbix will help you to make the most of this book.

Discover practical recipes to help you efficiently monitor enterprise IT infrastructure for Microsoft Windows, Linux, networking, and more Key Features Find out how you can leverage some of the most exciting features of Zabbix 7 Discover easy-to-follow, practical solutions for common problems in network monitoring with Zabbix Perform professional IT infrastructure and application monitoring across multiple platforms Purchase of the print or Kindle book includes a free PDF eBook Book DescriptionRealize the full potential of Zabbix 7 with this updated third edition of the Zabbix 7 IT Infrastructure Monitoring Cookbook. Packed with new recipes and updated with the latest Zabbix functionalities, this guide covers everything you need, whether you’re setting up Zabbix with built-in (proxy) high availability, using LDAP JIT user provisioning, implementing low-level host discovery, or creating advanced triggers. This hands-on guide offers easy-to-follow recipes to use Zabbix 7 to monitor the performance of devices and applications across your network. You'll start by learning how to install Zabbix and examine its most prominent features, ensuring you make the right design choices to build a scalable and easily manageable environment. Each recipe is crafted to help you build items and triggers for different types of monitoring, create templates, and use Zabbix proxies. You'll also get to grips with using the Zabbix API for customization and managing your Zabbix server and database. Finally, you'll find quick solutions to the common and not-so-common problems that you may encounter in your Zabbix monitoring work. By the end of this book, you'll have expert insights into using Zabbix for all your monitoring needs and be able to build a solid Zabbix setup by leveraging its key functionalities.What you will learn Implement a high-availability Zabbix setup for both server and proxies Build templates and explore various monitoring types available in Zabbix 7 Use Zabbix proxies to scale your environment effectively Work with custom integrations and the Zabbix API Set up advanced triggers and alerting Maintain your Zabbix setup for scaling, backups, and upgrades Perform advanced Zabbix database management Monitor cloud-based products such as Amazon Web Services (AWS), Azure, and Docker Who this book is for This book is for network and IT engineers who want to get started with Zabbix as well as those with an intermediate-level understanding of Zabbix looking to extend their knowledge. While prior experience with Zabbix is not a prerequisite, it will help you make the most of this book.

Efficiently integrate OAuth 2.0 to protect your mobile, desktop, Cloud applications and APIs using Spring Security technologies. About This Book Interact with public OAuth 2.0 protected APIs such as Facebook, LinkedIn and Google. Use Spring Security and Spring Security OAuth2 to implement your own OAuth 2.0 provider Learn how to implement OAuth 2.0 native mobile clients for Android applications Who This Book Is For This book targets software engineers and security experts who are looking to develop their skills in API security and OAuth 2.0. Prior programming knowledge and a basic understanding of developing web applications are necessary. As this book's recipes mostly use Spring Security and Spring Security OAuth2, some prior experience with Spring Framework will be helpful. What You Will Learn Use Redis and relational databases to store issued access tokens and refresh tokens Access resources protected by the OAuth2 Provider using Spring Security Implement a web application that dynamically registers itself to the Authorization Server Improve the safety of your mobile client using dynamic client registration Protect your Android client with Proof Key for Code Exchange Protect the Authorization Server from COMPUTERS / Cloud Computing redirection In Detail OAuth 2.0 is a standard protocol for authorization and focuses on client development simplicity while providing specific authorization flows for web applications, desktop applications, mobile phones, and so on. This book also provides useful recipes for solving real-life problems using Spring Security and creating Android applications. The book starts by presenting you how to interact with some public OAuth 2.0 protected APIs such as Facebook, LinkedIn and Google. You will also be able to implement your own OAuth 2.0 provider with Spring Security OAuth2. Next, the book will cover practical scenarios regarding some important OAuth 2.0 profiles such as Dynamic Client Registration, Token Introspection and how to revoke issued access tokens. You will then be introduced to the usage of JWT, OpenID Connect, and how to safely implement native mobile OAuth 2.0 Clients. By the end of this book, you will be able to ensure that both the server and client are protected against common vulnerabilities. Style and approach With the help of real-world examples, this book provides step by step recipes for troubleshooting and extending your API security. The book also helps you with accessing and securing data on mobile, desktop, and cloud apps with OAuth 2.0.