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