A
database server manages and stores the database within
a computer system. The database server is often referred
to as the back-end of the computer system and interfaces
with the application server (middleware) which links
to the front-end graphical user interface.
Database
Server -- Single or Cluster
A database server can be integrated with a web and
application server on a single physical server or
it can be part of a complex cluster. A database server
is typically part of a cluster for high volume or
complex transaction applications. Within a cluster
a database server would be on its own physical server
and there may be more than one database server to
provide redundancy. Likewise, there would be unique
and multiple web servers and application servers within
the cluster.
Database
Server Software
There are several software programs that
are used on a database server. The most popular are
Oracle and some version of SQL, such as MySQL, MS
SQL, or PostrgreSQL. All these programs allow a database
server to function in a client/server environment
as a distributed database.
Critical
Database Server Issues
It is critical for a database server to be properly
configured if it is to be easily scalable, maintained,
and backed-up. To achieve this it is best to use engineers
that are familiar with the requirements of the database
program on your database server. These engineers could
be internal IT resources, a hosting provider with
database expertise, or a remote database server management
company.
|