0% found this document useful (0 votes)
104 views

Technical Specifications Mysql

The document provides an overview of features and capabilities of MySQL, an open source relational database management system. Key points include that MySQL supports flexible architectures like containers and microservices, has security features like OpenSSL and SQL roles, and provides high performance through tools like the Performance Schema. It also supports transactions, replication, and high availability clustering.

Uploaded by

Tanaka M Kariri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
104 views

Technical Specifications Mysql

The document provides an overview of features and capabilities of MySQL, an open source relational database management system. Key points include that MySQL supports flexible architectures like containers and microservices, has security features like OpenSSL and SQL roles, and provides high performance through tools like the Performance Schema. It also supports transactions, replication, and high availability clustering.

Uploaded by

Tanaka M Kariri
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

MySQL Heatwav

MySQL Operator for Kubernetes


Flexible Architecture
 Containers and microservices
 Fully Managed
 Open Source
 Private DBaaS
 Single Databa
 Multi-threaded
 On Premise to
 Pluggable Storage-Engine Security
 On Premise to
 InnoDB, NDB  OpenSSL by Default
MySQL Enterpris
 MyISAM  SQL Roles  Hot Backup fo

ANSI SQL Standards  Password management  Parallel backu

 ANSI SQL High-Performance


 Compressed B

 SubQueries, Joins, Cursors  Full, Incremen


 Performance Schema
 Prepared Statements  Full, Partial Re
 Information Schema
 Views  Point in Time
 SYS Schema
 Triggers  Auto-Restart/R
 Resource Groups
 Stored Procedures  Scriptable, co
 Partitioning
 User-Defined Functions  Integrated with
 Optimized for high concurrency NetBackup, T
 Window Functions and CTEs  Optimized for Read Only
MySQL Enterpris
 NOWAIT and SKIP LOCK  Optimized for use with SSD  MySQL InnoD
 Descending Indexes  Multiple Index Type (B-tree, R-tree, Hash, Full Text,  MySQL Group
 Invisible Indexes etc.)
MySQL Enterpris
 Grouping  Server-side Thread Pool
 MySQL Threa
 Connection Thread Caching
Optimizer MySQL Enterpris
 Diagnostics, and SQL Tracing
 MySQL Enterp
 Cost-based Optimizer
 MySQL Enterp
 Optimizer Tracing
OLTP and Transactions
 MySQL Enterp
 JSON Explain  ACID Transactions  MySQL Enterp
 Commit, Rollback  MySQL Enterp
 Optimizer Hints
 MySQL Enterp
 Optimizer Histograms  Foreign Keys
MySQL Enterpris
 Referential Integrity  Visual Dashbo
MySQL Document Store
 Row-level Locking  Query Analyze
 Relational Tables
 Customizable Lock Isolation Levels  Rules & Advis
 JSON Documents
 Distributed Transactions (XA)  Trends & Ana
 X Protocol
 Snapshot Isolation  Health monito
 X DevAPI
 Repeatable Reads (readers don't block writers and  Performance m
 MySQL Shell vice-versa)
 InnoDB monit
 Automatic Deadlock Detection
JSON Support  Replication m
 Native JSON Datatype Data Warehouse Optimized features  Backup Monit
 JSON Table Functions  Fast Data Load Utility  I/O Monitoring
 JSON Aggregation Functions  High-Speed Multi-Insert Function  Blocking/Lock
 JSON Merge Functions  GROUP BY WITH ROLLUP  Security admi
 JSON Partial Update  Aggregate UDF Oracle Enterprise
Replication & High-Availability
 InnoDB Cluster, ClusterSet
 Group Replication  Analytic SQL Functions
 Router  Multi-Terabyte Scalability
 Built-in Replication Engine
Geo Spatial Support
 Row-based Replication
 InnoDB R-tree Spatial Indexes
 Multi-source Replication
 GeoHash Graphical Tools
 Time-delayed Replication
 GeoJSON
 Global Transaction IDs  MySQL Workb
 Spatial Reference System (SRS)
 Replica Failover, Recovery  Data Modeling
 SRID Spatial Data Types
 Multi-threaded replicas  Database Adm
 SRID Spatial Indexes
 SQL Editor
MySQL NDB Cluster  SRID Spatial Functions
 99.999% Availability
MySQL Shell
Character Sets & Collations
 Distributed architecture  Admin API
 UTF8MB4 as default
 Synchronous replication  Python Scripti
 Unicode 9.0
 Real-time transactional Drivers
performance  Case & Accent Sensitive Collations

 Foreign Keys
 MySQL Native
Manageability and Ease of Use
 SQL & Non-SQL data access
 MySQL Driver
 Easy Install and Setup C++
 Auto sharding of data
 "3 minutes to Success" with all-in-one Windows  Community D
 Java, C++, memcached, HTTP Installer Go

You might also like