RAD Studio VCL Reference
|
Contains the valid values for the TYPE column from DB_ADMIN.GET_MIRRORS stored procedure.
MirrorTypes = class;
class MirrorTypes;
MirrorTypes.cs
MirrorTypes contains the valid values for the TYPE column from DB_ADMIN.GET_MIRRORS stored procedure. These values are also found in the system table SYS.SYSMIRRORS.
The valid values are:
Constant |
Description |
NONE |
Mirroring not enabled. |
PRIMARY |
There is only one primary mirror. It is the only mirror that supports any form of write operation on the database. |
READONLY |
There can be one or more READONLY MIRRORS. READONLY mirrors support read operations, but not write operations. READONLY mirrors provide a view of the PRIMARY database at the point in time they were last synchronized with the PRIMARY. |
DIRECTORY |
There can be one or more DIRECTORY MIRRORS. DIRECTORY mirrors support read operations, but not write operations. A DIRECTORY mirror mirrors the SYS.MIRRORS table, but not the data itself. Connection requests to a DIRECTORY mirror are redirected to the PRIMARY mirror if a writable connection is needed. Otherwise a load balancing algorithm is used to decide which READONLY mirror should be used for the connection. |
Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
|
What do you think about this topic? Send feedback!
|