> By the way, I've been playing with the idea of failing gracefully and retry > indefinitely (or until given -T) on SQL error AND connection issue. > > It would be useful to test replicating clusters with a (switch|fail)over > procedure.
Interesting idea but in general a failover takes sometime (like a few minutes), and it will strongly affect TPS. I think in the end it just compares the failover time. Or are you suggesting to ignore the time spent in failover? Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp