March 09, 2007

DB administration simplification

Oracle-friendlier solution helps with standardization, patching

As organizations grow, their application and database scenarios can become more complex, and it becomes increasingly important for IT to standardize the deployments of these environments. Standardization not only reduces mistakes by ensuring that each deployment is done exactly the same way, but it decreases deployment time. Fortunately, solutions are available to assist with the process, such as GridApp’s database automation management solution, Clarity 3.5, aimed at companies running Oracle, Oracle RAC (Real Application Clusters), and to a lesser degree, SQL Server.

Installing Clarity is fairly straightforward: Install the Clarity Manager management server and the repository database (if you’re going to have one). Of course, you also must upload all of the software you’re going to manage, be it Oracle, SQL Server, or RAC, as well as any patches you’re going to push out.

The next step is to start adding servers to “grids” (these aren’t performance grids, it’s just the name GridApp uses for the top-level storage containers). Then install management agents on them by simply pushing them out from the Clarity server. Now you’re ready to create your templates.

XML simplicity
Templates are the basis for everything you’ll do in Clarity. Configuring them is easy as they’re XML-based, so it’s really no problem to create any number with both dynamic and static options. This is a very powerful function, especially for RAC deployments, which are complex and fraught with potential pitfalls. Being able to specify that certain options get implemented with specific values is not only incredibly important, it’s a huge time-saver.

Once I had my templates created, I was able to provision a primary instance of a new RAC cluster in just a few minutes via the management server UI. Provisioning the next node was even easier because Clarity is smart enough to know what can and can’t be changed when you add a node to an existing cluster. Thus, some options are static no matter how you configured them in the template. As a result,


Click for larger view.


anyone in the datacenter can easily add a node to the cluster: All you have to do is provide the name of the cluster, and everything else is done automatically.

Notably, Clarity can’t provision SQL Server clusters, which is indicative of its relatively limited SQL support.

I was pleasantly surprised by how easy it was to add nodes. However, I have to criticize the fact that you must go through the wizard each time. You can’t schedule deployments, and you can’t run them unattended. Don’t get me wrong; the time savings are still significant, it’d just be nice to have a one-click solution. Additionally, I don’t like that you can’t prevent someone from deploying Oracle or SQL Server on a managed box; Clarity will just tell you that it’s been done after the fact.

Test Center Scorecard
25%25%10%10%10%10%10%
GridApp Clarity 3.58889888
8.1
Very Good
Close

On Twitter now

Security

Powered by Twitter

On Twitter now

additional resources
White Paper - How to Improve Delivery of Advanced Web Applications

White Paper

Virtual Workforce: The Key to Expanding The Business While Cutting Costs

Get the independent advice and expertise you need to support a virtual workforce.

Go inside:
The three-step approach to making a virtual workforce a reality.
The four flavors of client virtualization technologies.
The three key initiatives that solve IT challenges.
Download now »
White Paper: Successfully Secure Your Wireless LAN With Wi-Fi firewalls.

White Paper

Addressing Linux Threats Leveraging Fewer Resources

The increase in Linux popularity has increased the frequency and sophistication of malware attacks. Read this 2 page white paper now to learn how you can protect your Linux environment with real-time protection that is certified by all major Linux vendors.

Download now »
White Paper - The 2009 Handbook of Application Delivery

White Paper

The 2009 Handbook of Application Delivery

Ensuring acceptable application delivery will become even more difficult over the next few years. As a result, IT organizations need to ensure that the approach that they take to resolving the current application delivery challenges can scale to support the emerging challenges. This handbook elaborates on the key tasks associated with planning, optimization, management and control and provides decision criteria to help IT organizations choose appropriate solutions.

Download now »
White Paper - Is Your Backup System Outdated?

White Paper

Mid-range Storage Considerations

A common misconception is that mid-range storage requirements are dramatically different than that of a larger enterprise. Mid-range storage users may require less capacity, but they have similar functionality and management requirements. This ESG paper examines mid-range storage needs and reviews a new solution that adjusts size while retaining value, performance and functionality.

Download now »

Sign up to receive Security Resource Alerts

Subscribe to the Security Central Newsletter

Stay informed of the latest security threats and fixes.

White paper

Log Management: How to Develop the Right Strategy for Business and Compliance

This white paper provides guidance on how to develop a strategic approach to managing and monitoring logs, a key function required for compliance with many regulatory mandates and a critical defense against security threats.

Download now! »

White paper

The Essential Series: Security Information Management

Learn about the processes and technologies that support security information management (SIM) operations, as well as the business case for SIM. The series examines different options for implementing SIM and gives you evaluation criteria for selecting the best option for your organization.

Download now! »

White paper

Aberdeen: Choosing and Consuming Managed Security Services

Learn the strategies, actions, and capabilities that Best-in-Class organizations employ and technologies they choose to obtain superior performance against various security performance metrics. This report provides guidelines for identifying which security solutions to consume as a MSS and defines best practices for choosing and managing MSSPs.

Download now! »
©1994-2010 Infoworld, Inc.