/// <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> /// 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); }