public void GenerateDefaultChildren(ServerVersion myDbServerVersion, ServerVersion nodeServerVersion)
{
// Generate database definitions
GenerateMyDBDefinition(myDbServerVersion);
GenerateCodeDBDefinition(nodeServerVersion);
// Job definitions
var eji = new ExportTablesJobInstaller(federation);
eji.Install();
var emji = new ExportMaintenanceJobInstaller(federation);
emji.Install();
var jdi = new SqlQueryJobInstaller(federation);
jdi.Install();
federation.Save();
}
public void GenerateDefaultChildren(ServerVersion myDbServerVersion)
{
// MyDB database definition
DatabaseDefinition mydbdd = new DatabaseDefinition(federation)
{
Name = Constants.MyDbName,
System = federation.System,
LayoutType = DatabaseLayoutType.Monolithic,
DatabaseInstanceNamePattern = Constants.MyDbInstanceNamePattern,
DatabaseNamePattern = Constants.MyDbNamePattern,
SliceCount = 1,
PartitionCount = 1,
};
mydbdd.Save();
var mydbddi = new DatabaseDefinitionInstaller(mydbdd);
mydbddi.GenerateDefaultChildren(myDbServerVersion, Constants.MyDbName);
mydbdd.LoadDatabaseVersions(true);
federation.MyDBDatabaseVersion = mydbdd.DatabaseVersions[Constants.MyDbName];
// Job definitions
var jd = new JobDefinition(federation)
{
Name = typeof(Jobs.ExportTable.ExportTableJob).Name,
System = federation.System,
WorkflowTypeName = typeof(Jobs.ExportTable.ExportTableJob).AssemblyQualifiedName,
};
jd.Save();
jd = new JobDefinition(federation)
{
Name = typeof(Jobs.ExportTable.ExportMaintenanceJob).Name,
System = federation.System,
WorkflowTypeName = typeof(Jobs.ExportTable.ExportMaintenanceJob).AssemblyQualifiedName,
};
jd.Save();
var jdi = new SqlQueryJobInstaller(federation);
jdi.Install();
federation.Save();
}
private void GenerateCodeDBDefinition(ServerVersion nodeServerVersion)
{
DatabaseDefinition codedbdd = new DatabaseDefinition(federation)
{
Name = Constants.CodeDbName,
System = federation.System,
LayoutType = DatabaseLayoutType.Mirrored,
DatabaseInstanceNamePattern = Constants.CodeDbInstanceNamePattern,
DatabaseNamePattern = Constants.CodeDbNamePattern,
SliceCount = 1,
PartitionCount = 1,
};
codedbdd.Save();
var codedbddi = new DatabaseDefinitionInstaller(codedbdd);
codedbddi.GenerateDefaultChildren(nodeServerVersion, Constants.CodeDbName);
codedbdd.LoadDatabaseVersions(true);
federation.CodeDatabaseVersion = codedbdd.DatabaseVersions[Constants.CodeDbName];
}
private void GenerateMyDBDefinition(ServerVersion myDbServerVersion)
{
DatabaseDefinition mydbdd = new DatabaseDefinition(federation)
{
Name = Constants.MyDbName,
System = federation.System,
LayoutType = DatabaseLayoutType.Monolithic,
DatabaseInstanceNamePattern = Constants.MyDbInstanceNamePattern,
DatabaseNamePattern = Constants.MyDbNamePattern,
SliceCount = 1,
PartitionCount = 1,
};
mydbdd.Save();
var mydbddi = new DatabaseDefinitionInstaller(mydbdd);
mydbddi.GenerateDefaultChildren(myDbServerVersion, Constants.MyDbName);
mydbdd.LoadDatabaseVersions(true);
federation.MyDBDatabaseVersion = mydbdd.DatabaseVersions[Constants.MyDbName];
}
/// <summary>
/// Initializes a database definition.
/// </summary>
/// <param name="serverVersion"></param>
public void GenerateDefaultChildren(ServerVersion serverVersion, string databaseVersionName)
{
// If not sliced, then create a default slice of FULL
if (databaseDefinition.LayoutType == DatabaseLayoutType.Mirrored ||
databaseDefinition.LayoutType == DatabaseLayoutType.Monolithic)
{
Slice sl = new Slice(databaseDefinition)
{
Name = Constants.FullSliceName,
System = databaseDefinition.System,
};
sl.Save();
}
else
{
throw new InvalidOperationException();
// Use slicing wizard instead
}
// Add primary filegroup
FileGroupLayoutType fglayout;
switch (databaseDefinition.LayoutType)
{
case DatabaseLayoutType.Sliced:
fglayout = FileGroupLayoutType.Sliced;
break;
case DatabaseLayoutType.Monolithic:
case DatabaseLayoutType.Mirrored:
fglayout = FileGroupLayoutType.Monolithic;
break;
default:
throw new NotImplementedException();
}
FileGroup fg = new FileGroup(databaseDefinition)
{
Name = Constants.PrimaryFileGroupName,
System = databaseDefinition.System,
FileGroupType = FileGroupType.Data,
LayoutType = fglayout,
AllocationType = FileGroupAllocationType.CrossVolume,
DiskVolumeType = DiskVolumeType.Data,
FileGroupName = Constants.PrimaryFileGroupName,
AllocatedSpace = Constants.PrimaryFileGroupSize,
FileCount = 0,
};
fg.Save();
// Add "log" file group
fg = new FileGroup(databaseDefinition)
{
Name = Constants.LogFileGroupName,
System = databaseDefinition.System,
FileGroupType = FileGroupType.Log,
LayoutType = FileGroupLayoutType.Monolithic,
AllocationType = FileGroupAllocationType.CrossVolume,
DiskVolumeType = DiskVolumeType.Log,
FileGroupName = Constants.LogFileGroupName,
AllocatedSpace = Constants.LogFileGroupSize,
FileCount = 0
};
fg.Save();
// Create default database version
DatabaseVersion dv = new DatabaseVersion(databaseDefinition)
{
Name = databaseVersionName,
System = databaseDefinition.System,
ServerVersion = serverVersion,
SizeMultiplier = 1.0f,
};
dv.Save();
}
public Cluster Install(bool system, string clusterName, string username, string email, string password)
{
cluster = new Cluster(Context)
{
Name = clusterName,
System = system,
};
cluster.Save();
// Create machine roles and machines
// -- controller role
var mrcont = new MachineRole(cluster)
{
Name = Constants.ControllerMachineRoleName,
System = system,
MachineRoleType = MachineRoleType.StandAlone,
};
mrcont.Save();
var sv = new ServerVersion(mrcont)
{
Name = Constants.ServerVersionName,
System = system,
};
sv.Save();
var mcont = new Machine(mrcont)
{
Name = Constants.ControllerMachineName,
};
mcont.Save();
var sicont = new ServerInstance(mcont)
{
Name = Constants.ServerInstanceName,
ServerVersion = sv,
};
sicont.Save();
// -- node role
var mrnode = new MachineRole(cluster)
{
Name = Constants.NodeMachineRoleName,
MachineRoleType = MachineRoleType.MirroredSet,
};
mrnode.Save();
var nodesv = new ServerVersion(mrnode)
{
Name = Constants.ServerVersionName,
};
nodesv.Save();
// -- Create a node
/*
Machine mnode = new Machine(Context, mrnode);
mnode.Name = Constants.NodeMachineName;
mnode.Save();
si = new ServerInstance(Context, mnode);
si.Name = Constants.ServerInstanceName;
si.ServerVersionReference.Value = sv;
si.Save();*/
// Create the shared domain for cluster level databases and users
var domain = new Domain(cluster)
{
Name = Constants.SharedDomainName,
Email = email,
System = system,
};
domain.Save();
// Create administrator group and user
GenerateAdminGroup(system);
GenerateAdmin(system, username, email, password);
// Create the shared feredation
var federation = new Federation(domain)
{
Name = Constants.SharedFederationName,
Email = email,
System = system,
ControllerMachine = mcont,
SchemaSourceServerInstance = sicont,
};
federation.Save();
// Temp database definition
var tempdd = new DatabaseDefinition(federation)
{
Name = Constants.TempDbName,
System = system,
LayoutType = DatabaseLayoutType.Monolithic,
DatabaseInstanceNamePattern = Constants.TempDbInstanceNamePattern,
DatabaseNamePattern = Constants.TempDbNamePattern,
SliceCount = 1,
PartitionCount = 1,
};
tempdd.Save();
var tempddi = new DatabaseDefinitionInstaller(tempdd);
tempddi.GenerateDefaultChildren(nodesv, Constants.TempDbName);
// Create cluster level jobs and queues
// -- admin queue definition
QueueDefinition qd = new QueueDefinition(cluster)
{
Name = Constants.MaintenanceQueueDefinitionName,
System = system,
};
qd.Save();
QueueInstance qi = new QueueInstance(mcont)
{
Name = Constants.MaintenanceQueueName,
RunningState = Registry.RunningState.Running,
};
qi.QueueDefinitionReference.Value = qd;
qi.Save();
// -- long queue definition
qd = new QueueDefinition(cluster)
{
Name = Constants.LongQueueDefinitionName
};
qd.Save();
qi = new QueueInstance(mcont)
{
Name = Constants.LongQueueName,
RunningState = Registry.RunningState.Running,
};
qi.QueueDefinitionReference.Value = qd;
qi.Save();
// -- quick queue definition
qd = new QueueDefinition(cluster)
{
Name = Constants.QuickQueueDefinitionName,
};
qd.Save();
qi = new QueueInstance(mcont)
{
Name = Constants.QuickQueueName,
RunningState = Registry.RunningState.Running,
};
qi.QueueDefinitionReference.Value = qd;
qi.Save();
// -- database mirror job
var jd = new JobDefinition(federation)
{
Name = typeof(Jhu.Graywulf.Jobs.MirrorDatabase.MirrorDatabaseJob).Name,
System = system,
WorkflowTypeName = typeof(Jhu.Graywulf.Jobs.MirrorDatabase.MirrorDatabaseJob).AssemblyQualifiedName,
};
jd.DiscoverWorkflowParameters();
jd.Save();
// -- test job
jd = new JobDefinition(federation)
{
Name = typeof(Jhu.Graywulf.Jobs.Test.TestJob).Name,
System = system,
WorkflowTypeName = typeof(Jhu.Graywulf.Jobs.Test.TestJob).AssemblyQualifiedName,
};
jd.DiscoverWorkflowParameters();
jd.Save();
return cluster;
}
public void Install(bool system, string clusterName, string username, string email, string password)
{
var cluster = new Cluster(Context)
{
Name = clusterName,
System = system,
};
cluster.Save();
// Create administrator group and user
var ug = new UserGroup(cluster)
{
Name = Constants.ClusterAdministratorUserGroupName,
System = system,
};
ug.Save();
var u = new User(cluster)
{
Name = username,
System = system,
Email = email,
DeploymentState = Registry.DeploymentState.Deployed,
};
u.SetPassword(password);
u.Save();
u.MakeMemberOf(ug.Guid);
// Create machine roles and machines
// -- controller role
var mrcont = new MachineRole(cluster)
{
Name = Constants.ControllerMachineRoleName,
System = system,
MachineRoleType = MachineRoleType.StandAlone,
};
mrcont.Save();
var sv = new ServerVersion(mrcont)
{
Name = Constants.ServerVersionName,
};
sv.Save();
var mcont = new Machine(mrcont)
{
Name = Constants.ControllerMachineName,
};
mcont.Save();
var si = new ServerInstance(mcont)
{
Name = Constants.ServerInstanceName,
ServerVersion = sv,
};
si.Save();
// -- node role
var mrnode = new MachineRole(cluster)
{
Name = Constants.NodeMachineRoleName,
MachineRoleType = MachineRoleType.MirroredSet,
};
mrnode.Save();
sv = new ServerVersion(mrnode)
{
Name = Constants.ServerVersionName,
};
sv.Save();
// -- Create a node
/*
Machine mnode = new Machine(Context, mrnode);
mnode.Name = Constants.NodeMachineName;
mnode.Save();
si = new ServerInstance(Context, mnode);
si.Name = Constants.ServerInstanceName;
si.ServerVersionReference.Value = sv;
si.Save();*/
// Temp database definition
var tempdd = new DatabaseDefinition(cluster)
{
Name = Constants.TempDbName,
System = system,
LayoutType = DatabaseLayoutType.Monolithic,
DatabaseInstanceNamePattern = Constants.TempDbInstanceNamePattern,
DatabaseNamePattern = Constants.TempDbNamePattern,
SliceCount = 1,
PartitionCount = 1,
};
tempdd.Save();
var tempddi = new DatabaseDefinitionInstaller(tempdd);
tempddi.GenerateDefaultChildren(sv, Constants.TempDbName);
// Create cluster level jobs and queues
// -- admin queue definition
QueueDefinition qd = new QueueDefinition(cluster)
{
Name = Constants.MaintenanceQueueDefinitionName,
System = system,
};
qd.Save();
QueueInstance qi = new QueueInstance(mcont)
{
Name = Constants.MaintenanceQueueName,
RunningState = Registry.RunningState.Running,
};
qi.QueueDefinitionReference.Value = qd;
qi.Save();
// -- long queue definition
qd = new QueueDefinition(cluster)
{
Name = Constants.LongQueueDefinitionName
};
qd.Save();
qi = new QueueInstance(mcont)
{
Name = Constants.LongQueueName,
RunningState = Registry.RunningState.Running,
};
qi.QueueDefinitionReference.Value = qd;
qi.Save();
// -- quick queue definition
qd = new QueueDefinition(cluster)
{
Name = Constants.QuickQueueDefinitionName,
};
qd.Save();
qi = new QueueInstance(mcont)
{
Name = Constants.QuickQueueName,
RunningState = Registry.RunningState.Running,
};
qi.QueueDefinitionReference.Value = qd;
qi.Save();
// -- database mirror job
var jd = new JobDefinition(cluster)
{
Name = typeof(Jhu.Graywulf.Jobs.MirrorDatabase.MirrorDatabaseJob).Name,
System = system,
WorkflowTypeName = typeof(Jhu.Graywulf.Jobs.MirrorDatabase.MirrorDatabaseJob).AssemblyQualifiedName,
};
jd.Save();
// -- test job
jd = new JobDefinition(cluster)
{
Name = typeof(Jhu.Graywulf.Jobs.Test.TestJob).Name,
System = system,
WorkflowTypeName = typeof(Jhu.Graywulf.Jobs.Test.TestJob).AssemblyQualifiedName,
};
jd.Save();
}
/// <summary>
/// Copy contructor for doing deep copy of the <b>Server Version</b> objects.
/// </summary>
/// <param name="old">The <b>Server Version</b> to copy from.</param>
public ServerVersion(ServerVersion old)
: base(old)
{
CopyMembers(old);
}
/// <summary>
/// Creates a deep copy of the passed object.
/// </summary>
/// <param name="old">A <b>Server Instance</b> object to create the deep copy from.</param>
private void CopyMembers(ServerVersion old)
{
this.instanceName = old.instanceName;
this.integratedSecurity = old.integratedSecurity;
this.adminUser = old.adminUser;
this.adminPassword = old.adminPassword;
}