欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  php教程

关于mybb主从数据配置

程序员文章站 2022-05-14 14:43:08
...
今天微博上有朋友问到我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>";
                }
            }
        }