FUDforum: Database discussions » slave database mysql

Home » General » Database discussions » slave database mysql

Show: Today's Messages :: Polls :: Message Navigator

slave database mysql [message #186548]

Sat, 27 September 2014 17:39

demaglio

Messages: 7
Registered: August 2014

Karma: 0

Junior Member

Hi,
I have install fudforum.
I have two mysql database on two machine. One as master and one as slave.
In fudforum administration I insert Database Server and Database Slave Server.
with mysql -u user -p I see that on the machine with Master I connect with mysql on slave server. Slave is update by master.
If I stopped mysql on master Server forum go down. I'm in error or if master is down fudforum connect to slave mysql?
In apache log I have only an error that fudforum cannot connect the master(is down).

Report message to a moderator

Re: slave database mysql [message #186551 is a reply to message #186548]

Sat, 27 September 2014 18:25

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

The current implementation is for offloading queries to the slave database, not for fail-over.
That said, it should be very easy to change in the DB driver.

Report message to a moderator

Re: slave database mysql [message #186552 is a reply to message #186551]

Sat, 27 September 2014 18:35

demaglio

Messages: 7
Registered: August 2014

Karma: 0

Junior Member

ok, but in this case I must have not master slave mysql install, but master master. It's correct?

Report message to a moderator

Re: slave database mysql [message #186553 is a reply to message #186552]

Sat, 27 September 2014 19:21

demaglio

Messages: 7
Registered: August 2014

Karma: 0

Junior Member

Hi, sorry for my other post.
In index .php I have:
db::$db = new mysqli($GLOBALS['DBHOST'], $GLOBALS['DBHOST_USER'], $GLOBALS['DBHOST_PASSWORD'], $GLOBALS['DBHOST_DBNAME'], NULL, $socket);
if (mysqli_connect_errno()) {
fud_sql_error_handler('Failed to establish database connection', 'MySQLi says: '. mysqli_connect_error(), mysqli_connect_errno(), '');
}
db::$db->set_charset('utf8');

/* Connect to slave, if specified. */
if (!empty($GLOBALS['DBHOST_SLAVE_HOST']) && !$GLOBALS['is_post']) {
db::$slave = new mysqli($GLOBALS['DBHOST'], $GLOBALS['DBHOST_USER'], $GLOBALS['DBHOST_PASSWORD'], $GLOBALS['DBHOST_DBNAME'], NULL, $socket);
if (mysqli_connect_errno()) {
fud_logerror('Unable to init SlaveDB, fallback to MasterDB: '. mysqli_connect_error(), 'sql_errors');
} else {
db::$db->set_charset('utf8');
}
}
but I thinks that is:
db::$slave = new mysqli($GLOBALS['DBHOST_SLAVE_HOST''], $GLOBALS['DBHOST_USER'], $GLOBALS['DBHOST_PASSWORD'], $GLOBALS['DBHOST_DBNAME'], NULL, $socket);

for my problem I have:
db::$db = new mysqli($GLOBALS['DBHOST'], $GLOBALS['DBHOST_USER'], $GLOBALS['DBHOST_PASSWORD'], $GLOBALS['DBHOST_DBNAME'], NULL, $socket);
if (mysqli_connect_errno()) {
if (!empty($GLOBALS['DBHOST_SLAVE_HOST']) && !$GLOBALS['is_post']) {
db::$db = new mysqli($GLOBALS['DBHOST_SLAVE_HOST'], $GLOBALS['DBHOST_USER'], $GLOBALS['DBHOST_PASSWORD'], $GLOBALS['DBHOST_DBNAME'], NULL, $socket);
if (mysqli_connect_errno()) {
fud_logerror('Unable to init SlaveDB, fallback to MasterDB: '. mysqli_connect_error(), 'sql_errors');
} else {
db::$db->set_charset('utf8');
}
}

}
//db::$db->set_charset('utf8');

/* Connect to slave, if specified. */
if (!empty($GLOBALS['DBHOST_SLAVE_HOST']) && !$GLOBALS['is_post']) {
db::$slave = new mysqli($GLOBALS['DBHOST_SLAVE_HOST'], $GLOBALS['DBHOST_USER'], $GLOBALS['DBHOST_PASSWORD'], $GLOBALS['DBHOST_DBNAME'], NULL, $socket);
if (mysqli_connect_errno()) {
db:$$slave=null;
} else {
db::$db->set_charset('utf8');
}
}

[Updated on: Sun, 28 September 2014 21:03]

Report message to a moderator

Previous Topic:	Holes in MYSQL Databases?
Next Topic:	database dump and phpmyadmin..

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 23:48:58 GMT 2024

Total time taken to generate the page: 0.02356 seconds