ARCHIVED: Completed project: RDC Replacement

This content has been archived, and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable.

Primary UITS contact: Stephanie Burks

Completed: September 2, 2011

Description: In summer 2010, the High Performance Systems (HPS) group will replace the current Research Database Complex (RDC), which has been in service since early 2007. The RDC is dedicated to research-related databases and data-intensive applications that require a database.

Both Oracle and MySQL databases are supported on the RDC. The RDC also provides an environment for database-driven web applications with a research focus.

Outcome: The goal of this project is to retire hardware that has reached the end of its lifecycle, and to provide newer, faster replacement hardware for research databases.

Milestones and status:

  • January 27-February 18, 2010: Needs assessment
  • March 5, 2010: Preliminary budgetary quote request complete
  • April 23, 2010: Preliminary proposal to HPS management
  • June 7, 2010: Internal proposal submitted
  • June 14, 2010: Request for quote complete
  • August 14, 2010: Hardware installation
  • August 18, 2010: Red Hat REL5.5 installed
  • August 23, 2010: HP P2000 Fiber Channel SAN installed
  • August 27, 2010: Begin multipath testing
  • August 30, 2010: Complete multipath testing
  • September 2, 2010: Administrative user accounts created
  • September 6, 2010: Continue planning for Oracle Migration
  • October 21, 2010: Kernel parameters changed for Oracle/MySQL servers
  • November 1, 2010: Disks prepared for Automatic Storage Manager
  • November 4, 2010: Oracle, ASMLib, and Grid Infrastructure installed on RDC03
  • November 10, 2010: Oracle ASM instance installed and configured on RDC03
  • November 16, 2010: Additional 146GB drives installed on RDC01, RDC02 and RDC03 (Oracle servers)
  • November 18, 2010: Security Vulnerability (Kernel and ASMLib) updated; issues with ASM seeing disk groups after upgrade
  • November 22, 2010: Preparing to install MySQL on RDC04
  • November 29, 2010: Compiled and installed MySQL on RDC04
  • November 30, 2010: Begin modification of mysql_manager for RDC04
  • December 2, 2010: Installed Oracle ASM and Oracle Grid Infrastructure on RDC02
  • December 3, 2010: Begin modification of SQL scripts used to obtain database DDL and confirm migration accuracy for Oracle databases
  • December 7, 2010: Installed Oracle Configuration Manager on RDC02
  • December 8, 2010: Installed Orion on RDC02
  • December 10, 2010: Concluded throughput testing of HP disk array, using Orion on RDC02
  • January 21, 2011: MySQL disk space allocated to RDC04
  • January 24, 2011: Multipath test on RDC03 failed; further testing required
  • February 3, 2011: Completed modification of mysql_manager for RDC04
  • February 14, 2011: NAS Mounted to RDC-login1 and RDC01-4 for home directory access
  • February 16, 2011: Installed MySQL 5.5.8 with SSL support on RDC04
  • February 16, 2011: Installed MySQL 5.5.8 client software on RDC-login1
  • February 17, 2011: Configured iLO devices
  • February 23, 2011: phpMyAdmin configured to include access to MySQL on RDC04
  • February 28, 2011: mysql_instance, mysql_instanced and perl module File::NFSLock installed on RDC-login1 and RDC04
  • February 28, 2011: Startup scripts created for MySQL on RDC04
  • March 3, 2011: Developed process for merging mysql db from 5.0.6 RDC to 5.5.8 RDC
  • March 9, 2011: Tested MySQL backup encryption using OpenSSL
  • March 1, 2011: New MySQL Server requests installed on the new MySQL system (RDC04)
  • March 10, 2011: Multipath configuration and testing for Oracle complete (RDC03)
  • March 21, 2011: Begin migration of MySQL servers to RDC04 - Testing phase
  • March 28, 2011: Begin Full MySQL server migration from Libra45 to RDC04
  • April 16, 2011: Installed and configured Oracle 11g on rdc-mgmt node
  • April 21, 2011: Port access in campus firewall approved on virtual host rdc-mgmt
  • April 25, 2011: Installed Grid Control software on rdc-mgmt
  • April 27, 2011: Installed Oracle Middleware for Grid Control 11g on rdc-mgmt
  • April 29, 2011: Configured RMAN on rdc-mgmt
  • May 6, 2011: Modified MySQL servers for switch from frontend server rdclogin1 and 2 to rdc-login1.
  • May 10, 2011: Installed Oracle Critical Patch update on rdc-mgmt
  • June 7, 2011: Completed login host migration to II-hosted VM
  • June 7, 2011: Oracle migration begun
  • June 13, 2011: Installed Oracle Critical Patch update on rdc02
  • June 14, 2011: Modified MySQL database backup process to use SDA

Comment process: Email High Performance Systems.

Benefits: The replacement hardware will provide a newer, faster, more robust environment for research databases. Oracle and MySQL will be upgraded to the latest versions. Additional licenses will be purchased for Oracle, including Data Mining, OLAP, Spatial, and Advanced Compression.

Related information: See About the Research Database Complex (RDC) at Indiana University.

Primary client: IU students, faculty, and staff, and IU affiliates

Project team:

  • Matt Allen
  • Stephanie Burks
  • Collin Gayde
  • Bret Hammond

Governance: Craig Stewart, Associate Dean for Research Technologies

This is document azmh in the Knowledge Base.
Last modified on 2018-01-18 16:30:12.