NYU IT Database Architecture Team strives to equip our application development and research communities with the latest, secure, and high-performing RDBMS systems available to us. To ensure fast provision, adequate schema design, data consistency and integrity, best possible performance and reliable backup and recovery procedures, we designed the following guideline.
Types of Databases We Provide
At the moment the provide two RDBMS systems with the distinct characteristics and usage patterns.
| Database Management System | When to use |
|---|---|
| MariaDBMariaDB is a community-developed fork of the MySQL. MariaDB intends to maintain high compatibility with MySQL, ensuring a drop-in replacement capability with library binary parity and exact matching with MySQL APIs and commands.
However, it is subject to the same usage patterns and certain performance limitations, which makes it not entirely suitable for the high-loaded enterprise application. We recommend to use it for non-critical and/or temporary storage workloads. |
|
| Oracle Oracle Database (commonly referred to as Oracle) is enterprise-grade database management system produced and marketed by Oracle Corporation. It is capable of running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP & DW) database workloads.
We recommend to use it for all Tier 1 applications or any application which has extra demands for the performance, scalability, and security of the data. |
Please note:
- At the moment we do not offer NoSQL databases as a part of standard offering serviced by the Database Architecture Team.
- In order to minimize the risk associated with vulnerabilities in older versions of the RDBMS we always offer the latest version of both Maria and Oracle RDBMs.
- Patches are done on a regular schedule, and version upgrades (both major and minor) will be performed only by per application owner request.
Service Levels Available
Each of the database instance you request for your project can have one of the following availability levels.
| Availability Level | Expected Uptime | Expected Downtime | Redundancy | Backup and Recovery | Best for |
|---|---|---|---|---|---|
| L399.67%Up to 28 hrs/yearNo redundancyPer requestNon-mission critical and temporary workloads | |||||
| L299.98%Up to 1.8 hrs/yearMulti-zone replicationOngoingMission-critical workloads | |||||
| L199.99% Up to 24 min/yearMulti-zone replication/ ClusteringOngoing, per request snapshotsMission-critical university-wide workloads |
Please kindly note that each level assumes the availability of the budget to fund the desired availability level.
Database Pricing and Budgeting
We constantly strive to improve computing and storage capabilities while driving the cost of service down every year. Please contact us for the latest budgeting and billing details.
Database Design and Management Services
Please note, that our database management team offers the complete service – it means we monitor databases, ensure backup and test recovery procedures, apply latest patches and version upgrades, and deliver an outage protection. You are welcome to implement your own procedures, of course, as long as they do not interfere with procedures introduced by our Operations team.
How Do I?..
- Execute a particular SQL script to upload data into database?
- Execute a particular SQL script to change the database schema?
- Tune certain parameters of the database?
- Tune certain parameters of the server on which database is running?
You are absolutely free to access the content and the schema per access mode which was provided for you during the database creation. However, accessing data and schema directly can damage data – not only yours but also of other server tenants. This is why we discourage such direct modifications, but in case you still need one – please contact our team through the contact point below, we will do our best to accommodate your request.