authorizations

  • Oracle
  • ForgeRock
  • symantec
  • gurulabs
Newsletter

Would you like to receive newsletters? Send us your email.

Advanced Management and Tuning of High Availability Database (HADB) (WMT-IAS-3435)

Course ID : WMT-IAS-3435 Duration : days

This course explores the HADB internals, delving deeper into topics introduced in WMT-IAS-2434: Fundamentals of Highly Available Database. It focuses on providing students with advanced management, performance tuning, and troubleshooting techniques for HADB.



Select date

Course ID :
WMT-IAS-3435

Price

Duration
days

Book

Who Can Benefit

Students who can benefit from this course are:

  • Developers and quality engineers who use HADB as component products, such as Sun Java System Application Server Enterprise Edition.
  • Technical consultants and support engineers who work with customers using the Application Server and other Sun products that have HADB as a component and need deeper insight to support/troubleshoot the products
  • The administrators who deploy Sun products at customer sites who need deeper understanding of HADB to manage and tune HADB instances correctly

Prerequisites

  • Have a basic understanding or experience or both with Relational/Distributed Database Management Systems(DBMS), Standard Query Language (SQL) and JDBC
  • Have basic UNIX administration skills (Solaris Operating System (Solaris OS) preferred)
  • Have a basic understanding of Fault Tolerance, preferred though not required.
  • Understand the fundamentals of HADB
:

Skills Gained

  • Perform advanced configurations
  • Scale HADB
  • Monitor HADB
  • Tune HADB
  • Use the new management system introduced in the Sun Java System Application Server 7 2004Q2 Windows version, which will be used in the Sun Java System Application Server 8.1.

Course Content

Module 1 - Inside HADB

  • Explain how HADB executes a transaction
    • How a client connection is handled
    • How two-phase commit works
  • Explain how HADB stores and manages data, including shared memory layout, disk devices, checkpointing and locking.
  • Describe how HADB nodes keep a consistent system view

Module 2 - Performing Advanced Management Tasks

  • Configure the database to use heterogeneous data devices and double networks
  • Manage a domain
  • Scale the database online
  • Describe how to upgrade the software and hardware on the HADB machines online, ie: Rolling Upgrade.
  • Retrieve resource usage information
  • Use the query tool - clusql to access the database

Module 3 - Monitoring and Tuning HADB

  • Describe what an administrator should monitor
    • How the database and the OS interact
    • Which database configuration variables need to be tuned, and how to tune them
  • Describe procedures for debugging HADB
  • Describe the tasks performed by an administrator