Posted by 2401 members, members can post on 11/12/07 18:19

Dear Madams and Sirs,

Ever had to split a website + SQL Tables ?

Have a UNIX pc-linux-gnu on i686 + FEDORA

1) We have to split a sub-domain for the main domain name.
2) We have to build a transfer and merge from Tables hosted on Server
1 TO Tables hosted on Server 2.

1) We do not know if www.bobby.com can be host on SERVER 2 and
xoaks.bobby.com can be host on SERVER 1.

We do not manage subdomains. We are affraid to not to be in a position
to get xoaks.bobby.com working normally on SERVER 1.

2) Some data will be stored in Tables on SERVER 1 from
xoaks.bobby.com.

These MYSQL data stored in tables on SERVER.1 must be integrated in
the SERVER.2 database.

SOLUTION 1 : A non-appreciated solution is an event from the contab
that download tables in SERVER1, send tables onto SERVER2, and SERVER2
merge the tables into its operating Database. SERVER2 aknowledge
SERVER1 to delete fine-integrated data.

[Flying Tables] So risky sheme !

OTHER Solution : How SERVER MYSQL Berkeley DB 3.2.9a on SERVER.1 could
directly communicate to the MYSQL database hosted on SERVER.2.

Many thanks from your knowledge and experience in Multiserver DB.

Bob

[Back to original message]