Author Archives: harrisj

MySQL Upgrade

Project Summary:

This project is to upgrade Mysql databases (version 5.0) on paint to a new VM running Mysql 5.5.   Separating paint’s functions into separate virtual machines will allow us to separate cpu/network/memory/io resources and thereby be able to identify and isolate problems.  The VMware system has the possibility of having more I/O bandwidth and redundancy.

Mysql Scaling/Clustering:  A single master instance will be started at this time.   If there is a clear need for more servers AND we have buy in from other groups, I will make Mysql slave instances to offset the workload.

We start moving test databases in the week of January 23rd.  If a week of testing works ok, then we will move the production databases February 1 – 14th.

If a database/application doesn’t work after the migration, the original database and application will be  on paint until the problem can be resolved.  In order to complete the goal of getting off of the old hardware, paint will have to be made into a virtual machine.

 

Project Owner:

Jason Harris, Network Services

Groups Involved:

  • Network Services
  • Academic Computing
  • Admin Computing
  • Housing
  • Web Team
  • Others TBD

Estimated Completion Date:

February 21st, 2014

Resources:

Files, lists of databases, owners can be found in pccommon/mysql55upgrade

 

 

25 Live

Project Summary:

This project is to upgrade the current room scheduling software (R25).   The current product is a combination of desktop applications, web services, and databases.   The new software allows for all functionality of the product to work on web services.   This reduces the amount of management and administrative overhead, and it makes it more accessible to a larger audience.

Project Owner:

Kirk Knittle, Facilities

Groups Involved:

  • Network Services
  • Facilities
  • Web Team

Estimated Completion Date:

January, 2014

Resources:

TBD – Documentation share on \\hurricane\pccommon\r25live

Webfiles server upgrade

Project Summary:

This project is to take the shared web server files on paint (nfs://var/data_files) and place them on a dedicated server running in VMWare.   Separating paint’s functions into separate virtual machines will allow us to separate cpu/network/memory/io resources and thereby be able to identify and isolate problems.  The VMware system has the possibility of having more I/O bandwidth and redundancy.

We will move the nfs mounts in a staggered period over the week of February 1st – 7th.

If something doesn’t work, the files for that service will be left on paint until the problem can be resolved.   In order to complete the goal of getting off of the old hardware, paint will be made into a virtual machine.

Project Owner:

Jason Harris, Network Services

Groups Involved:

  • Network Services
  • Academic Computing
  • Admin Computing
  • Housing
  • Web Team
  • Others TBD

Estimated Completion Date:

February 14th, 2014

Resources:

Postgres Upgrade

Project Summary:

This project is to bring our Postgresql server version up to 9.3 from version 8.4.    A new server will be created and run in parallel to our current Postgres server, Paint.   The new server will be a virtual machine, while paint is hardware.   Separating paint’s functions into separate virtual machines will allow us to separate cpu/network/memory/io resources and thereby be able to identify and isolate problems.  The VMware system has the possibility of having more I/O bandwidth and redundancy.

 

Project Owner:

Jason Harris, Network Services

Groups Involved:

  • Network Services
  • Academic Computing
  • Admin Computing
  • Housing
  • Others TBD

Current Databases on Paint

ac_comphelp_rm_prod
ac_cons_rm_prod
ac_help_prod
ac_presence_prod
ac_presence_test
ac_problems_prod
ac_site_tracker_prod
ac_site_tracker_test
ac_tracks_prod
acc_inv_prod
canvas_dev
checkout_prod
events_prod
goprint
gprint
lic_ac_prod
license_prod
mf_auth
moodle2_prod
moodle2_test
moodle_prod
moodle_test
myevals
postgres
print_log_prod
rad_drupal
rad_drupal_prod
rad_drupal_test
rad_spacebook_prod
rad_spacebook_test
sc_inst_rm_prod
sc_rm_prod
sc_user_log_prod
tss_redmine_prod
weather_prod

Estimated Completion Times:

List of dbs to be moved by Dec 20th

ac_comphelp_rm_prod
ac_cons_rm_prod
ac_help_prod
ac_presence_prod
ac_presence_test
ac_problems_prod
ac_site_tracker_prod
ac_site_tracker_test
ac_tracks_prod
acc_inv_prod

List of dbs to be moved by 3rd week of January:

moodle2_prod
moodle2_test
moodle_prod
moodle_test
myevals
postgres
print_log_prod
rad_drupal
rad_drupal_prod
rad_drupal_test
rad_spacebook_prod
rad_spacebook_test

Resources:

  • Postgres Feature Comparison:  http://www.postgresql.org/about/featurematrix/