NAME

Loop::Sustainable::Strategy::MySQL::BalancedReplication - Calculates wait interval by MySQL slave server delaying.

SYNOPSIS

            

              
              
use Loop::Sustainable;
my $dbh_slave = DBI->connect(...);
loop_sustainable {
    ### master heavy process
} (
    sub {
       ### termination condition
    },
    {
       strategy => {
           class => 'MySQL::BalancedReplication',
           args  => {
                dbh                    => $dbh_slave,
                capable_behind_seconds => 2,
                on_error_scale_factor  => 30,
                on_error_croak         => 0,
           },
       }
    }
);
            
          

DESCRIPTION

METHODS

new( %args )

dbh

DBI::db object. The $dbh must be connected to MySQL slave server with previledge 'SHOW SLAVE STATUS' command.

capable_behind_seconds

Permits seconds of replication delaying. This module treats delaying times as this value from read delay times via Seconds_Behind_Master value.

Default value is 5 seconds.

on_error_scale_factor

When a error is occuring in fetching slave status, This module treats delay times as multiply temporary delay times by this value.

Default value is 5.

on_error_croak

When a error is occuring in fetching slave status and this value is true value, This module will raise error. Default value is false.

wait_correction( $query, $time_sum, $executed_count )

AUTHOR

Toru Yamaguchi <zigorou@dena.jp<gt>

LICENSE

This module is licensed under the same terms as Perl itself.

SEE ALSO

Loop::Sustainable