NAME

MojoX::Mysql::DB - Connect DB

SYNOPSIS

    use MojoX::Mysql;
    use Mojo::Util qw(dumper);

    my %config = (
        user=>'root',
        password=>undef,
        server=>[
            {dsn=>'database=test;host=localhost;port=3306;mysql_connect_timeout=5;', type=>'master'},
            {dsn=>'database=test;host=localhost;port=3306;mysql_connect_timeout=5;', type=>'slave'},
            {dsn=>'database=test;host=localhost;port=3306;mysql_connect_timeout=5;', id=>1, type=>'master'},
            {dsn=>'database=test;host=localhost;port=3306;mysql_connect_timeout=5;', id=>1, type=>'slave'},
            {dsn=>'database=test;host=localhost;port=3306;mysql_connect_timeout=5;', id=>2, type=>'master'},
            {dsn=>'database=test;host=localhost;port=3306;mysql_connect_timeout=5;', id=>2, type=>'slave'},
        ]
    );

    my $mysql = MojoX::Mysql->new(%config);
    my $dbh = $mysql->db->connect_master;

ATTRIBUTES

id

    $mysql->id(1); # choice id server

METHODS

connect_master

    $mysql->db->connect_master;

Return connect object.

connect_slave

    $mysql->db->connect_slave;

Return connect object.

commit

    $mysql->db->commit;

Commit on all servers

rollback

    $mysql->db->rollback;

Rollback on all servers

disconnect

    $mysql->db->disconnect;

Disconnect on all servers