How Can I use two server_ip for mysql connection in c#.net

See more:

C#

Hi All,

I am working on .Net Project in which my requirement is to connect with two same database(on different server) . If one fail then automatically switch to second. Please tell me how can I solve this.
Thanks in Advance.

public MySqlConnection DBConnect()
      {
          try
          {
              Boolean checkConnection = false;
              string connString1 = string.Format(
                      "Server={0};Database={1};Uid=" + Properties.Settings.Default.DBUser +
                      ";Pwd=" + Properties.Settings.Default.DBPass + ";CharSet=utf8;", Properties.Settings.Default.DBServer, Properties.Settings.Default.DBName);
              string connString2 = string.Format(
                     "Server={0};Database={1};Uid=" + Properties.Settings.Default.DBUser +
                     ";Pwd=" + Properties.Settings.Default.DBPass + ";CharSet=utf8;", Properties.Settings.Default.DBServer1, Properties.Settings.Default.DBName);
              var Connection = new MySql.Data.MySqlClient.MySqlConnection();

                  Connection.ConnectionString = connString1;

                  checkConnection = true;
                  Connection.Open();


             if (!checkConnection)
              {
                  Connection.ConnectionString = connString2;
                  Connection.Open();

              }




              statusStripMain.BeginInvoke((MethodInvoker)delegate
                                                              {
                                                                  toolStripStatusLabelDBConnectionStatus.Text =
                                                                      "DB Connected!";
                                                                  toolStripStatusLabelDBConnectionStatus.ForeColor =
                                                                      Color.Green;
                                                              });

              return Connection;
          }
          catch (Exception exp)
          {
              LogOperation(exp.Message);

              statusStripMain.BeginInvoke((MethodInvoker)delegate
                                                              {
                                                                  toolStripStatusLabelDBConnectionStatus.Text =
                                                                      "DB Disconnected!";
                                                                  toolStripStatusLabelDBConnectionStatus.ForeColor =
                                                                      Color.Red;
                                                              });

              return null;
          }
      }