ANF
2010-10-30 10:52:17 UTC
Hello everyone,
I have no background in php or MySql but I'm learning quickly because this
has called a halt to the website development. My problem is this:
There are two servers using MySqL. I have the remote ip connection data
for one server but not for the 2nd server. I have been refused these
details for the 2nd server on the grounds that it is a security issue.
Users of content on my website, register (username and password) on the
2nd server. The first server contains content that requires login (same
username/password stored on the other server database). In effect the
databases have to link. I did think of storing a table with
authentication details on the first server - i.e. a copy of the
registration table on the second server. Thus authentication takes place
directly. However, I've been told it is not a good idea to have two
tables with the same info for the same purpose in php. MySql provide a
'federated engine' solution for cross server access but I don't think that
applies here as quieries (it seems to me) are only one way. Am I wrong
about this? Does the federated engine present a possible solution? Any
ideas would be most welcome. ANF
-------------------------------------
--
+----------------------------[ SERVER SIGNATURE ]---
| Article posted via Web Developer's USENET Archive
| http://www.1-script.com/forums/
| Web and RSS gateway to your favorite newsgroup -
| mailing.database.mysql
+---------------------------------------------------
I have no background in php or MySql but I'm learning quickly because this
has called a halt to the website development. My problem is this:
There are two servers using MySqL. I have the remote ip connection data
for one server but not for the 2nd server. I have been refused these
details for the 2nd server on the grounds that it is a security issue.
Users of content on my website, register (username and password) on the
2nd server. The first server contains content that requires login (same
username/password stored on the other server database). In effect the
databases have to link. I did think of storing a table with
authentication details on the first server - i.e. a copy of the
registration table on the second server. Thus authentication takes place
directly. However, I've been told it is not a good idea to have two
tables with the same info for the same purpose in php. MySql provide a
'federated engine' solution for cross server access but I don't think that
applies here as quieries (it seems to me) are only one way. Am I wrong
about this? Does the federated engine present a possible solution? Any
ideas would be most welcome. ANF
-------------------------------------
--
+----------------------------[ SERVER SIGNATURE ]---
| Article posted via Web Developer's USENET Archive
| http://www.1-script.com/forums/
| Web and RSS gateway to your favorite newsgroup -
| mailing.database.mysql
+---------------------------------------------------