/// <summary>
/// Removes a server from group
/// </summary>
/// <param name="name">Server name</param>
internal protected void RemoveServer(string name)
{
ReplicationServer serverToRemove = GetServer(name);
if (serverToRemove == null)
{
throw new MySqlException(String.Format(Resources.ReplicationServerNotFound, name));
}
servers.Remove(serverToRemove);
}
protected internal void RemoveServer(string name)
{
ReplicationServer server = this.GetServer(name);
if (server == null)
{
throw new MySqlException(string.Format(Resources.ReplicationServerNotFound, name));
}
this.servers.Remove(server);
}
internal static void GetNewConnection(string groupName, bool master, MySqlConnection connection)
{
while (true)
{
object obj = ReplicationManager.thisLock;
lock (obj)
{
if (ReplicationManager.IsReplicationGroup(groupName))
{
ReplicationServerGroup group = ReplicationManager.GetGroup(groupName);
ReplicationServer server = group.GetServer(master, connection.Settings);
if (server == null)
{
throw new MySqlException(Resources.Replication_NoAvailableServer);
}
try
{
bool flag2 = false;
if (connection.driver == null || !connection.driver.IsOpen)
{
flag2 = true;
}
else if (!new MySqlConnectionStringBuilder(server.ConnectionString).Equals(connection.driver.Settings))
{
flag2 = true;
}
if (flag2)
{
Driver driver = Driver.Create(new MySqlConnectionStringBuilder(server.ConnectionString));
connection.driver = driver;
}
}
catch (MySqlException ex)
{
connection.driver = null;
server.IsAvailable = false;
MySqlTrace.LogError(ex.Number, ex.ToString());
if (ex.Number == 1042)
{
group.HandleFailover(server, ex);
continue;
}
throw;
}
}
}
break;
}
}
public FabricServer(Guid serverUuid, string groupId, string host, int port, FabricServerModeEnum mode, FabricServerStatusEnum status, float weight, string user, string passowrd)
{
ServerUuid = serverUuid;
GroupId = groupId;
Host = host;
Port = port;
Mode = mode;
Status = status;
Weight = weight;
ReplicationServerInstance = new ReplicationServer(
serverUuid.ToString(),
mode == FabricServerModeEnum.Read_Write || mode == FabricServerModeEnum.Write_only,
string.Format("server={0};port={1};uid={2};password={3};", host, port, user, passowrd)
);
}
public override ReplicationServer GetServer(bool isMaster)
{
for (int i = 0; i < base.Servers.Count; i++)
{
this.nextServer++;
if (this.nextServer == base.Servers.Count)
{
this.nextServer = 0;
}
ReplicationServer replicationServer = base.Servers[this.nextServer];
if (replicationServer.IsAvailable && (!isMaster || replicationServer.IsMaster))
{
return(replicationServer);
}
}
return(null);
}
/// <summary>
/// Assigns a new server driver to the connection object
/// </summary>
/// <param name="groupName">Group name</param>
/// <param name="master">True if the server connection to assign must be a master</param>
/// <param name="connection">MySqlConnection object where the new driver will be assigned</param>
internal static void GetNewConnection(string groupName, bool master, MySqlConnection connection)
{
do
{
lock (thisLock)
{
if (!IsReplicationGroup(groupName))
{
return;
}
ReplicationServerGroup group = GetGroup(groupName);
ReplicationServer server = group.GetServer(master);
if (server == null)
{
throw new MySqlException(Properties.Resources.Replication_NoAvailableServer);
}
Driver driver = Driver.Create(new MySqlConnectionStringBuilder(server.ConnectionString));
if (connection.driver == null ||
driver.Settings.ConnectionString != connection.driver.Settings.ConnectionString)
{
connection.Close();
connection.hasBeenOpen = false;
try
{
connection.driver = driver;
connection.Open();
return;
}
catch (Exception)
{
connection.driver = null;
server.IsAvailable = false;
// retry to open a failed connection and update its status
group.HandleFailover(server);
}
}
else
{
return;
}
}
} while (true);
}
/// <summary>
/// Handles a failed connection to a server.
/// </summary>
/// <param name="server">The failed server.</param>
/// <remarks>This method can be overrided to implement a custom failover handling.</remarks>
internal protected virtual void HandleFailover(ReplicationServer server)
{
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += delegate(object sender, DoWorkEventArgs e)
{
bool isRunning = false;
ReplicationServer server1 = e.Argument as ReplicationServer;
System.Timers.Timer timer = new System.Timers.Timer(RetryTime * 1000.0);
System.Timers.ElapsedEventHandler elapsedEvent = delegate(object sender1, System.Timers.ElapsedEventArgs e1)
{
if (isRunning)
{
return;
}
try
{
isRunning = true;
using (MySqlConnection connectionFailed = new MySqlConnection(server.ConnectionString))
{
connectionFailed.Open();
server1.IsAvailable = true;
timer.Stop();
}
}
catch
{
MySqlTrace.LogWarning(0,
string.Format(Resources.Replication_ConnectionAttemptFailed, server1.Name));
}
finally
{
isRunning = false;
}
};
timer.Elapsed += elapsedEvent;
timer.Start();
elapsedEvent(sender, null);
};
worker.RunWorkerAsync(server);
}
/// <summary>
/// Gets an available server based on Round Robin load balancing.
/// </summary>
/// <param name="isMaster">Flag indicating if the server to return must be a master.</param>
/// <returns>A <see cref="ReplicationServer"/> object representing the next available server.</returns>
internal protected override ReplicationServer GetServer(bool isMaster)
{
for (int i = 0; i < Servers.Count; i++)
{
nextServer++;
if (nextServer == Servers.Count)
{
nextServer = 0;
}
ReplicationServer s = Servers[nextServer];
if (!s.IsAvailable)
{
continue;
}
if (isMaster && !s.IsMaster)
{
continue;
}
return(s);
}
return(null);
}
internal protected override void HandleFailover(ReplicationServer server, Exception exception)
{
ExecuteCommand("threat report_error", server.Name);
GetServerList();
throw exception;
}
/// <summary>
/// Adds a server into the group
/// </summary>
/// <param name="name">Server name</param>
/// <param name="isMaster">True if the server to add is master, False for slave server</param>
/// <param name="connectionString">Connection string used by this server</param>
/// <returns></returns>
public ReplicationServer AddServer(string name, bool isMaster, string connectionString)
{
ReplicationServer server = new ReplicationServer(name, isMaster, connectionString);
servers.Add(server);
return server;
}
/// <summary>
/// Handles a failed connection to a server.
/// </summary>
/// <param name="server">The failed server.</param>
/// <remarks>This method can be overrided to implement a custom failover handling.</remarks>
internal protected virtual void HandleFailover(ReplicationServer server)
{
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += delegate(object sender, DoWorkEventArgs e)
{
bool isRunning = false;
ReplicationServer server1 = e.Argument as ReplicationServer;
#if !NETSTANDARD1_3
System.Timers.Timer timer = new System.Timers.Timer(RetryTime * 1000.0);
System.Timers.ElapsedEventHandler elapsedEvent = delegate(object sender1, System.Timers.ElapsedEventArgs e1)
{
if (isRunning)
{
return;
}
try
{
isRunning = true;
using (MySqlConnection connectionFailed = new MySqlConnection(server.ConnectionString))
{
connectionFailed.Open();
server1.IsAvailable = true;
timer.Stop();
}
}
catch
{
MySqlTrace.LogWarning(0,
string.Format(Resources.Replication_ConnectionAttemptFailed, server1.Name));
}
finally
{
isRunning = false;
}
};
timer.Elapsed += elapsedEvent;
timer.Start();
elapsedEvent(sender, null);
#else
Windows.UI.Xaml.DispatcherTimer timer = new Windows.UI.Xaml.DispatcherTimer();
TimeSpan ts = new TimeSpan(RetryTime * 1000);
System.EventHandler <object> elapsedEvent = (TickSender, TickEventArgs) =>
{
if (isRunning)
{
return;
}
try
{
isRunning = true;
using (MySqlConnection connectionFailed = new MySqlConnection(server.ConnectionString))
{
connectionFailed.Open();
server1.IsAvailable = true;
timer.Stop();
}
}
catch
{
MySqlTrace.LogWarning(0,
string.Format(Properties.Resources.Replication_ConnectionAttemptFailed, server1.Name));
}
finally
{
isRunning = false;
}
};
timer.Tick += elapsedEvent;
elapsedEvent(sender, null);
timer.Start();
#endif
};
worker.RunWorkerAsync(server);
}
/// <summary>
/// Assigns a new server driver to the connection object
/// </summary>
/// <param name="groupName">Group name</param>
/// <param name="master">True if the server connection to assign must be a master</param>
/// <param name="connection">MySqlConnection object where the new driver will be assigned</param>
public static void GetNewConnection(string groupName, bool master, MySqlConnection connection)
{
do
{
if (!IsReplicationGroup(groupName))
{
return;
}
ReplicationServerGroup group = GetGroup(groupName);
ReplicationServer server = group.GetServer(master);
if (server == null)
{
throw new MySqlException(Properties.Resources.Replication_NoAvailableServer);
}
Driver driver = Driver.Create(new MySqlConnectionStringBuilder(server.ConnectionString));
if (connection.driver == null ||
driver.Settings.ConnectionString != connection.driver.Settings.ConnectionString)
{
connection.Close();
connection.hasBeenOpen = false;
try
{
connection.driver = driver;
connection.Open();
return;
}
catch (Exception)
{
// retry to open a failed connection and update its status
connection.driver = null;
server.IsAvailable = false;
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += delegate(object sender, DoWorkEventArgs e)
{
bool isRunning = false;
ReplicationServer server1 = e.Argument as ReplicationServer;
int retryTime = ReplicationManager.GetGroup(groupName).RetryTime;
#if !RT
System.Timers.Timer timer = new System.Timers.Timer(retryTime * 1000.0);
System.Timers.ElapsedEventHandler elapsedEvent = delegate(object sender1, System.Timers.ElapsedEventArgs e1)
{
if (isRunning)
{
return;
}
try
{
isRunning = true;
using (MySqlConnection connectionFailed = new MySqlConnection(server.ConnectionString))
{
connectionFailed.Open();
server1.IsAvailable = true;
timer.Stop();
}
}
catch
{
MySqlTrace.LogWarning(0,
string.Format(Properties.Resources.Replication_ConnectionAttemptFailed, server1.Name));
}
finally
{
isRunning = false;
}
};
timer.Elapsed += elapsedEvent;
timer.Start();
elapsedEvent(sender, null);
#else
Windows.UI.Xaml.DispatcherTimer timer = new Windows.UI.Xaml.DispatcherTimer();
TimeSpan ts = new TimeSpan(retryTime * 1000);
System.EventHandler <object> elapsedEvent = (TickSender, TickEventArgs) =>
{
if (isRunning)
{
return;
}
try
{
isRunning = true;
using (MySqlConnection connectionFailed = new MySqlConnection(server.ConnectionString))
{
connectionFailed.Open();
server1.IsAvailable = true;
timer.Stop();
}
}
catch
{
MySqlTrace.LogWarning(0,
string.Format(Properties.Resources.Replication_ConnectionAttemptFailed, server1.Name));
}
finally
{
isRunning = false;
}
};
timer.Tick += elapsedEvent;
elapsedEvent(sender, null);
timer.Start();
#endif
};
worker.RunWorkerAsync(server);
}
}
else
{
return;
}
} while (true);
}
/// <summary>
/// Handles a failed connection to a server.
/// </summary>
/// <param name="server">The failed server</param>
/// <param name="exception">Exception that caused the failover</param>
internal protected virtual void HandleFailover(ReplicationServer server, Exception exception)
{
HandleFailover(server);
}
/// <summary>
/// Handles a failed connection to a server.
/// </summary>
/// <param name="server">The failed server</param>
/// <param name="exception">Exception that caused the failover</param>
internal protected virtual void HandleFailover(ReplicationServer server, Exception exception)
{
HandleFailover(server);
}
/// <summary>
/// Assigns a new server driver to the connection object
/// </summary>
/// <param name="groupName">Group name</param>
/// <param name="master">True if the server connection to assign must be a master</param>
/// <param name="connection">MySqlConnection object where the new driver will be assigned</param>
internal static void GetNewConnection(string groupName, bool master, MySqlConnection connection)
{
do
{
lock (thisLock)
{
if (!IsReplicationGroup(groupName))
{
return;
}
ReplicationServerGroup group = GetGroup(groupName);
ReplicationServer server = group.GetServer(master, connection.Settings);
if (server == null)
{
throw new MySqlException(Resources.Replication_NoAvailableServer);
}
//根据主连接字符串配置的账号、密码、数据库、端口，使用新的server的连接字符串（不更新，每次都添加）
string newServerConnectionString = $"{server.ConnectionString}uid={connection.Settings.UserID};pwd={connection.Settings.Password};Database={connection.Settings.Database};port={connection.Settings.Port};";
try
{
bool isNewServer = false;
if (connection.driver == null || !connection.driver.IsOpen)
{
isNewServer = true;
}
else
{
MySqlConnectionStringBuilder msb = new MySqlConnectionStringBuilder(newServerConnectionString);
if (!msb.Equals(connection.driver.Settings))
{
isNewServer = true;
}
}
if (isNewServer)
{
var builder = new MySqlConnectionStringBuilder(newServerConnectionString);
MySqlPool pool = MySqlPoolManager.GetPool(builder);
Driver driver = pool.GetConnection();
//Driver driver = Driver.Create(new MySqlConnectionStringBuilder(newServerConnectionString));
connection.driver = driver;
}
return;
}
catch (MySqlException ex)
{
connection.driver = null;
MySqlTrace.LogError(ex.Number, ex.ToString());
if (ex.Number == 1042)
{
//只有连不上的时候才标记为不可用
server.IsAvailable = false;
//连接失败时打印日志（故障情况）
Console.WriteLine("GetNewConnection Before HandleFailover >> Error:{0},{1}Number={2},ConnectionString={3}", ex.Message, ex.InnerException == null ? "" : "InnerException:" + ex.InnerException.Message + ",", ex.Number, newServerConnectionString);
server.ConnectionString = newServerConnectionString;
// retry to open a failed connection and update its status
group.HandleFailover(server, ex);
}
else
{
throw;
}
}
}
} while (true);
}
public static void GetNewConnection(string groupName, bool master, MySqlConnection connection)
{
while (true)
{
if (!ReplicationManager.IsReplicationGroup(groupName))
{
break;
}
ReplicationServerGroup group = ReplicationManager.GetGroup(groupName);
ReplicationServer server = group.GetServer(master);
if (server == null)
{
goto Block_2;
}
Driver driver = Driver.Create(new MySqlConnectionStringBuilder(server.ConnectionString));
if (connection.driver == null || driver.Settings.ConnectionString != connection.driver.Settings.ConnectionString)
{
connection.Close();
connection.hasBeenOpen = false;
try
{
connection.driver = driver;
connection.Open();
}
catch (Exception)
{
connection.driver = null;
server.IsAvailable = false;
BackgroundWorker backgroundWorker = new BackgroundWorker();
backgroundWorker.DoWork += delegate(object sender, DoWorkEventArgs e)
{
bool isRunning = false;
ReplicationServer server1 = e.Argument as ReplicationServer;
int retryTime = ReplicationManager.GetGroup(groupName).RetryTime;
Timer timer = new Timer((double)retryTime * 1000.0);
ElapsedEventHandler elapsedEventHandler = delegate(object sender1, ElapsedEventArgs e1)
{
if (isRunning)
{
return;
}
try
{
isRunning = true;
using (MySqlConnection mySqlConnection = new MySqlConnection(server.ConnectionString))
{
mySqlConnection.Open();
server1.IsAvailable = true;
timer.Stop();
}
}
catch
{
MySqlTrace.LogWarning(0, string.Format(Resources.Replication_ConnectionAttemptFailed, server1.Name));
}
finally
{
isRunning = false;
}
};
timer.Elapsed += elapsedEventHandler;
timer.Start();
elapsedEventHandler(sender, null);
};
backgroundWorker.RunWorkerAsync(server);
continue;
}
return;
}
return;
}
return;
Block_2:
throw new MySqlException(Resources.Replication_NoAvailableServer);
}
/// <summary>
/// Handles a failed connection to a server.
/// This method can be overrided to implement a custom failover handling
/// </summary>
/// <param name="server">The failed server</param>
public virtual void HandleFailover(ReplicationServer server)
{
BackgroundWorker worker = new BackgroundWorker();
worker.DoWork += delegate(object sender, DoWorkEventArgs e)
{
bool isRunning = false;
ReplicationServer server1 = e.Argument as ReplicationServer;
#if !RT
System.Timers.Timer timer = new System.Timers.Timer(RetryTime * 1000.0);
System.Timers.ElapsedEventHandler elapsedEvent = delegate(object sender1, System.Timers.ElapsedEventArgs e1)
{
if (isRunning) return;
try
{
isRunning = true;
using (MySqlConnection connectionFailed = new MySqlConnection(server.ConnectionString))
{
connectionFailed.Open();
server1.IsAvailable = true;
timer.Stop();
}
}
catch
{
MySqlTrace.LogWarning(0,
string.Format(Properties.Resources.Replication_ConnectionAttemptFailed, server1.Name));
}
finally
{
isRunning = false;
}
};
timer.Elapsed += elapsedEvent;
timer.Start();
elapsedEvent(sender, null);
#else
Windows.UI.Xaml.DispatcherTimer timer = new Windows.UI.Xaml.DispatcherTimer();
TimeSpan ts = new TimeSpan(RetryTime * 1000);
System.EventHandler<object> elapsedEvent = (TickSender, TickEventArgs) =>
{
if (isRunning) return;
try
{
isRunning = true;
using (MySqlConnection connectionFailed = new MySqlConnection(server.ConnectionString))
{
connectionFailed.Open();
server1.IsAvailable = true;
timer.Stop();
}
}
catch
{
MySqlTrace.LogWarning(0,
string.Format(Properties.Resources.Replication_ConnectionAttemptFailed, server1.Name));
}
finally
{
isRunning = false;
}
};
timer.Tick += elapsedEvent;
elapsedEvent(sender, null);
timer.Start();
#endif
};
worker.RunWorkerAsync(server);
}
