/build/static/layout/Breadcrumb_cap_w.png

Replication status report

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

Answers (5)

Posted by: scottlutz 12 years ago
Orange Senior Belt
0
This is all contained in the Replication page already. Are you wanting to export the data, or something similar?

Comments:
  • 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. - bbevard 10 years ago
Posted by: Mariusja 12 years ago
Second Degree Green Belt
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
Posted by: GillySpy 12 years ago
7th Degree Black Belt
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?
Posted by: Mariusja 12 years ago
Second Degree Green Belt
0
I don't have a report yet that I can run.

I need the SQL query to generate the report.
Posted by: Mariusja 12 years ago
Second Degree Green Belt
0
GillySpy

I see now what you are trying to say. It is working like a charm, thx!
Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ