// Copyright (c) 2014, 2020, Oracle and/or its affiliates. // // This program is free software; you can redistribute it and/or modify // it under the terms of the GNU General Public License, version 2.0, as // published by the Free Software Foundation. // // This program is also distributed with certain software (including // but not limited to OpenSSL) that is licensed under separate terms, // as designated in a particular file or component or in included license // documentation. The authors of MySQL hereby grant you an // additional permission to link the program and your derivative works // with the separately licensed software that they have included with // MySQL. // // Without limiting anything contained in the foregoing, this file, // which is part of MySQL Connector/NET, is also subject to the // Universal FOSS Exception, version 1.0, a copy of which can be found at // http://oss.oracle.com/licenses/universal-foss-exception. // // This program is distributed in the hope that it will be useful, but // WITHOUT ANY WARRANTY; without even the implied warranty of // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. // See the GNU General Public License, version 2.0, for more details. // // You should have received a copy of the GNU General Public License // along with this program; if not, write to the Free Software Foundation, Inc., // 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA using System; using System.Collections.Generic; using System.ComponentModel; using System.Text; using Sog.Properties; namespace MySql.Data.MySqlClient.Replication { /// /// Base class used to implement load balancing features. /// public abstract class ReplicationServerGroup { /// /// List of servers available for replication. /// protected List servers = new List(); /// The group name. /// The number of seconds to perform a retry. public ReplicationServerGroup(string name, int retryTime) { this.Servers = this.servers; this.Name = name; this.RetryTime = retryTime; } /// /// Gets the group name. /// public string Name { get; protected set; } /// /// Gets the retry time between connections to failed servers. /// public int RetryTime { get; protected set; } /// /// Gets the server list in the group. /// protected IList Servers { get; private set; } /// /// Adds a server into the group. /// /// The server name. /// A flag indicating if the server to add is source or replica. /// The connection string used by this server. /// A object representing the recently added object. internal protected ReplicationServer AddServer(string name, bool isSource, string connectionString) { ReplicationServer server = new ReplicationServer(name, isSource, connectionString); this.servers.Add(server); return server; } /// /// Removes a server from the group. /// /// The server name. internal protected void RemoveServer(string name) { ReplicationServer serverToRemove = this.GetServer(name); if (serverToRemove == null) { throw new MySqlException(String.Format(Resources.ReplicationServerNotFound, name)); } this.servers.Remove(serverToRemove); } /// /// Gets a server by name. /// /// The server name. /// The replication server. internal protected ReplicationServer GetServer(string name) { foreach (var server in this.servers) { if (String.Compare(name, server.Name, StringComparison.OrdinalIgnoreCase) == 0) { return server; } } return null; } /// /// Must be implemented. Defines the next server for a custom load balancing implementation. /// /// Defines if the server to return is a source or any. /// The next server based on the load balancing implementation. /// Null if no available server is found. /// internal protected abstract ReplicationServer GetServer(bool isSource); /// /// Defines the next server for a custom load balancing implementation. /// /// Defines if the server to return is a source or any. /// Currently not being used. /// The next server based on the load balancing implementation. /// Null if no available server is found. /// internal protected virtual ReplicationServer GetServer(bool isSource, MySqlConnectionStringBuilder settings) { return this.GetServer(isSource); } /// /// Handles a failed connection to a server. /// /// The failed server. /// This method can be overrided to implement a custom failover handling. 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(this.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); } /// /// Handles a failed connection to a server. /// /// The failed server. /// The exception that caused the failover. internal protected virtual void HandleFailover(ReplicationServer server, Exception exception) { this.HandleFailover(server); } } }