舉報 
會員
MySQL 8 for Big Data
Shabbir Challawala Jaydip Lakhatariya Chintan Mehta Kandarp Patel 著
更新時間：2021-08-20 10:06:58
開會員，本書免費讀 >
最新章節：
Summary
ThisbookisintendedforMySQLdatabaseadministratorsandBigDataprofessionalslookingtointegrateMySQL8andHadooptoimplementahighperformanceBigDatasolution.SomepreviousexperiencewithMySQLwillbehelpful,althoughthebookwillhighlightthenewerfeaturesintroducedinMySQL8.
最新章節
- Summary
- Organizing and analyzing data in Hadoop
- Real-time integration with MySQL Applier
- Hive
- FindHDFS.cmake
- gcc
品牌：中圖公司
上架時間：2021-08-20 09:46:58
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Summary 更新時間：2021-08-20 10:06:58
- Organizing and analyzing data in Hadoop
- Real-time integration with MySQL Applier
- Hive
- FindHDFS.cmake
- gcc
- cmake
- libhdfs
- MySQL Applier installation
- MySQL Applier overview
- Comparison of Tools
- Dell Shareplex
- Talend
- Apache Kafka
- Tungsten replicator
- Sqoop
- SQL Dump and Import
- MySQL Applier
- Case study overview
- Case study: Part II - Real time event processing using MySQL applier
- Summary
- Sqoop saved jobs
- Sqoop export for storing structured data from MySQL 8
- Loading structured data to MySQL using Apache Sqoop
- Incremental imports using Sqoop
- Sqoop import for fetching data from MySQL 8
- Importing unstructured data to Hadoop HDFS from MySQL
- Configuring MySQL connector
- Installing Apache Sqoop
- Setting up Hadoop on Linux
- YARN
- Hadoop distributed file system
- MapReduce
- Hadoop
- Integrating Apache Sqoop with MySQL and Hadoop
- Apache Sqoop overview
- Using MySQL 8 and Hadoop for analyzing log
- Case study for log analysis
- Case study: Part I - Apache Sqoop for exchanging data between MySQL and Hadoop
- Summary
- NDB API with C++
- NDB API for Java
- NDB API for NodeJS
- NDB Cluster API
- NoSQL API with Perl
- NoSQL API with Python
- NoSQL API with PHP
- NoSQL API with Java
- Prerequisites
- NoSQL with the Memcached API layer
- Implementing NoSQL APIs
- NoSQL versus SQL
- Best for big data
- Less management
- Scaling
- Changing rapidly over time
- NoSQL overview
- NoSQL API for Integrating with Big Data Solutions
- Summary
- Write scalability
- Contradictory workloads
- Constant throughput
- Infrastructure sizing
- Throughput in group replication
- Best practices for replication
- Memcached general statistics
- Caching mechanism
- Namespaces
- Failover
- Restrict exposure
- Sensitive data
- Large pages support
- Backlog queue limit
- Max object size
- Default configurations
- Operating system architecture
- Resource allocation
- Best practices for the Memcached configuration
- Query cost
- Analyze slow queries
- Limit yourself
- Existence of data
- Application does the job
- Fetch all data
- Index everything
- Shorten up primary keys
- Compound index
- Data types and joins
- Search fields index
- Indexing
- Not null
- Data types
- Best practices for MySQL queries
- Benchmarks
- Nerves of your query
- Hidden workloads
- Concurrency
- Virtualization world
- Sysbench can do more
- Consistency of throughput and latency
- Replicating production settings
- Stretch your timelines of benchmarks
- Resource utilization
- MySQL benchmarks and configurations
- MySQL 8 Best Practices
- Summary
- Bootstrap node
- Starting group replication
- Configuring a Replication User and enabling the Group Replication Plugin
- Host-specific configuration settings
- Choosing a single master or multi-master
- Group replication settings
- Group replication configuration
- Requirements for group replication
- Group replication
- Statement-based versus row-based replication
- Multi-source replication configuration
- MySQL multi-source replication
- GTID slave's side configurations
- GTID master's side configurations
- The gtid_executed table
- Global transaction identifiers
- Replication with GTIDs
- Replication slave configuration
- Replication master configuration
- Replication with binary log file
- Replication configuration
- Replication using global transaction identifiers
- Replication using binary logs
- Methods of replication in MySQL 8
- Geographical data sharing
- Large data analysis
- Secure architecture
- Scalable applications
- Benefits of replication in MySQL 8
- Replication with MySQL
- MySQL with the Solaris cluster
- Oracle MySQL cloud service
- MySQL cluster
- MySQL replication
- High availability
- Replication for building highly available solutions
- Summary
- INSERT query with the partition option
- UPDATE query with the partition option
- DELETE query with the partition option
- Querying on partitioned data
- Pruning with key partitioning
- Pruning with list partitioning
- Pruning partitions in MySQL
- Fifth normal form
- Fourth normal form
- Boyce-Codd normal form
- Third normal form
- Second normal form
- First normal form
- Data normalization
- Splitting data into multiple tables
- Vertical partitioning
- Sub partitioning
- Key partitioning
- List column partitioning
- Range column partitioning
- Column partitioning
- Hash partitioning
- List partitioning
- Range partitioning
- Horizontal partitioning in MySQL 8
- Vertical partitioning
- Horizontal partitioning
- Partitioning types
- What is partitioning?
- Partitioning in MySQL 8
- Partitioning High Volume Data
- Summary
- Memcached with Python
- Memcached with Ruby
- Memcached with PHP
- Memcached with Java
- Memcached APIs for different technologies
- Memcached replication configuration
- Analyzing data stored in Memcached
- Easy to use
- Caching tool
- Performance tuner
- Using of Memcached
- Verification
- Installation
- Setting up Memcached
- Overview of Memcached
- Using Memcached with MySQL 8
- Summary
- Defining indexes on JSON
- Stored generated columns
- Virtual generated columns
- Generated columns
- Indexing JSON data
- Spatial indexes
- Differentiating full-text indexing and like queries
- Fulltext search in Boolean mode
- Fulltext indexing on InnoDB
- Natural language fulltext search on InnoDB and MyISAM
- Full-text indexing
- Dropping foreign keys
- SET DEFAULT
- NO ACTION
- SET NULL
- CASCADE
- RESTRICT
- Defining a foreign key in the MySQL table
- Descending indexes
- Invisible indexes
- Covering index
- Composite indexes in MySQL 8
- Defining a column index
- Unique keys
- Natural keys versus surrogate keys
- Primary indexes
- Defining a primary index
- MySQL 8 index types
- When to avoid indexing
- lock_option
- algorithm_option
- index_type
- VISIBILITY
- COMMENT
- With Parser
- KEY_BLOCK_SIZE
- Index_options
- Index_col_name
- UNIQUE | FULLTEXT | SPATIAL
- Creating or dropping indexes
- Hash indexes
- B-Tree indexes
- Dense indexes
- Sparse indexes
- Bitmap indexes
- Index structures
- MySQL indexing
- Indexing your data for High-Performing Queries
- Summary
- JSON_ARRAYAGG
- JSON_OBJECTAGG
- JSON
- Sum
- Count
- Average
- Maximum
- Minimum
- HAVING clause
- GROUP BY clause
- The importance of aggregate functions
- Aggregating data in MySQL 8
- Transactions in MySQL 8
- Replace
- Update
- Insert
- Insert replace and update statements in MySQL 8
- Optimizing SELECT statements
- Subquery
- UNION
- CROSS JOIN
- RIGHT JOIN
- LEFT JOIN
- INNER JOIN
- SQL JOINS
- LIMIT clause
- ORDER BY clause
- BETWEEN
- IN/NOT IN
- LIKE
- Greater than and Less than
- Equal To and Not Equal To
- WHERE clause
- Select statement in MySQL 8
- NDB cluster
- Federated
- Merge
- CSV
- Blackhole
- Archive
- Memory
- Important notes about MyISAM tables
- MyISAM
- Important notes about InnoDB
- InnoDB
- Database storage engines and types
- Overview of SQL
- Data Query Techniques in MySQL 8
- Summary
- Results of analysis
- Analyzing data
- Organizing data in Hadoop
- Acquiring data in MySQL
- Evolution of MySQL for Big Data
- MySQL service commands
- MySQL 8 installation
- Obtaining MySQL 8
- Installing MySQL 8
- Cross-platform capabilities
- High availability
- High performance
- An open source relational database management system
- Scalability
- Security
- Benefits of using MySQL
- NOWAIT and SKIP LOCKED
- InnoDB Memcached
- Extended bit-wise operations
- The default character set
- Expanded GIS support
- SET PERSIST
- Improving descending indexes
- Supporting invisible indexes
- InnoDB auto increment
- Roles
- Transactional data dictionary
- New features in MySQL 8
- Releases
- Platform compatibility
- Reliability and scalability
- Licensing
- MySQL as a relational database management system
- Basics of MySQL
- Structured databases
- Governance
- Analyze
- Store
- Collect
- Phases of the Big Data life cycle
- Veracity
- Velocity
- Variety
- Volume
- The life cycle of Big Data
- Business mapping
- Healthcare
- Fraud detection
- Power and energy
- Science and research
- Politics
- Social media
- The importance of Big Data
- Introduction to Big Data and MySQL 8
- Questions
- Piracy
- Errata
- Downloading the color images of this book
- Downloading the example code
- Customer support
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Customer Feedback
- Why subscribe?
- www.PacktPub.com
- About the Reviewers
- About the Authors
- Credits
- MySQL 8 for Big Data
- Copyright
- Title Page
- coverpage
- coverpage
- Title Page
- Copyright
- MySQL 8 for Big Data
- Credits
- About the Authors
- About the Reviewers
- www.PacktPub.com
- Why subscribe?
- Customer Feedback
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Downloading the color images of this book
- Errata
- Piracy
- Questions
- Introduction to Big Data and MySQL 8
- The importance of Big Data
- Social media
- Politics
- Science and research
- Power and energy
- Fraud detection
- Healthcare
- Business mapping
- The life cycle of Big Data
- Volume
- Variety
- Velocity
- Veracity
- Phases of the Big Data life cycle
- Collect
- Store
- Analyze
- Governance
- Structured databases
- Basics of MySQL
- MySQL as a relational database management system
- Licensing
- Reliability and scalability
- Platform compatibility
- Releases
- New features in MySQL 8
- Transactional data dictionary
- Roles
- InnoDB auto increment
- Supporting invisible indexes
- Improving descending indexes
- SET PERSIST
- Expanded GIS support
- The default character set
- Extended bit-wise operations
- InnoDB Memcached
- NOWAIT and SKIP LOCKED
- Benefits of using MySQL
- Security
- Scalability
- An open source relational database management system
- High performance
- High availability
- Cross-platform capabilities
- Installing MySQL 8
- Obtaining MySQL 8
- MySQL 8 installation
- MySQL service commands
- Evolution of MySQL for Big Data
- Acquiring data in MySQL
- Organizing data in Hadoop
- Analyzing data
- Results of analysis
- Summary
- Data Query Techniques in MySQL 8
- Overview of SQL
- Database storage engines and types
- InnoDB
- Important notes about InnoDB
- MyISAM
- Important notes about MyISAM tables
- Memory
- Archive
- Blackhole
- CSV
- Merge
- Federated
- NDB cluster
- Select statement in MySQL 8
- WHERE clause
- Equal To and Not Equal To
- Greater than and Less than
- LIKE
- IN/NOT IN
- BETWEEN
- ORDER BY clause
- LIMIT clause
- SQL JOINS
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- CROSS JOIN
- UNION
- Subquery
- Optimizing SELECT statements
- Insert replace and update statements in MySQL 8
- Insert
- Update
- Replace
- Transactions in MySQL 8
- Aggregating data in MySQL 8
- The importance of aggregate functions
- GROUP BY clause
- HAVING clause
- Minimum
- Maximum
- Average
- Count
- Sum
- JSON
- JSON_OBJECTAGG
- JSON_ARRAYAGG
- Summary
- Indexing your data for High-Performing Queries
- MySQL indexing
- Index structures
- Bitmap indexes
- Sparse indexes
- Dense indexes
- B-Tree indexes
- Hash indexes
- Creating or dropping indexes
- UNIQUE | FULLTEXT | SPATIAL
- Index_col_name
- Index_options
- KEY_BLOCK_SIZE
- With Parser
- COMMENT
- VISIBILITY
- index_type
- algorithm_option
- lock_option
- When to avoid indexing
- MySQL 8 index types
- Defining a primary index
- Primary indexes
- Natural keys versus surrogate keys
- Unique keys
- Defining a column index
- Composite indexes in MySQL 8
- Covering index
- Invisible indexes
- Descending indexes
- Defining a foreign key in the MySQL table
- RESTRICT
- CASCADE
- SET NULL
- NO ACTION
- SET DEFAULT
- Dropping foreign keys
- Full-text indexing
- Natural language fulltext search on InnoDB and MyISAM
- Fulltext indexing on InnoDB
- Fulltext search in Boolean mode
- Differentiating full-text indexing and like queries
- Spatial indexes
- Indexing JSON data
- Generated columns
- Virtual generated columns
- Stored generated columns
- Defining indexes on JSON
- Summary
- Using Memcached with MySQL 8
- Overview of Memcached
- Setting up Memcached
- Installation
- Verification
- Using of Memcached
- Performance tuner
- Caching tool
- Easy to use
- Analyzing data stored in Memcached
- Memcached replication configuration
- Memcached APIs for different technologies
- Memcached with Java
- Memcached with PHP
- Memcached with Ruby
- Memcached with Python
- Summary
- Partitioning High Volume Data
- Partitioning in MySQL 8
- What is partitioning?
- Partitioning types
- Horizontal partitioning
- Vertical partitioning
- Horizontal partitioning in MySQL 8
- Range partitioning
- List partitioning
- Hash partitioning
- Column partitioning
- Range column partitioning
- List column partitioning
- Key partitioning
- Sub partitioning
- Vertical partitioning
- Splitting data into multiple tables
- Data normalization
- First normal form
- Second normal form
- Third normal form
- Boyce-Codd normal form
- Fourth normal form
- Fifth normal form
- Pruning partitions in MySQL
- Pruning with list partitioning
- Pruning with key partitioning
- Querying on partitioned data
- DELETE query with the partition option
- UPDATE query with the partition option
- INSERT query with the partition option
- Summary
- Replication for building highly available solutions
- High availability
- MySQL replication
- MySQL cluster
- Oracle MySQL cloud service
- MySQL with the Solaris cluster
- Replication with MySQL
- Benefits of replication in MySQL 8
- Scalable applications
- Secure architecture
- Large data analysis
- Geographical data sharing
- Methods of replication in MySQL 8
- Replication using binary logs
- Replication using global transaction identifiers
- Replication configuration
- Replication with binary log file
- Replication master configuration
- Replication slave configuration
- Replication with GTIDs
- Global transaction identifiers
- The gtid_executed table
- GTID master's side configurations
- GTID slave's side configurations
- MySQL multi-source replication
- Multi-source replication configuration
- Statement-based versus row-based replication
- Group replication
- Requirements for group replication
- Group replication configuration
- Group replication settings
- Choosing a single master or multi-master
- Host-specific configuration settings
- Configuring a Replication User and enabling the Group Replication Plugin
- Starting group replication
- Bootstrap node
- Summary
- MySQL 8 Best Practices
- MySQL benchmarks and configurations
- Resource utilization
- Stretch your timelines of benchmarks
- Replicating production settings
- Consistency of throughput and latency
- Sysbench can do more
- Virtualization world
- Concurrency
- Hidden workloads
- Nerves of your query
- Benchmarks
- Best practices for MySQL queries
- Data types
- Not null
- Indexing
- Search fields index
- Data types and joins
- Compound index
- Shorten up primary keys
- Index everything
- Fetch all data
- Application does the job
- Existence of data
- Limit yourself
- Analyze slow queries
- Query cost
- Best practices for the Memcached configuration
- Resource allocation
- Operating system architecture
- Default configurations
- Max object size
- Backlog queue limit
- Large pages support
- Sensitive data
- Restrict exposure
- Failover
- Namespaces
- Caching mechanism
- Memcached general statistics
- Best practices for replication
- Throughput in group replication
- Infrastructure sizing
- Constant throughput
- Contradictory workloads
- Write scalability
- Summary
- NoSQL API for Integrating with Big Data Solutions
- NoSQL overview
- Changing rapidly over time
- Scaling
- Less management
- Best for big data
- NoSQL versus SQL
- Implementing NoSQL APIs
- NoSQL with the Memcached API layer
- Prerequisites
- NoSQL API with Java
- NoSQL API with PHP
- NoSQL API with Python
- NoSQL API with Perl
- NDB Cluster API
- NDB API for NodeJS
- NDB API for Java
- NDB API with C++
- Summary
- Case study: Part I - Apache Sqoop for exchanging data between MySQL and Hadoop
- Case study for log analysis
- Using MySQL 8 and Hadoop for analyzing log
- Apache Sqoop overview
- Integrating Apache Sqoop with MySQL and Hadoop
- Hadoop
- MapReduce
- Hadoop distributed file system
- YARN
- Setting up Hadoop on Linux
- Installing Apache Sqoop
- Configuring MySQL connector
- Importing unstructured data to Hadoop HDFS from MySQL
- Sqoop import for fetching data from MySQL 8
- Incremental imports using Sqoop
- Loading structured data to MySQL using Apache Sqoop
- Sqoop export for storing structured data from MySQL 8
- Sqoop saved jobs
- Summary
- Case study: Part II - Real time event processing using MySQL applier
- Case study overview
- MySQL Applier
- SQL Dump and Import
- Sqoop
- Tungsten replicator
- Apache Kafka
- Talend
- Dell Shareplex
- Comparison of Tools
- MySQL Applier overview
- MySQL Applier installation
- libhdfs
- cmake
- gcc
- FindHDFS.cmake
- Hive
- Real-time integration with MySQL Applier
- Organizing and analyzing data in Hadoop
- Summary 更新時間：2021-08-20 10:06:58
