Example #1
0
        /// <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">MyCatConnection object where the new driver will be assigned</param>
        internal static void GetNewConnection(string groupName, bool master, MyCatConnection connection)
        {
            do
            {
                lock (thisLock)
                {
                    if (!IsReplicationGroup(groupName))
                    {
                        return;
                    }

                    ReplicationServerGroup group  = GetGroup(groupName);
                    ReplicationServer      server = group.GetServer(master, connection.Settings);

                    if (server == null)
                    {
                        throw new MyCatException(Properties.Resources.Replication_NoAvailableServer);
                    }

                    try
                    {
                        bool isNewServer = false;
                        if (connection.driver == null || !connection.driver.IsOpen)
                        {
                            isNewServer = true;
                        }
                        else
                        {
                            MyCatConnectionStringBuilder msb = new MyCatConnectionStringBuilder(server.ConnectionString);
                            if (!msb.Equals(connection.driver.Settings))
                            {
                                isNewServer = true;
                            }
                        }
                        if (isNewServer)
                        {
                            Driver driver = Driver.Create(new MyCatConnectionStringBuilder(server.ConnectionString));
                            connection.driver = driver;
                        }
                        return;
                    }
                    catch (MyCatException ex)
                    {
                        connection.driver  = null;
                        server.IsAvailable = false;
                        MyCatTrace.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);
        }