MySQL Database
MySQL is a relational database management system (RDBMS) which has more than 6 million installations. The program runs as a server providing multi-user access to a number of databases.
The project's source code is available under terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL is owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now a subsidiary of Sun Microsystems, which holds the copyright to most of the codebase.
MySQL is commonly used by free software projects which require a full-featured database management system, such as WordPress, phpBB and other software built on the LAMP software stack. It is also used in very high-scale World Wide Web products including Google and Facebook.
Features: As of April 2009, MySQL offers MySQL 5.1 in two different variants: the MySQL Community Server and Enterprise Server.[10]
They have a common code base and include the following features:
- A broad subset of ANSI SQL 99, as well as extensions.
- Cross-platform support.
- Stored procedures.
- Triggers.
- Cursors.
- Updatable Views.
- True VARCHAR support.
- INFORMATION_SCHEMA.
- Strict mode.
- X/Open XA distributed transaction processing (DTP) support; two phase commit as part of this, using Oracle's InnoDB engine.
- Independent storage engines (MyISAM for read speed, InnoDB for transactions and referential integrity, MySQL Archive for storing historical data in little space).
- Transactions with the InnoDB, BDB and Cluster storage engines; savepoints with InnoDB.
- SSL support.
- Query caching.
- Sub-SELECTs (i.e. nested SELECTs).
- Replication with one master per slave, many slaves per master, no automatic support for multiple masters per slave.
- Full-text indexing and searching using MyISAM engine.
- Embedded database library.
- Partial Unicode support (UTF-8 sequences longer than 3 bytes are not supported; UCS-2 encoded strings are also limited to the BMP).
- ACID compliance using the InnoDB, BDB and Cluster engines.
- Shared-nothing clustering through MySQL Cluster.
The MySQL Enterprise Server is released once per month and the sources can be obtained either from MySQL's customer-only Enterprise site or from MySQL's Bazaar repository, both under the GPL license. The MySQL Community Server is published on an unspecified schedule under the GPL and contains all bug fixes that were shipped with the last MySQL Enterprise Server release. Binaries are no longer provided by MySQL for every release of the Community Server.
Why Choose AJS Media?
To build a respected and trusted website design company takes time, dedication, passion and hard work! AJS Media are one of the UK's fastest growing web design companies and we believe that no other can match our great services at the prices we offer.
Great web design for everyone - time and time again... A great customer base comes from delivering a great service time and time again.
AJS Media designers and programmers are experienced in all aspects of website design and development and we have thousands of satisfied clients to prove it.However, our service does not stop there. We offer many value-added services to help businesses grow and reap the benefits of trading on the Internet.
Stunning design - without design agency fees... We are an honest company that believes passionately in itself and the services we provide. We strive to create websites that look and function to the highest standards - every time, and we offer all of this at a fraction of the cost that many busineses would expect to pay.
If you have any questions about AJS Media and our services, Contact Us.
If you would like to discuss your requirements for a new website, complete our Online Enquiry Form.
Find out more about how AJS Media are helping businesses like yours...