public void replication()
{
// Set the server and database names
string distributionDbName = "TestDb";
string publisherName = "DESKTOP-9UAIISP\\MSSQLSERVER2017";
string publicationDbName = "TestMergeDb";
DistributionDatabase distributionDb;
ReplicationServer distributor;
DistributionPublisher publisher;
ReplicationDatabase publicationDb;
// Create a connection to the server using Windows Authentication.
ServerConnection conn = new ServerConnection(publisherName, "sa", "Ads78ghj@2");
try
{
// Connect to the server acting as the Distributor
// and local Publisher.
conn.Connect();
// Define the distribution database at the Distributor,
// but do not create it now.
distributionDb = new DistributionDatabase(distributionDbName, conn);
distributionDb.MaxDistributionRetention = 96;
distributionDb.HistoryRetention = 120;
// Set the Distributor properties and install the Distributor.
// This also creates the specified distribution database.
distributor = new ReplicationServer(conn);
distributor.InstallDistributor("sa", distributionDb);
// Set the Publisher properties and install the Publisher.
publisher = new DistributionPublisher(publisherName, conn);
publisher.DistributionDatabase = distributionDb.Name;
publisher.WorkingDirectory = @"\\" + publisherName + @"\repldata";
publisher.PublisherSecurity.WindowsAuthentication = true;
publisher.Create();
// Enable AdventureWorks2012 as a publication database.
publicationDb = new ReplicationDatabase(publicationDbName, conn);
publicationDb.EnabledTransPublishing = true;
publicationDb.EnabledMergePublishing = true;
}
catch (Exception ex)
{
// Implement appropriate error handling here.
throw new ApplicationException("An error occured when installing distribution and publishing.", ex);
}
finally
{
conn.Disconnect();
}
}
//配置发布和分发服务器
protected void Button5_Click(object sender, EventArgs e)
{
string distributionDbName = "distribution";
string publisherName = SMO.publisherName; //"rd01";发布者服务器名
string publicationDbName = SMO.publicationDatabase; //"HdHouse";发布的数据库名
DistributionDatabase distributionDb;
ReplicationServer distributor;
DistributionPublisher publisher;
ReplicationDatabase publicationDb;
// Create a connection to the server using Windows Authentication.
ServerConnection conn = new ServerConnection(publisherName);
try
{
// Connect to the server acting as the Distributor
// and local Publisher.
conn.Connect();
// Define the distribution database at the Distributor,
// but do not create it now.
distributionDb = new DistributionDatabase(distributionDbName, conn);
distributionDb.MaxDistributionRetention = 96;
distributionDb.HistoryRetention = 120;
// Set the Distributor properties and install the Distributor.
// This also creates the specified distribution database.
distributor = new ReplicationServer(conn);
distributor.InstallDistributor((string)null, distributionDb);
// Set the Publisher properties and install the Publisher.
publisher = new DistributionPublisher(publisherName, conn);
publisher.DistributionDatabase = distributionDb.Name;
publisher.WorkingDirectory = @"\\" + publisherName + @"\repldata";//用于访问快照文件的共享目录。
publisher.PublisherSecurity.WindowsAuthentication = true;
publisher.Create();
// Enable AdventureWorks as a publication database.
publicationDb = new ReplicationDatabase(publicationDbName, conn);
publicationDb.EnabledTransPublishing = true;
publicationDb.EnabledMergePublishing = true;
}
catch (Exception ex)
{
// Implement appropriate error handling here.
throw new ApplicationException("An error occured when installing distribution and publishing.", ex);
TextBox3.Text += "An error occured when installing distribution and publishing." + ex + " \r\n";
}
finally
{
conn.Disconnect();
}
}
// Loop while program is running and ping trusted nodes to determine whether they are online or offline
// When a node comes online, distribute indexes to that node
public void BeginIndexDistribution()
{
DistributionDatabase ddb = new DistributionDatabase();
List <string> guidList = new List <string>();
NodeDatabase ndb = new NodeDatabase();
string online = "online";
string offline = "offline";
ddb.ResetStatus();
while (distribute)
{
guidList = ndb.SelectGUID();
foreach (string currentGUID in guidList)
{
if (Node.GetGuid() != Guid.Parse(currentGUID))
{
Thread.Sleep(1000);
ddb.InsertNode(currentGUID, offline);
if (ndb.SelectNodeTrusted(Guid.Parse(currentGUID)) == "yes")
{
Ping pingSender = new Ping();
int timeout = 100;
try
{
IPAddress ip = ndb.SelectNodeIp(Guid.Parse(currentGUID));
PingReply reply = pingSender.Send(ip, timeout);
if (reply.Status == IPStatus.Success)
{
if (ddb.GetStatus(currentGUID) == offline)
{
sendIndexes(currentGUID);
ddb.UpdateStatus(currentGUID, online);
}
}
else
{
ddb.UpdateStatus(currentGUID, offline);
}
}
catch (Exception ex)
{
Debug.Print(ex.Message);
}
}
else
{
ddb.UpdateStatus(currentGUID, offline);
}
}
}
}
}
// Send indexes to all trusted nodes that are online
// For use after a backup and associated index insertion have occurred
public void sendIndexes()
{
IndexDatabase idd = new IndexDatabase();
if (!idd.TablesEmpty()) //if there are indexes to send
{
DistributionDatabase ddb = new DistributionDatabase();
List <string> guidList = new List <string>();
NodeDatabase ndb = new NodeDatabase();
string online = "online";
string indexDBCopy = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetEntryAssembly().Location) + @"\indexes_" + (Properties.Settings.Default.guid).ToString() + ".s3db";
if (System.IO.File.Exists(idd.GetPathFileName()))
{
try
{
System.IO.File.Copy(idd.GetPathFileName(), indexDBCopy, true);
}
catch (System.IO.IOException e)
{
Debug.Print(e.Message);
}
}
guidList = ndb.SelectGUID();
foreach (string currentGUID in guidList)
{
if (Node.GetGuid() != Guid.Parse(currentGUID) && ddb.GetStatus(currentGUID) == online && ndb.SelectNodeTrusted(Guid.Parse(currentGUID)) == "yes")
{
Guid myGuid = Node.GetGuid();
TcpClient tcpClient = new TcpClient((ndb.SelectNodeIp(Guid.Parse(currentGUID))).ToString(), 7890);
ClientThread ct = new ClientThread(tcpClient, false, myGuid);
PushIndexRequest pir = new PushIndexRequest(indexDBCopy, new FileInfo(indexDBCopy).Length);
ct.EnqueueWork(pir);
NetworkResponse response = (NetworkResponse)ct.DequeueEvent();
while (ct.IsWorking())
{
Thread.Sleep(1000);
}
ct.RequestStop();
while (ct.IsAlive())
{
Thread.Sleep(1000);
}
}
}
}
}
//配置发布和分发服务器
protected void Button5_Click(object sender, EventArgs e)
{
string distributionDbName = "distribution";
string publisherName =SMO.publisherName;//"rd01";发布者服务器名
string publicationDbName = SMO.publicationDatabase; //"HdHouse";发布的数据库名
DistributionDatabase distributionDb;
ReplicationServer distributor;
DistributionPublisher publisher;
ReplicationDatabase publicationDb;
// Create a connection to the server using Windows Authentication.
ServerConnection conn = new ServerConnection(publisherName);
try
{
// Connect to the server acting as the Distributor
// and local Publisher.
conn.Connect();
// Define the distribution database at the Distributor,
// but do not create it now.
distributionDb = new DistributionDatabase(distributionDbName, conn);
distributionDb.MaxDistributionRetention = 96;
distributionDb.HistoryRetention = 120;
// Set the Distributor properties and install the Distributor.
// This also creates the specified distribution database.
distributor = new ReplicationServer(conn);
distributor.InstallDistributor((string)null, distributionDb);
// Set the Publisher properties and install the Publisher.
publisher = new DistributionPublisher(publisherName, conn);
publisher.DistributionDatabase = distributionDb.Name;
publisher.WorkingDirectory = @"\\" + publisherName + @"\repldata";//用于访问快照文件的共享目录。
publisher.PublisherSecurity.WindowsAuthentication = true;
publisher.Create();
// Enable AdventureWorks as a publication database.
publicationDb = new ReplicationDatabase(publicationDbName, conn);
publicationDb.EnabledTransPublishing = true;
publicationDb.EnabledMergePublishing = true;
}
catch (Exception ex)
{
// Implement appropriate error handling here.
throw new ApplicationException("An error occured when installing distribution and publishing.", ex);
TextBox3.Text += "An error occured when installing distribution and publishing." + ex + " \r\n";
}
finally
{
conn.Disconnect();
}
}
