MySQL

What is MySQL?

MySQL is a type of SQL database management featured in JTLnet hosting plans. A database is an organized collection of information that a computer uses to select and display data. Databases can help organize and enhance your site content. Sites with dynamic pages and/or shopping cart software often need an underlying database structure.

MySQL is a Relational Database Management System. A relational database adds speed and flexibility, by storing data in separate tables rather than putting all the data in one area. These tables are linked by defined relations making it possible to combine data from several tables upon request. Using a RDMS means it is possible to add, access, and process the data stored in your database. 'SQL' stands for "Structured Query Language" - the most common standardised language used to access databases. MySQL is Open Source software and is freely available at www.mysql.com. Open Source software means that the source code can easily be manipulated and modified by anyone. It is very simple to use.

Why use MySQL?

MySQL is very fast, reliable, and easy to use. MySQL also has a very practical set of features developed in close cooperation with its users. It is also Open Source and therefore freely accessible. MySQL is used to access databases on the internet due to its connectivity, speed and security. It was originally developed to manage large databases at a much faster speed than the solutions that previously existed. MySQL has for several years, been thriving in the challenging areas of production.

MySQL has become the the most popular open source database and the fastest growing database in the industry. This is based on its dedication to providing a less complicated solution suitable for widespread application deployment at a greatly reduced TCO.

MySQL offers several key advantages:

• Reliability and Performance
  

  MySQL AB provides early versions of all its database server software to the community to allow for several months of "battle testing" by the open source community before it deems them ready for production use

• Ease of Use and Deployment
  

  MySQL's architecture makes it extremely fast and easy to customize. Its unique multi-storage engine architecture gives corporate customers the flexibility they need with a database management system unmatched in speed, compactness, stability, and ease of deployment.

• Freedom from Platform Lock-in
  

  By providing ready access to source code, MySQL's approach ensures freedom, thereby preventing lock-in to a single company or platform.

• Cross-Platform Support
  

  MySQL is available on more than twenty different platforms including major Linux distributions, Mac OS X, UNIX and Microsoft Windows.

• Millions of Trained and Certified Developers
  

  MySQL is the world's most popular open source database, so it's easy to find high-quality, skilled staff.

• Powerful, Uncomplicated Software
  

  MySQL has the capabilities to handle most corporate database application requirements with an architecture that is extremely fast and easy to use.

JTLnet's MySQL Database Server

JTLnet's Database Server includes all of the required enterprise features plus many innovations:

• Multiple storage engines including full transaction support with commit, rollback, crash recovery and low-level locking capabilities. You can select from a range of storage engines from fast in-memory operation to full transaction support and clustering for high-availability.
• Query caching delivers significant performance benefits and with database replication, many slave servers can run off a single master server increasing both speed and robustness.
• A robust security system with advanced permissions and support for SSL transport-layer encryption provides robust application security.
• Full text indexing and searching enables rapid searching of text fields for words and phrases. This includes relevance rankings, exact phrase matching and Boolean search operators.