关于mybb主从数据配置
程序员文章站
2022-04-24 19:22:14
...
今天微博上有朋友问到我Mybb如何配置主从其实我对mybb不是很熟悉,就大致看了一下DB发现是可以配置主从的在inc/config.php中配置如下$con fig['database']['read']['hostname'] = 'localhost';$config['database']['read']['username'] = 'root';$config['database']['read']['password'] = '';$config['database']['write']['hostname'] = 'localhost';$config['database']['write']['username'] = 'root';$config['database']['write']['password'] = '';//read为从 write为主 多个的时候['r ead'][0]['hostname']这样以数据配置即可但是在db_mysql.php中我却发现在处理主从的时候。有一个不和谐的代码。目前我也没有想明白目 的175行if(array_key_exists('hostname', $connections[$type])) { $details = $connections[$type]; unset($connections);//这里unset了 就肯定只能够连接到read的第一个数据库上 $connections[$type][] = $details;}我没有搞明白目的所以没有进行修改。如果要实现要实现只需要重新处理一下$connections数组就可以解决我这里就不累述。
处理主从的代码
foreach(array('read', 'write') as $type) { print_r($connections);if(!is_array($connections[$type])) { break; } if(array_key_exists('hostname', $connections[$type])) { $details = $connections[$type]; unset($connections); $connections[$type][] = $details; } // Shuffle the connections shuffle($connections[$type]); // Loop-de-loop foreach($connections[$type] as $single_connection) { $connect_function = "mysql_connect"; if($single_connection['pconnect']) { $connect_function = "mysql_pconnect"; } $link = $type."_link"; $this->get_execution_time(); $this->$link = @$connect_function($single_connection['hostname'], $single_connection['username'], $single_connection['password'], 1); $time_spent = $this->get_execution_time(); $this->query_time += $time_spent; // Successful connection? break down brother! if($this->$link) { $this->connections[] = "[".strtoupper($type)."] {$single_connection['username']}@{$single_connection['hostname']} (Connected in ".number_format($time_spent, 0)."s)"; break; } else { $this->connections[] = "<span style="color: red">[FAILED] [".strtoupper($type)."] {$single_connection['username']}@{$single_connection['hostname']}</span>"; } } }
上一篇: CSS 实现图片灰度效果 兼容各种浏览器
下一篇: 对盗链说再见..._php基础
推荐阅读
-
Mysql主从数据库(Master/Slave)同步配置与常见错误
-
CentOS7下Mysql5.7主从数据库配置
-
MYSQL5.6.33数据库主从(Master/Slave)同步安装与配置详解(Master-Linux Slave-windows7)
-
windows下mysql数据库主从配置教程
-
php框架CodeIgniter主从数据库配置方法分析
-
Gentos 6.8 配置mysql数据库主从同步
-
mysql服务器主从数据库同步配置
-
MySQL数据库的主从同步配置与读写分离
-
Centos 7.2 MariaDB 数据库主从配置
-
关于数据访问模式(六)—— 资源管理模式的重要性 设计模式配置管理OOSocketDOS