Hi,
I know we can connect to 2 separate Mysql database's using Perl and the DBI
module but can we connect to 2 different machines? One will be what we are
using on our server and one our clients wants to be able to have on their
servers.
The reason I ask is that we are starting to license our web tools and our
clients want their own database records which they are intitled to. Each
company that we license to may have a different database and we may have to
customize each program based on that database but I want to be able to make
this as easy as possible.
The database will be used for our website on the backend for members
personal information. If users change personal info should we write to both
databases? The database also needs to be able to update pages from sql calls
for several items on these pages.
I can imagine that it will get really slow if we have to do everything 2
times. So is there a better way? Something where we write and query to our
database so the website will be at it's peak and then just update their
database once or twice a day so they have the updated info. Are there
problems with synchronizing things this way? If they delete items how will
we know that this has happened.
Or should we forget using our database and just connect to theirs for
everything. Thus eliminating any problems with synchronization. Or just use
ours and let them connect to this database when they need anything.
Basically it is our software their information but we need it to be able to
make the website work correctly.
I need some help.
Joe
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
