/// <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);
}
/// <summary>
/// Gets an available server based on Round Robin load balancing
/// </summary>
/// <param name="isMaster">True if the server to return must be a master</param>
/// <returns>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);
}
/// <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>
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 !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);
}
/// <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>
internal protected 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>
/// <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>
/// 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>
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 !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);
}
