 |
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.
|
|
|
.gif){kind=spacer}
