We can create temporary memory table for holding the result set of one select and join another table in other server with this temporary table. You may even join multiple tables in a single query. When we partition c_fs databases to different clusters, we need join of two tables which reside in different server. Now I can just drag the MySQL reviews table into the canvas to join: We color-code each connection so you can distinguish the tables in the join and the. Laravels database query builder provides a convenient, fluent interface to creating and running. If these two table reside in same server, the query for obtaining mutual friends between user A and B is as follows.Ĭ_fs2.c_contact_082 as c1 INNER JOIN c_fs12.c_contact_072 as c2 ON c1.u_mno = c2.u_mno WHERE c1.i_mno=1282 AND c2.i_mno=1372 If owner user A's mno is 1282 and visitor user B's mno is 1372, user A's friends table is c_contact_082 and user B's friend table is c_contact_072. The data of friends tables are distributed in the related db of multiple mysql clusters. The JOIN clause allows you to combine rows. The name of my friends table is c_contact_XXX. To add another table to an existing query in a MySQL database, you can use the JOIN clause in the SELECT statement. We need some function to display mutual friends of two users (one is the owener of personal space, the other is visitor).
Hashing function is simple : mno (user's unique identifier) % total partition number. The number of total partitions(dbs) is 16. We are preparing multiple mysql cluster(one master, several slaves) per each data partition which keeps only data of related tables by hashing user's unique key. MySQL partitioning does not support distributed partitioning. The partitioning which I mean is not MySQL partitioning. I am upgrading the DB structure including schema, server architecture by using application partitioning. Hi~ This topic may be not proper for this forum.
0 kommentar(er)
