I need the SQL query that will give me the status of my replicates.

I need to know the machine name, Ip and status of the replication (how many mb still need to replicate)?

Hope it make sense.

Thx
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
This is all contained in the Replication page already. Are you wanting to export the data, or something similar?
Answered 11/27/2011 by: scottlutz
Orange Senior Belt

  • But when you export the data to CSV it doesn't pull the replication status. It pulls everything you see on the screen and then for the last field you just get enabled. Where do I need to go to find the status? I have been using MySQL Workbench to look through the tables but I can't find the table that contains replication status.
Please log in to comment
0
Yes I need to export the data.

If I can pull a report with the following fieds it will be graet:
Machine Name
IP
Replication status
Answered 11/28/2011 by: Mariusja
Second Degree Green Belt

Please log in to comment
0
On any list page you can go to the menu and export the list Choose Action-> Export to CSV
Does that solve the issue?
Answered 11/28/2011 by: GillySpy
Seventh Degree Black Belt

Please log in to comment
0
I don't have a report yet that I can run.

I need the SQL query to generate the report.
Answered 11/28/2011 by: Mariusja
Second Degree Green Belt

Please log in to comment
0
GillySpy

I see now what you are trying to say. It is working like a charm, thx!
Answered 11/28/2011 by: Mariusja
Second Degree Green Belt

Please log in to comment
Answer this question or Comment on this question for clarity