Thus, SQL Agent would start on the secondary
node, firing the batch job. Sounds like a lot of work for a simple issue, doesn??™t
it? It was. That??™s why including cluster-unaware applications in a clustered environment
is frowned upon (personally, I consider the practice scowled upon).
Sample Clustering Configurations
Even though clustering provides some level of hardware redundancy, there are a variety
of possible configurations. Different configurations do have some impact on the level of
protection, but you??™re still just dealing with hardware protection.
Active/Passive
When restricted to having just two nodes, the active/passive configuration is my preferred
configuration. Everything runs on the first node, while the second node does
nothing but sit idly by waiting for a failover, as shown in Figure 7-2. You??™re assured that
the passive node has all of the available resources to resume operation; you don??™t need to
worry about juggling memory or CPU utilization.
CHAPTER 7 n CLUSTERING 183
Figure 7-2. An active/passive cluster configuration
The drawback to this situation is that the second node is essentially wasted hardware.
Pages:
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357