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