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 ?

4 Years
Discussion Span
Last Post by OsaMasw

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.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.