|
|
Posted by Jerry Stuckle on 11/12/07 22:22
2401 members, members can post wrote:
> 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
>
>
Bob,
Try comp.databases.mysql. You'll get good information on how to do it
there.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|