in reply to DBI load balancing / high availability: DBIx::HA vs DBD::Multi vs DBD::Multiplex

Your question assumes a great deal about AWS RDS that is not true. RDS handles failure of the database to a remote copy. I doubt if it handles "connection failover." And RDS does not support "replicas of the database." You cannot setup a replication slave with RDS. RDS is intended for simple usage, not complex architectures.
  • Comment on Re: DBI load balancing / high availability: DBIx::HA vs DBD::Multi vs DBD::Multiplex

Replies are listed 'Best First'.
Re^2: DBI load balancing / high availability: DBIx::HA vs DBD::Multi vs DBD::Multiplex
by Anonymous Monk on Aug 22, 2012 at 19:55 UTC
    Actually, Read Replica(s) are now available. You would have to see what the lag is.
Re^2: DBI load balancing / high availability: DBIx::HA vs DBD::Multi vs DBD::Multiplex
by andye (Curate) on Aug 23, 2012 at 12:43 UTC
    Was referring to these features:
    Multi-AZ Deployments – A deployment option for your production DB Instances that enhances database availability while protecting your latest database updates against unplanned outages. When you create or modify your DB Instance to run as a Multi-AZ deployment, Amazon RDS will automatically provision and manage a “standby” replica in a different Availability Zone (independent infrastructure in a physically separate location). Database updates are made concurrently on the primary and standby resources to prevent replication lag. In the event of planned database maintenance, DB Instance failure, or an Availability Zone failure, Amazon RDS will automatically failover to the up-to-date standby so that database operations can resume quickly without administrative intervention. Prior to failover you cannot directly access the standby, and it cannot be used to serve read traffic.

    Read Replicas – This replication feature makes it easy to elastically scale out beyond the capacity constraints of a single DB Instance for read-heavy database workloads. You can create one or more replicas of a given source DB Instance and serve high-volume application read traffic from multiple copies of your data, thereby increasing aggregate read throughput. Amazon RDS uses MySQL’s native replication to propagate changes made to a source DB Instance to any associated Read Replicas. Since Read Replicas leverage standard MySQL replication, they may fall behind their sources, and they are therefore not intended to be used for enhancing fault tolerance in the event of source DB Instance failure or Availability Zone failure.

    http://aws.amazon.com/rds/mysql/#Multi-AZ

    Not meaning to imply that AWS is the be-all and end-all of this kind of thing - clearly it isn't.

    To get back on track: Does anyone have views / experiences / reviews of the above modules?