4 sites on 4 different hosting, on 1 database
 

Hi,
I was wondering if anyone ever done this before, or ever come across an issue like this and they have a solution. I have 4 paysites on 4 different server, that I want to combine them, so that when a user sign up they will put into a database. The next time they login, they can login from any of these site using 1 login, if they cancel, they will be wipe from the database and they can't login to any of these site again. Is there anyway possible to do this? I've call CCBill and they said there's no way to write across 4 different server. Just wondering if anyone ever come across this or know of a solution for this.

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

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

paysites end.

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.

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?

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.

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

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.

You can replace the ccbill script with your own.

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.

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.