4 sites on 4 different hosting, on 1 database

**darksoul** · 10-24-2005, 09:10 AM

Its doable.
Just have on each server a script that syncs with the master.

**Bronze** · 10-24-2005, 09:11 AM

This would be doing it from the paysites end or the processor End?

**darksoul** · 10-24-2005, 09:12 AM

paysites end.

**RobbieRye** · 10-24-2005, 09:15 AM

On one of the servers load all user data into a MySQL database. Allow access to that database from a specific user when requested from the IP of one of the other servers.

Or, if you want to get fancy, you could setup an LDAP directory.

**Bronze** · 10-24-2005, 09:22 AM

I know of a way someone told, that it's possible to use with .htaccess transferring every minute or so, but there's still some time gap and i'm not sure just transferring and replace .htaccess is the optimal solution. Instant synchronization is more what i'm looking for. Do you know of a program that would do this? or know an info somewhere I can look up?

**Bronze** · 10-24-2005, 09:27 AM

Thx but that's what CCbill told me when I call them. It's possible probably to authenticate a MySql database across server, but their script can't write example a new user across server. They don't seem to able to possible do this across server it seem.

Originally posted by RobbieRye

On one of the servers load all user data into a MySQL database. Allow access to that database from a specific user when requested from the IP of one of the other servers.

Or, if you want to get fancy, you could setup an LDAP directory.

**darksoul** · 10-24-2005, 09:40 AM

You can use mod_auth_sql which will connect to the master server to authentificate.

**Bronze** · 10-24-2005, 09:49 AM

Now I think about it, there'll be problems If I use .htaccess because there will be duplicate name from the 2 different site. So this is not an option.

I can authenticate by MySql most likely, but CCbill script can't or won't write across server to the Database for new user. Each site have 4 different script, they all need to write across server.

**darksoul** · 10-24-2005, 09:53 AM

You can replace the ccbill script with your own.

**Bronze** · 10-24-2005, 11:38 AM

Anyone know of a program that do this? I don't like to have make the scripts, if it's the last thing I need.

**RobbieRye** · 10-24-2005, 12:02 PM

Originally posted by darksoul

You can replace the ccbill script with your own.

Yeah, this is the way that I'd go too. If you can't write it yourself, ask for some consulting help from this forum.

Before writing the new program, I would likely check out the existing one to see if there is a simple way to do it.

The only other option that I can think of is to add a second IP to each of the servers and privately forward all authentication tasks to the central server.

4 sites on 4 different hosting, on 1 database

4 sites on 4 different hosting, on 1 database

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment