MySQL

What is MySQL

MySQL is a very popular Open Source SQL database. It is a relational database by Oracle Corporation.
·         MySQL is a database management system.
·         MySQL is a relational database management system.
·         MySQL software is Open Source.
·         The MySQL Database Server is very fast, reliable, and easy to use.
·         MySQL Server works in client/server or embedded systems.
·         A large amount of contributed MySQL software is available.

History

• Beginning in 1994
• First internal release on 23 May 1995
• Windows version was released on 8 January 1998 for Windows 95 and NT
• Version 3.23: June 2000
• Version 4.0: August 2002
• Version 4.01: August 2003
• Version 4.1: 2004

• Version 5.0: March 2005
• Sun Microsystems acquired MySQL AB on 26 February 2008.
• Version 5.1: 27 November 2008

MySQL 5.1 and 6.0

• Oracle acquired Sun Microsystems on January 27, 2010.

Internals and Portability:

• MySQL is written in C/C++
• It is tested
• Most Platform independent
• Supports multi-layered server
• Uses GNU Automake, Autoconf, and Libtool for portability.
• Tested with Purify and Valgrind
• Use kernel threads
• Easily can add other storage engines.
• Very fast thread-based memory allocation system.
• Can use multiple CPUs
• Can proves transactional and nontransactional storage engines
• B-tree disk table with index compression
• Very fast at optimized nested-loop join
• Use temporary tables

Security:

• MySQL is very secured. It used a privilege and password system that makes it very flexible and secure.
• Password security by encryption of all password traffic when you connect to a server.
• It also use encryption for security purpose that makes so securied

Scalability and Limits:

• MySQL supports larege database. It can contain 50 million records. MySQL server can handle more than 200000 tables.
• It supports upto 64 indexes per table. So it is highly scalable.

Platforms

·         AIX
·         BSDi
·         FreeBSD
·         HP-UX
·         i5/OS
·         Linux
·         Mac OS X
·         NetBSD
·         Novell NetWare
·         OpenBSD
·         OpenSolaris
·         eComStation, OS/2
·         QNX
·         IRIX
·         Solaris
·         Symbian
·         SunOS
·         SCO
·         OpenServer
·         UnixWare
·         Tru64
·         Microsoft Windows Interfaces
·         APIs include Libraries for accessing MySQL
·         ODBC

Third party

• phpMyAdmin
• HeidiSQL
• Adminer
• DBEdit
• Navicat
• Other available proprietary MySQL frontends include Aqua Data Studio, dbForge Studio for MySQL, Epictetus, Oracle SQL Developer, SchemaBank, SQLyog, SQLPro SQL Client, Toad, Toad Data Modeler and Marshal SQLUtility.
• Database Master