Assessments - 0, GPA: 0
(
)
)
|
por este dispositivo também tem outras instruções :
Facilidade de uso
Matrix DataBase Solution Pack for SQL Server™ Release Notes
2
• Role-based security. Using the role-based security feature provided
with Matrix Server, you can create a role to manage Virtual SQL
Servers and Virtual SQL Instances.
New Active-Passive Architecture
In the 3.4 release, MxDB for SQL Server used a Primary-Backup
architecture. For example, when you virtualized a SQL server instance in
a two-node cluster, you would declare one node to be the primary for the
instance and the second node to be the backup. The high-availability
engine provided with MxDB for SQL Server would then create a profile
for each node.
A profile is a container consisting of the SQL data (that is, databases and
logs) and the corresponding registry setting necessary for starting an
instance of SQL Server. With the Primary-Backup architecture, also called
the “N model,” the total number of profiles for a virtualized SQL instance
is equal to the number of nodes participating in the Virtual SQL Server. If
the primary node goes down, the SQL high-availability engine will
mount the profile from that node onto the backup node and then bring up
the SQL instance on that node. Although this architecture provides high-
availability, it can be susceptible to duplicate registry issues.
The new Active-Passive architecture provided with the 3.6 release is very
flexible and highly resistant to the duplicate registry issue. This new
architecture provides an “N+1 model.” For a two-node cluster, there are
now three profiles: the two local profiles (N) and a clustered profile (+1).
The clustered profile can move around the cluster, and when mounted on
a node, it turns the state of the node from passive to active. At any one
point in time, the node running with the clustered profile (the “+1”
profile) is the active node and all other nodes are passive (that is, running
with their local “N” profiles).
On the PolyServe Management Console, the active node is specified as
the primary node and the passive nodes are specified as backup nodes.
Copyright © 1999-2007 PolyServe, Inc. All rights reserved.
...