Please enable JavaScript.
Coggle requires JavaScript to display documents.
MySQL - Coggle Diagram
MySQL
Using stored routines, triggers, and scheduled events
Stored functions and procedures
Using tiggers.
Using events
Differences
Pre/post operations.
Types of NoSQL Databases
Key-Value databases
Document databases
Column family stores
Graph Databases
Alternative Storage moved here
MySQL scaling
Master-slave replication
Master-master replication
Sync/async replication
Partitioning & sharding
Relational datatabase design
Relational model
Types of Relations
Overview of different DB Engines (Percona, MariaDB, etc)
Mysql architecture
MySQL’s Storage Engines (MyISAM, InnoDb, other)
Concurrency Control
Transcations and isolation levels
Summarising and grouping data
Aggregate functions
Grouping data
Filtering grouped data
High performance
Optimizing Schema
Indexing for high performance
Data Types
NoSQL Overview
Motivations for NoSQL databases
Case study