PHP multi-database supported application design page 1/2_PHP tutorial

So I think that in the master-slave database design, all session-related tables should be treated specially. That is: all session data tables can be updated and queried. When a user accesses the site, the user is bound to the specified database, and all session access and query operations are performed on this database. The session table is not synchronized, and other non-session updates are also updated from the main database. In fact, this cannot escape the database switching when the session is updated, so if you don't want to bother, it is better to store the session in text.
The split-database design may improve the performance by several levels. Of course, the efficiency of a single execution will not be higher than that of a single database. After all, there is an efficiency problem in database switching. The combination of sub-databases and master-slave databases is a better solution to improve database concurrency bottlenecks. Principle: Large data volume, separate databases; large access volume, master-slave. Many times, the two work in parallel (this article does not discuss cache).
I think that if you want to implement sub-databases and master-slave relationships, the number of database servers will be very considerable. Switching to a certain server at any time in the application will be a very headache. Configuration changes, variable names, Will there be a lot of them? How to find better solutions will be the topic of this article.
First of all, there is the problem of many databases due to sub-databases. Under what circumstances will the database be branched? Maybe some people still don't understand why we need to divide the database, so I will briefly talk about my experience and speculation. For example, a blog program is generally designed to store logs in a log table. Assuming it is a multi-user blog, then a uid will be associated. If the amount of data is not large, there is no problem with this design, but when the amount of logs is huge, hundreds of thousands of log records are entered a day, and the number of visits is also relatively large. When it is considerable, I think it is impossible for every user to access the log list and find a few entries from the data table containing tens of millions of log records. The efficiency is evident. At this time, you should consider the issue of sub-library. How to divide? There is a very simple table partitioning method, that is, recording logs in each database according to the uid segment. Of course, this distribution still needs to be adjusted based on past statistical results, because the user log distribution is definitely not uniform. Set the uid segment, then index to the specified database configuration based on the uid, and create a database object. The configuration information may be as follows:

Copy code The code is as follows:

$configs['db_info']['blog'][ 0] = array(
'db_host' => '192.168.0.1',
'db_name' => 'blog',
'db_user' => 'root',
' db_pass' => '',
);
$configs['db_info']['blog'][1] = array(
'db_host' => '192.168.0.2',
'db_name' => 'blog',
'db_user' => 'root',
'db_pass' => '',
);
$configs['db_info ']['blog'][2] = array(
'db_host' => '192.168.0.2',
'db_name' => 'blog',
'db_user' => 'root',
'db_pass' => '',
);
//...There are many more

As for which server to choose, just need Just do a simple match based on uid.
Let’s talk about the master-slave database. When to use master-slave database? For example, a celebrity blog has a large number of visits and there is no way to split its data. At this time, you have to consider the master-slave database server and use multiple databases to divert the traffic. To apply this to master-slave and sub-databases, the above configuration information may need to be slightly modified.

Copy code The code is as follows:

$configs['db_info']['blog'][0]['master'] = array(
    'db_host' => '192.168.0.1',
    'db_name' => 'blog',
    'db_user' => 'root',
    'db_pass' => '',
);
$configs['db_info']['blog'][0]['slave'][0] = array(
    'db_host' => '192.168.0.2',
    'db_name' => 'blog',
    'db_user' => 'root',
    'db_pass' => '',
);
$configs['db_info']['blog'][0]['slave'][1] = array(
    'db_host' => '192.168.0.3',
    'db_name' => 'blog',
    'db_user' => 'root',
    'db_pass' => '',
);
$configs['db_info']['blog'][1]['master'] = array(
    'db_host' => '192.168.0.4',
    'db_name' => 'blog',
    'db_user' => 'root',
    'db_pass' => '',
);
$configs['db_info']['blog'][1]['slave'][0] = array(
    'db_host' => '192.168.0.5',
    'db_name' => 'blog',
    'db_user' => 'root',
    'db_pass' => '',
);
$configs['db_info']['blog'][1]['slave'][1] = array(
    'db_host' => '192.168.0.6',
    'db_name' => 'blog',
    'db_user' => 'root',
    'db_pass' => '',
);
$configs['db_info']['session'][0]['master'] = array(
    'db_host' => '192.168.0.7',
    'db_name' => 'session',
    'db_user' => 'root',
    'db_pass' => '',
);
$configs['db_info']['session'][1]['master'] = array(
    'db_host' => '192.168.0.8',
    'db_name' => 'session',
    'db_user' => 'root',
    'db_pass' => '',
);

　　写到这里，我想都应该知道如何分表和分配你的数据库了吧，接下去我就来说一下如何轻松的读取这样的配置信息，如何将这些配置融入你的数据库驱动中。

http://www.bkjia.com/PHPjc/319320.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/319320.htmlTechArticle所以我想在主从数据库设计上，应该将所有会话相关表进行特殊对待。即：所有的会话数据表都可以更新和查询，当一个用户访问站点的时...