Description
The California Department of Technology (CDT) provides services on a number of database management system (DBMS) technologies for various hardware and operating system platforms. CDT offers MySQL on leased equipment within our Tier III data centers.
MySQL is available as an add-on component to customers that subscribe to the Windows Platform Hosting service.
Benefits
- On-demand scalability
- High performance
- Complete workflow control
- Flexibility of open source
- Data security
Included
CDT provides MySQL database administration on leased equipment on Windows within the platform hosting service. CDT staff performs installation, patching, and product maintenance according to standard procedures and configurations.
CDT performs database backups on the following schedule:
| What | When |
|---|---|
| Full Backup | Daily |
| Transaction log backup | Daily |
| Backup retention | 28 days |
- CDT supports version(s) of MySQL in accordance with the CDT Software Version Support Policy.
- The core business hours for MySQL technical support are Monday through Friday 0800 – 1700. State holidays and mandated schedule alterations are observed and may impact staff availability.
- MySQL maintenance activities utilize the platform maintenance schedules; however, changes may be scheduled.
Security
Customers will be provided database owner (DBO) access or lower to their databases depending on their requirements. Application accounts must have specific roles and/or user permissions that are the lowest needed to perform application functions. Customers must follow CDT’s password complexity requirements. MySQL system administration (root) authority is restricted to CDT designated personnel. Customers may be granted temporary system administration rights, post-installation, to their MySQL server during application installation and server refresh activities.
If customers require extended use of system administration rights, an Information Security Exception Request must be submitted. Please follow the procedure outlined in Procedure 3502 – Information Security Exception Request and adhere to both the Standard 3132 – Midrange Database Security and Standard 3138 – System Administrator Standard. Configuration changes made outside the scope of the service request requiring intervention, correction, or troubleshooting by CDT staff may incur additional charges. A Customer with granted System Administration (root) rights must adhere to the following use restrictions. Failure to comply could result in access revocation.
- Changing MySQL configurations; only CDT staff are permitted to make changes
- Changing MySQL CDT scheduled jobs; only CDT staff are permitted to make changes
- Creating user accounts must be performed by or coordinated, prior to creation, with CDT staff
- Creating databases must be performed by or coordinated, prior to creation, with CDT staff
- Changing the MySQL server service account is not permitted; this account is owned by CDT staff
- Changing the MySQL system administrator account is not permitted; the account is owned by CDT staff
Administration
- CDT provides system-level administration, data migration assistance, data and log file backups, database consistency checks, 24/7 system monitoring, DBMS patching and version upgrades, and system security.
- CDT manages the contract and licensing for DBMS software and serves as the liaison between the customer and Oracle (the vendor) for technical system-level DBMS issues.
- CDT is available to advise and assist customers in formulating IT designs that leverage available service offerings. CDT provides architectural/engineering and design consulting services.
Optional
CDT is available to advise and assist customers in formulating IT designs that will leverage available service offerings. Customers should contact their account lead to engage architectural/engineering and design consulting services. Additional charges may be incurred. Options for MySQL include:
- Database engine services
- Advanced security
- MySQL workbench
Roles & Responsibilities
| Role | CDT | Customer |
|---|---|---|
| Installation, upgrades, patches, fixes, and standard configuration | X | |
| Incident resolution associated to application configuration changes | X | |
| Manage contract and licensing for MS SQL or MySQL software | X | |
| Perform off-line scheduled database backups | X | |
| Assist customers upon request to perform MS SQL or MySQL related tasks | X | |
| Monitor free disk space and alert customer when disk space is below threshold levels determined by the customer | X | |
| Maintain database and log backups | X | |
| Create Database Administrator (DBA) user account(s) | X | |
| Monitor and tune MS SQL or MySQL software | X | |
| Review and recommend optional configurations that may enhance capacity and performance requirements | X | |
| Perform MS SQL or MySQL version migrations and upgrades | X | |
| Maintain database administrative tools | X | |
| Maintain MS SQL or MySQL software/configurations | X | |
| Resolve database system problems or seek vendor support for issues through authorized escalation processes | X | |
| Design, develop, deploy, and test the database and maintain its interaction with application(s) | X | |
| Define database availability requirements | X | |
| Document database design and application architecture | X | |
| Respond to threshold limit notifications provided by CDT staff with mitigating action | X | |
| Maintain application and database statistics | X | |
| Test new maintenance and software releases at user and application levels | X | |
| Pay for additional charges for CDT intervention, troubleshooting and correction of unauthorized changes if incurred | X | |
| Create and maintain database objects | X | |
| Load database data via access provided by CDT | X | |
| Application design, development, testing and migration adhering to supported software versions | X | |
| Application code modifications | X | |
| Provide scripts for custom MS SQL or MySQL configurations required by the application | X | |
| Maintain application development tools running on attached client(s) | X | |
| Ongoing monitoring of database growth in relation to disk space | X | |
| Identity database application related problems or database system problems and report them | X | |
| Notify CDT of application maintenance activities that cause an interruption of service | X | |
| CDT and the customer will work together to resolve any database application-level problems | X | X |
| CDT will assist with data migrations within CDT environments | X | X |
Rates
The rate schedule represents standard CDT services. If a Customer requires technology solutions that are not part of the standard, CDT will review the Customer’s request and provide customized pricing as necessary.
Tier 1 Database Support
| Service Description | Service Identifier | Product Name | Unit of Measurement | Rate | Service Code | Notes |
|---|---|---|---|---|---|---|
| Database License | Tier 1-Database Support | Database Support | Per License | Pass-through + 2.79% CDT Processing Fee | D101 - Tier 1 Database | Plus the CDT Processing Fee of 2.79% |
| Tier 1 Database Support (SQL Server and MySQL) | Tier 1-Database Support | Database Support | Monthly/Per Instance | $1,604.00 | M620 | |
| Database Instance Installation Set-up Fee for Database Support - Tier 1 (SQL Server and MySQL) | Tier 1-Database Support | Database Support | One-Time/Per Instance | $1,042.00 | M621 |
Subscriptions to this service are available.
FAQs
Can I have RDP access to the server?
You must submit a case/request to get RDP access to the server.
Can I have sysadmin (root) privileges in MySQL?
You have to submit a case/request to get root privileges, and this must be approved by our security team.
What is the maintenance window for MySQL servers?
Saturdays from 7 am to 12 pm.
Request service
To submit a service request for a new database or database environment, please go to the Enterprise Services Delivery page.
| Service Request Name | Link |
|---|---|
| SQL and MySQL services Request to add or remove SQL or MySQL software instance on an existing server. | Order the addition or removal of a MySQL software instance |
| Database support Non-billable database maintenance activities for various products including ADABAS, DB2, IDMS, MySQL, Oracle and SQL. | Order database maintenance |
| SQL system admin (SA) rights Submit a request for SQL SA rights and, optionally, Windows administrative credentials on a server managed by CDT. | Order system admin rights |