Figure 8-25. FQDNs are required for mirroring. Thus, starting with the configuration shown
here would fail.
I could just put in my IP address, but I don??™t want anyone having my IP address
either. Instead, I??™m going to use what??™s known as the loopback address, which every
server translates to 127.0.0.1. This sidesteps the need for an FQDN for each instance.
Once I make that change, I can turn on mirroring, as shown in Figure 8-26.
CHAPTER 8 n DATABASE MIRRORING 222
Figure 8-26. Using the loopback address, you can now start mirroring.
The database mirroring session is now running in High Availability mode, so failover
will be automatic, and all communication is synchronous. However, once you??™ve configured
mirroring, you can easily change the mirroring mode. Next I??™ll explain why you??™d
want to use one mode over another.
Guidelines for Selecting a Database
Mirroring Mode
Although I??™ve discussed how database mirroring works and how to configure it, I still
haven??™t addressed what I think is the most important question of all: what do you do with
database mirroring? Database mirroring is certainly not a cure-all for disaster mitigation,
nor is it a High Availability solution.
Pages:
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416