Posted by Steve on 11/12/07 18:23

"2401 members, members can post" <Paul_Merck@2cuk.co.uk> wrote in message
news:1194891543.557676.36020@v2g2000hsf.googlegroups.com...
> 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.

create views for the external data sources within the db. that's the most
pragmatic.

[Back to original message]