Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Looking for suggestions on how to do this

Looking for suggestions on how to do this

Looking for suggestions on how to do this

I have a mysql query that I want to take the result of and upload/insert it into a different Mysql server. This would be once a day and over the internet. I will have many PCs sending the same info to a commn Mysql DB. I can setup ssh access. Just not sure how to get the info across. Is there a way to connect the MySql DB together and then run a query? I just don't know. Any suggestions are much appreciated.


RE: Looking for suggestions on how to do this

Here are some suggestions about using a Database Link

---- Andy

"Hmm...they have the internet on computers now"--Homer Simpson

RE: Looking for suggestions on how to do this

As normally you connect to a MySQL server and query it, why try to do this inversely? If you have a central server, how about the idea to let that server query all the other servers instead of all servers reporting?

It's not just meant as a rhetorical question. Both ways are surely possible and have their pros and cons.


RE: Looking for suggestions on how to do this

Thanks Andrzejek I'll check that out.

Thanks Chris, hadn't thought of doing it from the central server to the others, makes more sense. Then I can manage the query activity better.

RE: Looking for suggestions on how to do this

I can think of reasons for both scenarios.

1. Each single server knwoing the central server may be simpler than the other way around, but then each server once connecting the the central makes itself known there.
2. If there is a time when one server is "done for the day" that makes it easier for it to report exactly then, as timely as possible, whereas the central server might not know.
3. Exactly the optimal timing of 2 is only optimal for the single server, not necessary for the overall system.

I can also give better advice if knowing the general situation better. I have worked no POS systems that report most any single sale/receipt to a central server or bundle this as closing data.

The most general idea of a database system, no matter if just one central server or a distributed system that it's there for all clients and kept up to date mutually at all times, so any client can know within rules of what data it's allowed to see or manipulate, so that you don'T have some kind of hording data and data exchange as closing task for a day, but continuous exchange.

What you want I'd usually subsumize into the topic of data replication. Which in the end is just a special configuration between several servers that acts on itself from then onwards and needs no specific programming about what data is queried and goes where. In fact, it does do a mixture of "reporting" and "querying", under the overall simpler task to keep all data available in several places.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close