Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
audina:dailymaintenance:start [2011/10/28 12:19]
smayr
audina:dailymaintenance:start [2011/11/29 12:59] (current)
smayr [Web Server (www)]
Line 2: Line 2:
 Author: Thai Tran Author: Thai Tran
  
-== Exchange server ==+== Exchange Server ==
  
 === Physical Environmental Checks === === Physical Environmental Checks ===
Line 16: Line 16:
  
 === Performance === === Performance ===
-  * % Processor Time +  * % Processor Time. 
-  * Available MBs +  * Available MBs. 
-  * % Committed Bytes in Use+  * % Committed Bytes in Use.
  
 === Event Logs === === Event Logs ===
Line 51: Line 51:
  
 === Security Logs === === Security Logs ===
-  * Mail Essential and Mail Security for exchange (these licenses are expired in 12/31/2011) +  * //Mail Essential// and //Mail Security for Exchange// (these licenses expire in 12/31/2011)
   * View the security event log on Event Viewer and match security changes to known, authorized configuration changes.   * View the security event log on Event Viewer and match security changes to known, authorized configuration changes.
   * Investigate unauthorized security changes discovered in security event log.   * Investigate unauthorized security changes discovered in security event log.
Line 63: Line 63:
  
 == CRM, OnContact Server == == CRM, OnContact Server ==
-  * Verify that SQL Services are running (SQL Agent) +  * Verify that SQL Services are running (SQL Agent). 
-  * Verify that SQL Agent jobs succeeded +  * Verify that SQL Agent jobs succeeded. 
-  * Verify that spindles have free space +  * Verify that spindles have free space. 
-  * Verify that data and log files for each database have free space+  * Verify that data and log files for each database have free space.
  
 === Check Backups === === Check Backups ===
   * Make sure that the recommended minimum backup strategy of a daily online backup is completed.   * Make sure that the recommended minimum backup strategy of a daily online backup is completed.
   * Verify that the previous backup operation completed.   * Verify that the previous backup operation completed.
-  * Verify that full backups succeeded +  * Verify that full backups succeeded. 
-  * Verify that transactional log Backups succeeded+  * Verify that transactional log Backups succeeded.
   * Analyze and respond to errors and warnings during the backup operation.   * Analyze and respond to errors and warnings during the backup operation.
   * Verify that the transaction logs were successfully purged (if your backup type is purging logs).   * Verify that the transaction logs were successfully purged (if your backup type is purging logs).
  
 === Performance === === Performance ===
-  * % Processor Time +  * % Processor Time. 
-  * Available MBs +  * Available MBs. 
-  * % Committed Bytes in Use+  * % Committed Bytes in Use.
  
 === Event Logs === === Event Logs ===
Line 90: Line 90:
  
 == Infusion server == == Infusion server ==
-  * Verify that SQL Services are running (ie. SQL Agent) +  * Verify that SQL Services are running (ie. SQL Agent). 
-  * Verify that SQL Agent jobs succeeded +  * Verify that SQL Agent jobs succeeded. 
-  * Verify that spindles have free space +  * Verify that spindles have free space. 
-  * Verify that data and log files for each database have free space+  * Verify that data and log files for each database have free space.
  
 === Check Backups === === Check Backups ===
   * Make sure that the recommended minimum backup strategy of a daily online backup is completed.   * Make sure that the recommended minimum backup strategy of a daily online backup is completed.
   * Verify that the previous backup operation completed.   * Verify that the previous backup operation completed.
-  * Verify that full backups succeeded +  * Verify that full backups succeeded. 
-  * Verify that transactional log Backups succeeded+  * Verify that transactional log Backups succeeded.
   * Analyze and respond to errors and warnings during the backup operation.   * Analyze and respond to errors and warnings during the backup operation.
   * Verify that the transaction logs were successfully purged (if your backup type is purging logs).   * Verify that the transaction logs were successfully purged (if your backup type is purging logs).
  
 === Performance === === Performance ===
-  * % Processor Time +  * % Processor Time. 
-  * Available MBs +  * Available MBs. 
-  * % Committed Bytes in Use+  * % Committed Bytes in Use.
  
 === Event Logs === === Event Logs ===
Line 117: Line 117:
  
 == Time Clock Server == == Time Clock Server ==
-  * Clock communication – general items +  * Clock communication – general items. 
-  * Clock communication – error messages +  * Clock communication – error messages. 
-  * Clock communication – error situational problems+  * Clock communication – error situational problems.
   * Make sure that the recommended minimum backup strategy of a daily online backup is completed.   * Make sure that the recommended minimum backup strategy of a daily online backup is completed.
   * Verify that the previous backup operation completed.   * Verify that the previous backup operation completed.
-  * Verify that full backups succeeded +  * Verify that full backups succeeded. 
-  * Verify that transactional log Backups succeeded+  * Verify that transactional log backups succeeded.
   * Analyze and respond to errors and warnings during the backup operation.   * Analyze and respond to errors and warnings during the backup operation.
   * Verify that the transaction logs were successfully purged (if your backup type is purging logs).   * Verify that the transaction logs were successfully purged (if your backup type is purging logs).
Line 147: Line 147:
   * Review items that have not met target objectives.   * Review items that have not met target objectives.
  
-Note: Backup on this server is sync to the NAS+Note: Backup on this server is sync to the NAS.
  
 == Spark Server == == Spark Server ==
-  * Check disk space availability +  * Check disk space availability. 
-  * Check status of backups  +  * Check status of backups. 
-  * Check that the pmon process is running  +  * Check that the pmon process is running. 
-  * No changes to /etc/passwd /etc/shadow /etc/hosts /etc/group +  * No changes to ''/etc/passwd'', ''/etc/shadow'', ''/etc/hosts'', and ''/etc/group''. 
-  * Check the latest entries in the logs+  * Check the latest entries in the logs.
  
 Note: Manual backup users/groups from the web GUI Note: Manual backup users/groups from the web GUI
  
-== SWdev Server (Software Development) == +== Software Development Server (swdev) == 
-  * Check disk space availability +  * Check disk space availability. 
-  * Check status of backups  +  * Check status of backups. 
-  * Check that the pmon process is running  +  * Check that the pmon process is running. 
-  * No changes to /etc/passwd /etc/shadow /etc/hosts /etc/group +  * No changes to ''/etc/passwd'', ''/etc/shadow'', ''/etc/hosts'', ''/etc/group''. 
-  * Check the latest entries in the logs+  * Check the latest entries in the logs.
  
 == Web Server (www) == == Web Server (www) ==
-  * Check disk space availability +  * Check disk space availability. 
-  * Check status of backups  +  * Check status of backups.   
-  Check that the pmon process is running  +    Backup folder is ''/data/backup'' 
-  No changes to /etc/passwd /etc/shadow /etc/hosts /etc/group +    Backup script is ''/etc/cron.daily/backup'' 
-  Check the latest entries in the logs+    * Backup to mirror drive is ''/media/www/data'' 
 +    * Backup script to mirror drive is ''/etc/cron.daily/backuptomirror'' 
 +    Backup of mirrored ''swdev.audina.net'' server is ''/data/mirror''. This backup is created using ''rsync'' (see script ''/root/rsync-swdev.sh''). <code bash>#!/bin/bash 
 +rsync --daemon --config=/etc/rsyncd.conf 
 +root@www:~# cat rsync-swdev.sh 
 +#!/bin/bash
  
-NoteBackup sync/mirror to the internal drive and NAS+#rsync --verbose  --progress --stats --compress --rsh=/usr/bin/ssh \ 
 +#      --recursive --times --perms --links --delete \ 
 +#      --exclude "*bak" --exclude "*~"
 +#      192.168.0.160:webfiles /var/www/mirror
  
-== Emulator Server (BoSanova) == +# Website 
-  * User manual and installation procedures\\NAS\public\Software.apps\ES.server.Bosanova\DOCS +rsync --archive --verbose --progress --stats --rsh=/usr/bin/ssh \ 
-  * Check for emulator server services are running +--recursive --times --perms --links --delete --exclude=stats \ 
-  * Check for users’ connectivity+192.168.0.160::webfiles /data/mirror/swdev.audina.net/www
  
-== Router/Switches/Firewall gateway ==+# Databases 
 +rsync --archive --verbose --progress --stats --rsh=/usr/bin/ssh \ 
 +--recursive --times --perms --links --delete \ 
 +192.168.0.160::databases /data/mirror/swdev.audina.net/databases 
 + 
 +# Root user home 
 +rsync --archive --verbose --progress --stats --rsh=/usr/bin/ssh \ 
 +--recursive --times --perms --links --delete \ 
 +192.168.0.160::root /data/mirror/swdev.audina.net/root 
 + 
 +# Subserver Repositories 
 +rsync --archive --verbose --progress --stats --rsh=/usr/bin/ssh \ 
 +--recursive --times --perms --links --delete \ 
 +192.168.0.160::repos /data/mirror/swdev.audina.net/repos 
 +</code> 
 +  * Check that the ''pmon'' process is running. 
 +  * No changes to ''/etc/passwd'', ''/etc/shadow'', ''/etc/hosts'', ''/etc/group''
 +  * Check the latest entries in the logs. 
 + 
 +Note: Backup sync/mirror to the internal drive and NAS. 
 + 
 +== System36 Client Emulator Server (Bosânova) == 
 +  * User manual and installation procedures: ''\\NAS\public\Software.apps\ES.server.Bosanova\DOCS'' 
 +  * Check for emulator server services are running. 
 +  * Check for users’ connectivity. 
 + 
 +== Router/Switches/Firewall/Gateway ==
   * Check system monitor, CPU usage, uptime, disk usage, system load, and performance.   * Check system monitor, CPU usage, uptime, disk usage, system load, and performance.
-  * Check web security, black list, custom sites, and policies +  * Check web security, black list, custom sites, and policies. 
-  * Check and monitor remote user/VPN settings and logs +  * Check and monitor remote user/VPN settings and logs. 
-  * Assign and adjust network configuration settings related to the IP addresses were given are met+  * Assign and adjust network configuration settings related to the IP addresses were given are met.
   * Check for system logs, error messages, and system diagnostics to analyze the network connectivity.   * Check for system logs, error messages, and system diagnostics to analyze the network connectivity.
  
-== Suggestion ==+== Suggestions ==
   * Need to re-design a new network infrastructure for better productivity, connectivity, eliminate downtime, and point of failures.   * Need to re-design a new network infrastructure for better productivity, connectivity, eliminate downtime, and point of failures.
-  * All production servers need to be replaced at least once every five years +  * All production servers need to be replaced at least once every five years. 
-  * Need to replace all the home build servers: Infusion, Oncontact, and Timeclock. These servers do not have hardware redundant functionality to handle production environment. +  * Need to replace all the home built servers: ''Infusion''''OnContact'', and ''TimeClock''. These servers do not have hardware redundant functionality to handle production environment. 
-  * Need to rebuild and replace fileserver because of hardware failure and running out of space +  * Need to rebuild and replace ''Fileserver'' because of hardware failure and running out of space. 
-  * Need to rebuild and upgrade exchange server to exchange 2010 with backup and restore software licenses.+  * Need to rebuild and upgrade ''Exchange'' server to Exchange 2010 with backup and restore software licenses.
   * Need a new gateway router that can monitor Audina bandwidth, productivity, and threats from the outside world.   * Need a new gateway router that can monitor Audina bandwidth, productivity, and threats from the outside world.
-  * Need new network switches +  * Need new network switches. 
-  * Need to re-wire the whole network infrastructure +  * Need to re-wire the whole network infrastructure. 
-  * Need to install a patch panel +  * Need to install a patch panel. 
-  * Eliminate all the small network switches, this will cause the slowness and bottleneck of the network +  * Eliminate all the small network switches, this will cause the slowness and bottleneck of the network. 
-  * Need to replace all QC computers except Sherry’s computer +  * Need to replace all QC computers except Sherry’s computer. 
-  * Need to have a better Internet bandwidth for better productivity+  * Need to have a better Internet bandwidth for better productivity.
  
-NOTE: These suggestions had been told and mentioned when I (Thai) first started from day one. Keep in mindmy intentions here are to protect Audina’s data. +NOTE: These suggestions have been put forward to management when I first startedfrom day one. Keep in mindmy intentions here are to protect Audina’s data.  --- //[[ttran@audina.net|Thai Tran]] 2011/10/28 12:19//