MySQL Database

15.

Advanced MySQL Topics

15.1.

15.1.1.

Replication Fundamentals

15.1.1.1.

Master-Slave Architecture

15.1.1.2.

Data Synchronization

15.1.1.3.

High Availability Benefits

15.1.1.4.

Read Scaling Capabilities

15.1.2.

Replication Types

15.1.2.1.

Asynchronous Replication

15.1.2.1.1.

Default Replication Mode

15.1.2.1.2.

Performance Characteristics

15.1.2.1.3.

Consistency Considerations

15.1.2.2.

Semi-Synchronous Replication

15.1.2.2.1.

Enhanced Durability

15.1.2.2.2.

Performance Trade-offs

15.1.2.2.3.

Configuration Requirements

15.1.3.

Setting Up Replication

15.1.3.1.

Master Configuration

15.1.3.1.1.

Binary Logging Enablement

15.1.3.1.2.

Server ID Assignment

15.1.3.1.3.

User Account Creation

15.1.3.2.

Slave Configuration

15.1.3.2.1.

Master Connection Setup

15.1.3.2.2.

Replication User Configuration

15.1.3.2.3.

Initial Data Synchronization

15.1.3.3.

Replication Startup

15.1.3.3.1.

CHANGE MASTER Command

15.1.3.3.2.

START SLAVE Command

15.1.3.3.3.

Status Verification

15.1.4.

Replication Monitoring

15.1.4.1.

SHOW SLAVE STATUS

15.1.4.2.

Replication Lag Monitoring

15.1.4.3.

Error Detection and Resolution

15.1.5.

Advanced Replication Topologies

15.1.5.1.

Master-Master Replication

15.1.5.1.1.

Bidirectional Replication

15.1.5.1.2.

Conflict Resolution

15.1.5.1.3.

Auto-Increment Configuration

15.1.5.2.

Multi-Source Replication

15.1.5.2.1.

Multiple Master Sources

15.1.5.2.2.

Channel-Based Replication

15.1.5.2.3.

Selective Replication

15.1.5.3.

Circular Replication

15.1.5.3.1.

15.1.5.3.2.

Loop Prevention

15.1.5.3.3.

Failure Handling

15.2.

High Availability and Clustering

15.2.1.

High Availability Concepts

15.2.1.1.

Uptime Requirements

15.2.1.2.

Failover Mechanisms

15.2.1.3.

Data Consistency

15.2.1.4.

Service Continuity

15.2.2.

MySQL InnoDB Cluster

15.2.2.1.

Group Replication

15.2.2.1.1.

Multi-Master Clustering

15.2.2.1.2.

Automatic Failover

15.2.2.1.3.

Conflict Detection

15.2.2.2.

MySQL Shell Administration

15.2.2.2.1.

Cluster Management

15.2.2.2.2.

Node Administration

15.2.2.2.3.

Status Monitoring

15.2.2.3.

15.2.2.3.1.

Connection Routing

15.2.2.3.2.

15.2.2.3.3.

Failover Support

15.2.3.

Load Balancing Solutions

15.2.3.1.

15.2.3.1.1.

15.2.3.1.2.

Connection Pooling

15.2.3.1.3.

Read/Write Splitting

15.2.3.2.

HAProxy Integration

15.2.3.2.1.

TCP Load Balancing

15.2.3.2.2.

Health Checking

15.2.3.2.3.

Failover Configuration

15.2.4.

Scalability Strategies

15.2.4.1.

Horizontal Scaling

15.2.4.1.1.

15.2.4.1.2.

Sharding Approaches

15.2.4.1.3.

Application-Level Partitioning

15.2.4.2.

Vertical Scaling

15.2.4.2.1.

Hardware Upgrades

15.2.4.2.2.

Resource Optimization

15.2.4.2.3.

Performance Tuning

15.3.

Working with JSON Data

15.3.1.

15.3.1.1.

Native JSON Support

15.3.1.2.

Storage Efficiency

15.3.1.3.

Validation Benefits

15.3.2.

JSON Document Storage

15.3.2.1.

Document Structure

15.3.2.2.

Schema Flexibility

15.3.2.3.

Data Modeling Approaches

15.3.3.

15.3.3.1.

Document Creation

15.3.3.1.1.

JSON_OBJECT Function

15.3.3.1.2.

JSON_ARRAY Function

15.3.3.1.3.

Manual JSON Construction

15.3.3.2.

Data Extraction

15.3.3.2.1.

JSON_EXTRACT Function

15.3.3.2.2.

-> Operator Usage

15.3.3.2.3.

->> Operator Usage

15.3.3.3.

Document Modification

15.3.3.3.1.

JSON_SET Function

15.3.3.3.2.

JSON_INSERT Function

15.3.3.3.3.

JSON_REPLACE Function

15.3.3.3.4.

JSON_REMOVE Function

15.3.3.4.

Document Validation

15.3.3.4.1.

JSON_VALID Function

15.3.3.4.2.

Schema Validation

15.3.3.4.3.

Data Type Checking

15.3.4.

15.3.4.1.

Generated Column Indexes

15.3.4.2.

Multi-Value Indexes

15.3.4.3.

Functional Indexes

15.3.5.

JSON Query Optimization

15.3.5.1.

Index Usage Strategies

15.3.5.2.

Query Pattern Analysis

15.3.5.3.

Performance Considerations

Previous

14. Database Administration (DBA)

Go to top

Back to Start

1. Introduction to Databases and MySQL