fbpx

MySQL Cluster Ed 2

RM4,960.00 RM5,257.60 (after 6% SST)

This MySQL Cluster training teaches you how to install and configure a real-time database cluster at the core of your application. Expert instructors will teach you how to design and maintain your clusters for high availability and scalability by using MySQL Cluster’s open-source and enterprise components.

Course Duration: 4 Days
Categories: , Tag:

Description

COURSE OVERVIEW

The MySQL Fundamentals training is the first step in mastering MySQL, the world’s most popular open source database. Develop solid understanding and practical experience using relational databases, SQL and the MySQL Server and tools.In this course, you will be introduced to the MySQL Cloud Service.

AUDIENCE

  • Administrator
  • Architect
  • Database Administrator
  • Developer
  • Implementer
  • Systems Administrator

SUGGESTED PREREQUISITES

  • MySQL for Beginners Ed 3
  • MySQL for Database Administrators Ed 3
  • Oracle Linux 5 & 6 System Administration Ed 2
  • Linux administration skills
  • MySQL server configuration and usage
  • Familiarity with VirtualBox

REQUIRED PREREQUISITES

  • Must have a working knowledge of database concepts
  • Must have a working knowledge of UNIX/Linux command-prompt usage
  • Must have a basic knowledge of computer networking

COURSE OBJECTIVE

  • Describe the features and benefits of MySQL
  • Explain the basics of relational databases
  • Design an effective database
  • Issue MySQL statements from the mysql command-line client
  • Perform database operations by using MySQL Workbench
  • Select appropriate data types for your database
  • Build a database and tables by using SQL
  • Modify the structure of your database
  • Create indexes and keys
  • Add or update database data
  • Query data with SELECT statements
  • Join data from multiple tables
  • Use built-in MySQL functions
  • Export and import database data
  • Explain database transactions
  • Gain an understanding on the MySQL Cloud Service

MORE INFO

Learning

Topics

  • Introduction to MySQL Cluster
    • MySQL Overview, Products, Services
    • Websites and Other Documentation
    • Key Benefits and Use Cases
    • Node types
  • Installing MySQL Cluster
    • Hardware, Software, and Network Requirements
    • Choosing and Installing Cluster Distributions
    • Installing and Configuring Cluster Nodes
    • MySQL Cluster Auto-Installer
    • Starting a Cluster with a Basic Configuration
    • Upgrading a Cluster
  • MySQL Cluster Architecture
    • The NDB storage engine
    • Clustered tables
    • SQL and NoSQL API nodes
    • Data Nodes and Node Groups
    • Partitions and Replicas
    • Checkpoints and the Redo Log
    • Redundancy and Resilience
  • Configuring MySQL Cluster
    • MySQL Cluster Configuration Files
    • Basic Configuration Options: NodeId and HostName
    • Management Node Configuration
    • Data Node Configuration
    • Configuring Multi-Threaded Data Nodes
    • Cluster Program Startup Options
    • Viewing Cluster Configuration Information
  • Designing a MySQL Cluster
    • Design Guidelines
    • Sizing Memory Usage
    • In-Memory and Disk Data Storage
    • Configuring Disk Data Storage
    • Designing Clusters for Scale and High Availability
    • Cluster Configuration Examples
  • Maintaining a MySQL Cluster
    • Modifying Table Structure
    • Accessing the Cluster with Command-Line Tools
    • Single-User Mode
    • Backing Up a Cluster
    • Restoring a Cluster from Backup
  • Securing MySQL Cluster
    • Securing MySQL Cluster
    • Configuring Connection Security
    • Configuring Firewall Rules
    • Data Security
    • MySQL Server Node Security
  • MySQL Cluster Manager
    • Installing MySQL Cluster Manager Agent and Clients
    • Sites, Clusters, Hosts, Processes, Packages, and Configuration Attributes
    • Creating Managed Clusters
    • Importing a Configuration from an Unmanaged Cluster
    • Viewing Information About Your Sites and Clusters
    • Maintaining Your Sites and Clusters
  • Replicating Between MySQL Clusters
    • Replication in MySQL Cluster
    • Transaction Ordering and Epochs
    • Configuring Replication
    • Starting, Stopping, and Resetting Replication
    • Backups Using Replication Tables
    • Replication Resilience
    • Replication Information Repositories
    • Multi-Master Replication and Conflict Resolution
  • Monitoring MySQL Cluster
    • Introduction to Monitoring
    • Monitoring with the ndb_mgm Client
    • Using the Cluster Log
    • ndbinfo Database
    • Status Variables
    • MySQL Enterprise Monitor
  • Troubleshooting MySQL Cluster Problems
    • Starting to Troubleshoot
    • Heartbeats
    • Configuration Problems
    • Disk Activity Problems
    • Application Design Problems
  • Optimizing MySQL Cluster Performance
    • Performance Concepts
    • Identifying Queries for Optimization
    • Optimizing with Indexes
    • Using EXPLAIN
    • Adaptive Query Localization
    • Distribution Awareness
    • The Process of Optimizing and Benchmarking
  • MySQL Cluster Environments
    • MySQL Cluster and Virtualization
    • Node Deployment in Cloud Environments
    • Connecting to a Cluster with SQL and NoSQL APIs
    • Comparing MySQL Cluster with Other High-Availability Solutions
  • Conclusion
    • Summary course contents and objectives
    • Recap of MySQL Products, services, websites, training, documentation