KNOWARTH Publishes a Book: MySQL 8 Administrator’s Guide
We are happy to announce the publishing of new book written and reviewed by our fellow KAites. The name of the book is “MySQL 8 Administrator’s Guide”. The book provides an effective guide to administering high-performance MySQL 8 solutions.
This book is for MySQL admins and database executives who are looking for a handy guide covering all the MySQL administration-related tasks. If you are a DBA looking to get started with MySQL administration, this book will help you.
Note – Knowledge of the basic database concepts is required to get started with this book.
MySQL is one of the most popular and widely used relational databases in the world today. The recently released version 8.0 brings along some major advancements in the way MySQL solution can be administered. This handbook will be your companion to understand the newly introduced features in MySQL and how you can leverage them to design a high-performance MySQL solution for your organization.
This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial admin topics that you will find useful in your day to day work. Topics such as migrating to MySQL 8, MySQL bench-marking, achieving high performance by implementing the indexing techniques, and optimizing your queries are covered in this book.
You will also learn how to perform replication, scale your MySQL solution and implement effective security techniques. A special section on the common and not so common troubleshooting techniques for effective MySQL administration is also covered in this book.
After reading this book, you will have all the knowledge you need to tackle any problem you might encounter while administering your MySQL solution.
What you will learn:
Understanding different MySQL 8 data types based on type of contents and storage requirements
Best practices for optimal use of features in MySQL 8
Explore globalization configuration and caching techniques to improve performance
Create custom storage engine as per system requirements
Learn various ways of index implementation for flash memory storages
Configure and implement replication along with approaches to use replication as solution
Understand how to make your MySQL 8 solution highly available
Troubleshoot common issues and identify error codes while using MySQL 8
There are many other hidden secrets to master MySQL database is enveloped in this book. You can purchase it on Amazon.in.
Chintan Mehta: As a Co-founder of KNOWARTH and Director of Cloud and RIMS silos, he has the knowledge and experience of working and integrating various databases. He is an AWS Certified Solutions Architect and has published books on Liferay and Hadoop technologies along with reviewing many other books. He has mastered the art of large database administration and has provided his expert opinion on leveraging MySQL features to design, build and maintain high-performance MySQL solutions.
Subhash Shah: He is principal consultant at KNOWARTH Technologies and has spent 11 years in the software industry working with many ERP and Database implementations. With his expertise in iDempiere and various other ERP suits, he has underscored the importance of secure databases and his citations will help MySQL administrators to easily manage MySQL8 with minimal disruptions.
Hetal Oza: She is our lead consultant and her expertise in SQL, Java, Unix and other large software development has helped shape this book from business perspective. She has shown the path by citing key pain areas for MySQL 8.0 administrators and execution methods for DBA queries, indexing techniques and performance optimization of MySQL database.
Ankit Bhavsar: Our senior Consultant for enterprise technology has shown his expertise in Java Enterprise Technologies/Tier with 6+ years of experience. With his Java enterprise technology and database expertise, he has listed all the modern MySQL8.0 features to ease the DBA issues.
We would like to especially thank reviewers of this book Sahaj Pathak and Ravi Shah who contributed immensely towards successfully publishing this book.
Ravi Shah is a Liferay/Java consultant. With his deep knowledge in versatile programming languages and experience in working with JAVA platform enables him to contribute towards database design, development, security and implementation. He as an MySQL8 Administrator has lent his knowledge in reviewing this book.
https://www.knowarth.com/wp-content/uploads/2018/01/4th-Birthday-Celebration_KNOWARTH.jpg4001140Krunal Vyashttps://www.knowarth.com/wp-content/uploads/2017/01/knowarth-logo.pngKrunal Vyas2018-01-18 16:07:232018-02-16 12:18:28Celebrating KNOWARTH's Foundation Day
https://www.knowarth.com/wp-content/uploads/2017/02/SAAS-based-productivity-management-suite.jpg6571920Krupal Khatrihttps://www.knowarth.com/wp-content/uploads/2017/01/knowarth-logo.pngKrupal Khatri2017-02-28 15:19:302017-02-28 16:39:41SAAS based productivity management suite
https://www.knowarth.com/wp-content/uploads/2016/12/Hospital-Management-System-with-Secure-Mobile-Application.jpg6571920KNOWARTH Adminhttps://www.knowarth.com/wp-content/uploads/2017/01/knowarth-logo.pngKNOWARTH Admin2016-12-30 17:41:182017-01-27 22:48:33Hospital Management System with Secure Mobile Application
https://www.knowarth.com/wp-content/uploads/2016/11/Amazon-Web-Services-AWS-to-Open-Stack-Migration.jpg6571920KNOWARTH Adminhttps://www.knowarth.com/wp-content/uploads/2017/01/knowarth-logo.pngKNOWARTH Admin2016-11-22 17:51:202017-01-30 11:46:29Amazon Web Services (AWS) to Open Stack Migration