MySQL Relational Database Server

A database server is a computer program that provides database services to other computer programs or computers, as defined by the client-server model. The term may also refer to a computer dedicated to running such a program. Database management systems frequently provide database server functionality, and some DBMS's (e.g., MySQL) rely exclusively on the client-server model for database access. Database Master servers are central and main locations of data while Database Slave servers are synchronized backups of the master acting as proxies

Features :

1. A broad subset of ANSI SQL 99, as well as extensions.
2. Cross-platform support.
3. Stored procedures.
4. Triggers.
5. Cursors.
6. Updatable Views.
7. True VARCHAR support.
8. INFORMATION_SCHEMA.
9. Strict mode.
10. X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle's InnoDB engine.
11. Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, Archive for storing historical data in little space).
12. Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB.
13. SSL support.
14. Query caching.
15. Sub-SELECTs (i.e. nested SELECTs).
16. Replication with one master per slave, many slaves per master, no automatic support for multiple masters per slave.
17. Full-text indexing and searching using MyISAM engine.
18. Embedded database library.
19. Partial Unicode support (UTF-8 sequences longer than 3 bytes are not supported; UCS-2 encoded strings are also limited to the BMP).
20. ACID compliance using the InnoDB, BDB and Cluster engines.
21. Shared-nothing clustering through MySQL Cluster.

General Description :

MySQL is a multithreaded, multi-user SQL database management system (DBMS)which has, according to MySQL AB, more than 10 million installations.MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, which holds the copyright to most of the codebase. This is similar to the JBoss model and how the Free Software Foundation handles copyright in its projects, and dissimilar to how the Apache project does it, where the software is developed by a public community and the copyright to the codebase is owned by its individual authors. The company develops and maintains the system, selling support and service contracts, as well as proprietary-licensed copies of MySQL and employing people all over the world who collaborate via the Internet. The MySQL company also sells another DBMS, MaxDB, which is from an unrelated codebase.

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad            Good

Enter the code in the box below: