Hello guys , how are you doing ?
I want to create a unified search for many services I have, they are on multiple servers, and each one with its own database and contents.
I've tried to connect to those database by using IP address but it refuse to connect for security reasons.
How can I achieve something like this ?
I thought in a way to gather all databases in one server then do search on it ,BUT how I can update those DBs frequently ?

Recommended Answers

All 2 Replies

Let say the databases are on ServerB and ServerC and the main website with the search function is on ServerA, if the servers are in the same network you can use bind-address directive:

bind-address = # local network IP address

Otherwise you have to comment this directive #bind-address and setup a firewall rule to allow connections to MySQL only from ServerA IP address. Once this is done you can directly access remote databases or you can choose to use federated tables: http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html which let you access remote databases by using your local server.

Consider also to setup SSL connections between the servers: http://dev.mysql.com/doc/refman/5.0/en/ssl-connections.html otherwise the data can be captured very easily.

thats mean a lot of work :D, thanks.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.