The goal of Database Hosting is to provide the infrastructure required to support business applications for your organization in a highly available environment, ensure data integrity and security, as well as appropriate levels of availability and recoverability.
Information Technology Services (ITS) supports three types of databases:
|Oracle||Linux virtual servers|
|Microsoft SQL Server||Windows cluster|
|MySQL||Linux/Apache LAMP environment|
At UNCG, both Oracle and Microsoft SQL Server databases are managed by ITS, while MySQL databases are created and managed by web developers in a department or School.
For more information about MySQL databases on UNCG’s LAMP environment, see LAMP Support @ UNCG.
More information about Oracle database hosting and Microsoft SQL database hosting follows below.
Oracle Database Hosting
ITS will host Oracle databases on Linux virtual servers for vendor written applications. This service must be initiated as part of a project request. (For information regarding the project request process, see Project Request Criteria and Process.)
Oracle databases are hosted on a virtual server as a more cost-effective solution than a stand-alone physical server. However, your specific needs may demand a physical server for your database. This will be determined during consultations with ITS as part of the project process .
Microsoft SQL Database Hosting
ITS will host Microsoft SQL databases on an ITS hosted Windows cluster for vendor-written and client-developed applications. This service is available as part of Departmental Application Hosting.
For vendor-written applications, please submit a project request. (For information regarding the project request process, see Project Request Criteria and Process.)
For a client-developed database, please submit a Microsoft SQL Database Hosting Request form.
SQL Server offers either Dedicated or Shared instance database hosting:
- Dedicated database clients receive their own SQL Server instance and can expect administrative rights allowing them the ability to create and manage their own database(s). For information about ITS standard Dedicated SQL Server services, please refer to Microsoft SQL Server Service Description.
- Shared SQL Servers can expect to be able to create and manage all objects within their database(s) including security administration. However, as it is in a shared-server environment, users will be restricted from making changes to server-wide functions that could be detrimental to others users of the same server. For information about ITS standard Dedicated SQL Server services, please refer to Microsoft SQL Server Service Description.
ITS Support for Oracle and Microsoft SQL Server Database Hosting
ITS will provide support for problems that users may encounter with the core database management system hosting a Microsoft SQL Server database. This includes assistance with software maintenance, backup/recovery, monitoring, security, non-production refreshes and similar tasks typically associated with the database administration role. The level of support will vary according to the database management method. However, users of the service are responsible for providing the development expertise required to make use of their database.
If an application has multiple tiers (production, validation), clients may request a refresh of validation database by contacting 6-TECH at (336) 256-TECH (8324) or 6-TECH@uncg.edu.