|
Learn Oracle from Oracle - Original Oracle University Seminar
Nur Oracle University Schulungen bieten die notwendige Voraussetzung zur Teilnahme an den Prüfungen zum:
OCA (Oracle Certified Assosiate)
OCP (Oracle Certified Professional)
OCM (Oracle Certified Master)
Seminarinhalt
Teilnehmerkreis
Vorkenntnisse
Sachgebiete
In the MySQL Cluster course, you will learn the important details of clustering that you will need to understand to get started with MySQL Cluster, how to properly configure and manage the cluster nodes to ensure high availability, how to install the different nodes and provide a better understanding of the internals of the cluster.
Students that can benefit from this course:
- Experienced database users who want an in-depth understanding of MySQL Cluster
nach oben
- Entwickler
- Technischer Berater
- Projektmanager
nach oben
Erforderliche Vorkenntnisse:
- Basic knowledge of database concepts and SQL
- Have previously worked with a MySQL Server instance and database
- Be able to install MySQL
- Have working knowledge of MySQL architecture
- MySQL for Database Administrators (SQL-4502)
Empfohlene Vorkenntnisse:
- Can use MySQL tools to connect to the MySQL Server
- Can state general knowledge of hardware and OS
nach oben
Introduction
- MySQL Overview, Products, Services and Enterprise Services
- Supported Operating Services
- MySQL Certification Program
- Training Curriculum Paths
- MySQL Website
- Installing MySQL
- Installing the world Database
Introduction to MySQL Cluster Architecture
- MySQL General Architecture
- What is a Cluster?
- Partitioning
- Replication
- Node Types
- Fragments
- Node Groups
Install and Start MySQL Cluster
- Initiate MySQL Cluster
- Start a Management Node
- Starting the Data Nodes
- Connecting the SQL Nodes
- Startup Phases
- Restart a Cluster
- Testing High-Availability
- Upgrading MySQL Cluster
Configure MySQL Cluster
- MySQL Cluster Configuration
- Management Node Configuration
- Data Node Configuration
- SQL Node Configuration
NDB Storage Engine
- NDBs Storage Engine
- NDBs Storage Method
- NDBs Indexing
- NDBs Communication Interconnects
- NDBs Transaction Capabilities
Designing a Cluster
- System Considerations
- Cluster Setups
Handling Data in MySQL Cluster
- Cluster Disk Data
- Importing Data into Cluster Tables
- Dropping Cluster Tables
MySQL Cluster Management
- Clusters Management Console
- Backing Up Cluster Data
- Restoring Backups
- Troubleshooting Backups
- Modifying Table Definitions
MySQL Cluster Security
- Cluster Security Best Practices
- Secure Architectures
MySQL Cluster Performance
- Performance Terms
- Query Execution
- Data Size/Usage Issues
- Query Design
- Configuration Options
Resolving MySQL Cluster Problems
- Diagnostic Best Practices
- Connection Issues
- Arbitrator Shutdown
- Resource Problems
- Where to get additional help
MySQL Cluster Replication
- Cluster Replication
- Replication Preparation
- Single Replication Channel
- Redundant Replication Channels
- Using MySQL Cluster Replication for Backups
Conclusion
- Course Overview
- Training and Certification Website
- Course Evaluation
- Thank You!
- QA Session
Dauer
Dauer: 3 Tage
nach oben
|
