What are the main technical specifications of MySQL?
Below are the 12 main technical specifications of MySQL:-
(1)MySQL is very high in performance
(2)MySQL has very flexible structure(Fully managed production-ready database service designed for more granular control and flexibility)
(3)MySQL is easy to use and manageable
(4)MySQL has many Graphical Tools (dbForge Studio for MySQL, MySQL Workbench, phpMyAdmin, HeidiSQL, Toad Edge for MySQL, SQLyog, Navicat for MySQL)
(5)MySQL has Geo-Spatial Support(MySQL implements spatial extensions as a subset of the SQL with Geometry Types environment.)
(6)MySQL architecture is ideal for online transaction processing (OLTP) systems and for Transactions
(7)MySQL has feature of Replication and High availability.(Which helps MySQL data server to copy data automaticaly to or or more database servers).
(8)MySQL has good security and storage management(For example Authentication, Password Policies, Authorization, Privilege Management, Encryption to secure sensitive)
(9)MySQL have standards-based drivers for JDBC, ODBC, and .Net enabling developers.
(10)MySQL Enterprise Monitor (Which provides real-time visibility into the performance and availability of all your MySQL databases).
(11)MySQL Enterprise Security(MySQL Enterprise Encryption provides encryption, key generation, digital signatures and other cryptographic features to help organizations protect confidential data).
(12)JSON Support(JSON support has been added to MySQL from version 5.7.8) | |