/// <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(Properties.Resources.Replication_NoAvailableServer); } try { bool isNewServer = false; if (connection.driver == null || !connection.driver.IsOpen) { isNewServer = true; } else { MySqlConnectionStringBuilder msb = new MySqlConnectionStringBuilder(server.ConnectionString); if (!msb.Equals(connection.driver.Settings)) { isNewServer = true; } } if (isNewServer) { Driver driver = Driver.Create(new MySqlConnectionStringBuilder(server.ConnectionString)); connection.driver = driver; } return; } catch (MySqlException ex) { connection.driver = null; server.IsAvailable = false; MySqlTrace.LogError(ex.Number, ex.ToString()); if (ex.Number == 1042) { // retry to open a failed connection and update its status group.HandleFailover(server, ex); } else { throw; } } } } while (true); }
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; } }
/// <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> /// Gets the next server from a replication group /// </summary> /// <param name="groupName">Group name</param> /// <param name="isMaster">True if the server to return must be a master</param> /// <returns>Replication Server defined by the Load Balancing plugin</returns> internal static ReplicationServer GetServer(string groupName, bool isMaster) { ReplicationServerGroup group = GetGroup(groupName); return(group.GetServer(isMaster)); }
/// <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); }
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); }
public static ReplicationServer GetServer(string groupName, bool isMaster) { ReplicationServerGroup group = ReplicationManager.GetGroup(groupName); return(group.GetServer(isMaster)); }
/// <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); }