Getting started with the Hourly DBA Service for RPC-VMware#
The Rackspace Hourly DBA Service add-on component of Rackspace Private Cloud powered by VMware (RPC-VMware)is designed to help you throughout the life cycle of your database. One key aspect of this service is the help that Rackspace can provide in the early stages of the application life cycle, where decisions might be crucial to the future of your application.
Rackspace DBAs can help with the following items:
- Installation, configuration, upgrade, and migration
- Backup and recovery
- Database security
- Storage and capacity planning
- Performance tuning
The DBA team can assist with advanced design, architecture, and planning services to help ensure that your databases run at peak efficiency.
Installation, configuration, upgrade, and migration#
The DBA team can assist with the installation of the database software, which requires knowledge of the hardware prerequisites for an efficient database server. As the DBA team installs the database software, they select from various options in the product to configure it for its intended purpose, depending on the database license procured by the customer. As new releases and patches are developed, the DBA team deploys the patches on the databases, at the customer’s request. The customer is responsible for thorough testing of the application in the lower environment before it is deployed in the production environment.
Backup and recovery#
The DBA team works with the customer and provides recommendations for backup solutions depending on the customer's environment and requirements. The DBA team can also be involved during the database restoration. The customer has final responsibility for ensuring that the backups are being performed as scheduled and that they include all the files needed to make database recovery possible after a failure.
When failures do occur, the DBA team uses the available backups to return the database to operational status as quickly as possible. A database can fail in several ways, and the DBA team uses the best possible solution to recover from each type of failure.
Databases centralize the storage of data and are mostly behind the firewall, making them less likely to be attacked by hackers than the application servers. However, securing the application servers reduces the risk of a database server compromise. . The DBA team can perform the following security tasks:
- Deploy the default security features available in various editions and releases of databases.
- Recommend other security products that require special licensing.
- Help with security tasks such as authentication (setting up user accounts to control logins to the database) and authorization (setting permissions on various parts of the database).
- Help implement advanced security options and auditing features if the customer needs to comply with regulations such as PCI, Sarbanes-Oxley, and HIPAA. Extra licensing options might be required to implement these features, and the DBA team can help customers implement these advanced features on a billable basis.
Storage and capacity planning#
The primary purpose of a database is to store and retrieve data, so the DBA team provides recommendations during the planning and deployment phases so that the customer environment is built appropriately.
The DBA team uses the default OS and available database tools and features to troubleshoot performance-related issues and provide recommendations to the customer. The DBA team can determine if the capacity of the server hardware, the way the OS is configured, or the database software configuration has become a limiting factors. The DBA team understands which performance tools are available at each of these levels and how to use them to tune the database. The DBA team provides recommendations if the performance issues are caused by the application or code and it is customer responsibility to fix the issue along with application vendor.
When things go wrong with the database server, the DBA team uses the server and database logs, available tools, and their expertise to find the solution and fix the issue as soon as possible.
The Hourly DBA Service for RPC-VMware is available for various versions of Oracle, Microsoft SQL, and MySQL databases. Contact your account team for information about compatibility with specific versions.
To use the Hourly DBA Service, the database VMs need to have a public IP address. Additionally, proper ACL rules must be set on the firewall in your environment to enable Rackspace DBAs to access the database VMs.
For more information, contact your Rackspace account manager.