| Description |
1 online resource (501 pages) |
|
text file |
| Contents |
Cover; Copyright and Credits; Packt Upsell; Contributors; Table of Contents; Preface; Chapter 1: An Introduction to MYSQL 8; Overview of MySQL; MySQL as a relational database management system; License requirements of MySQL8; Reliability and scalability; Platform compatibility; Releases; Core features in MySQL; Structured database; Database storage engines and types; Overview of InnoDB; Overview of MyISAM; Overview of memory; Overview of archive; Overview of BLACKHOLE as a storage engine; Overview of CSV; Overview of merge; Overview of federated; Overview of the NDB cluster. |
|
Improved features in MySQL 8Transactional data dictionary; Roles; InnoDB auto increment; Invisible indexes; Improving descending indexes; The SET PERSIST variant; Expanded GIS support; Default character set; Extended bit-wise operations; InnoDB Memcached; NOWAIT and SKIP LOCKED; JSON; Cloud; Resource management; Benefits of using MySQL 8; Security; Scalability; An open source relational database management system; High performance; High availability; Cross-platform capabilities; Limitations of MySQL 8; Number of tables or databases; Table size; Joins; Windows platform. |
|
Table column countRow size; InnoDB storage engine; Limitations of InnoDB storage engine; Restrictions; Data dictionary; Limitations of group replication in MySQL8; Limitations of partitioning; Constructs prohibition; Operators; Tables; Use cases of MySQL; Social media; Government; Media and entertainment; Fraud detection; Business mapping; E-commerce; Summary; Chapter 2: Installing and Upgrading MySQL 8; The MySQL 8 installation process; General installation guide; Downloading MySQL 8; Verifying the package integrity; Using MD5 checksums; Using cryptographic signatures. |
|
Installing MySQL 8 on Microsoft WindowsWindows-specific considerations; MySQL 8 installation layout; Choosing the right installation package; The MySQL 8 installer; Initial setup information; Installation workflow; InnoDB cluster sandbox test setup; Server configuration; MySQL installer product catalog and dashboard; MySQL installer console; MySQL 8 installation using a ZIP file; Installing MySQL 8 on Linux; Installation using the Yum repository; Installation using the RPM package; Installation using the Debian package; Post-installation setup for MySQL 8; Data directory initialization. |
|
Securing the initial MySQL accountStarting and troubleshooting MySQL 8 services; Executing commands to test the server; Upgrading MySQL 8; Upgrading methods; In-place upgrade of MySQL; Logical upgrade for MySQL 8; Upgrading prerequisites for MySQL 5.7; MySQL 8 downgrading; Downgrading methods; Logical downgrade; Manual changes required before downgrading; Summary; Chapter 3: MySQL 8 â#x80;#x93; Using Programs and Utilities; Overview of MySQL 8 programs; MySQL programs in brief; Startup programs; Installation/upgradation programs; Client programs; Administrative and utilities programs |
| Note |
Environment variables. |
| Summary |
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 your MySQL solution can be administered. This book starts with a brief introduction to the newly introduced features in MySQL 8, followed by quickly jumping onto the crucial ... |
| Local Note |
eBooks on EBSCOhost EBSCO eBook Subscription Academic Collection - North America |
| Subject |
MySQL (Electronic resource)
|
|
MySQL (Electronic resource) |
|
MySQL (Electronic resource) |
|
Seattle Quality Listings (Firm)
|
| Genre/Form |
Electronic books.
|
| Added Author |
Oza, Hetal.
|
|
Bhavsar, Ankit K.
|
|
Śāha, Subhāsha.
|
| Other Form: |
Print version: Mehta, Chintan. MySQL 8 Administrator's Guide : Effective guide to administering high-performance MySQL 8 solutions. Birmingham : Packt Publishing, ©2018 |
| ISBN |
9781788393843 (electronic book) |
|
1788393848 (electronic book) |
|
1788395190 |
|
9781788395199 |
| Standard No. |
9781788395199 |
|
