 | |
how to distribute database from servers to remote another servers.
comp.databases.mysql comp.databases.mysql
 |
| | Thread Tools | Display Modes |
#1
 
| |||||||
| |||||||
|
how to distribute database from servers to remote another servers. -
01-17-2012
, 07:22 AM
|
pk | field_1 | 0 | a | 2 | b | 4 | c | 6 | d | |
Quote:
|
pk | field_1 | 1 | a | 3 | e | 5 | f | 7 | c | |
now , I want to expand the current server'count from 2 to 5.
so, I need to distribute my data in tables;
new_server_0
Quote:
|
pk | field_1 | 0 | a | 5 | f | |
new_server_1
Quote:
|
pk | field_1 | 1 | a | 6 | d | |
Quote:
|
pk | field_1 | 2 | b | 7 | c | |
Quote:
|
pk | field_1 | 3 | e | |
Quote:
|
pk | field_1 | 4 | c | |
thanks.
#2
| |||
| |||
|
|
hello, everyone! I need your helps to distribute my current database to another remote servers. let me figure out the situation I have. I have 2 servers now a server_0 has a following table. | pk | field_1 | | 0 *| a | | 2 *| b | | 4 *| c *| | 6 *| d | a server_1 *has a following table. | pk | field_1 | | 1 *| a | | 3 *| e | | 5 *| f *| | 7 *| c | now , I want to expand the current server'count from 2 to 5. so, I need to distribute my data in tables; new_server_0 | pk | field_1 | | 0 *| a | | 5 *| f | new_server_1 | pk | field_1 | | 1 *| a | | 6 *| d | new_server_2 | pk | field_1 | | 2 *| b | | 7 *| c | new_server_3 | pk | field_1 | | 3 *| e | new_server_4 | pk | field_1 | | 4 *| c *| how can I do this job easily? thanks. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.