Got the GUI going The download file from the Canadian HTTP mirror appears to be Corrupt, use another Mirror....
Other issue, using XsecurePro (a win client for processing X11) we are able to see the gui.
Problems occur with the initial authentication. WE are using RH7.3, MySQL 3.23.49 with 1 way replication.
1. The master & slave have the same uid/pwd, however, we have to use an alternate uid/pwd combo on the master to be authenticated.
2. The master cannot see the slave, info & the Slave cannot see the master info. The slave does say it is running.
3. Both servers indicate to the GUI that they are Master?
4. The button "Detect Slaves" is always greyed out, is that because it is not active yet??
5. What are the planned extensions of this tool, besides showing the status of the servers. What about info when the master or slave dies, resync of the master to the slave data??
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
* 1.
I am not sure I understand... If uid/pwd are the same, you can use "connect to all server", that you can find if you select the server list. It will try to authenticate to all the servers in the list.
* 2. 3.
You have to tell the GUI which server is a slave to what. You can "modify server" and re-select the master.
* 4.
You should try "show processes". Slaves are detected by looking at the connection. (If your slave is not connected to the master won't find it.)
* 5.
We deal with a good number of servers (8 or more), so our biggest problem is problem discovery. This is why this part is the most developed.
Once you are able to execute remote commands and queries, you are basically able to do everything. The main planned extension is to automate slave setup (through remote commands and queries). Another feature we wanted to add is the ability so save some most used queries and commands.
As I am basically the only person working on this project, and I am also involved in other projects, my time is unfortunately limited. But the source code is available, so if you know Java a bit it's not difficult to add a couple more buttons with extra remote queries or commands...
Gabriele
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
* 1.
I am not sure I understand... If uid/pwd are the same, you can use "connect to all server", that you can find if you select the server list. It will try to authenticate to all the servers in the list.
I have verified that the Linux & Mysql UID & PWD combination are the same on both servers. I still have to connect to my master using a different UID/PWD combination....
Is the connection at the Linuxor MySQL level?
Anway I connect & can see both servers, next....
* 2. 3.
You have to tell the GUI which server is a slave to what. You can "modify server" and re-select the master.
Ok, I see if I point to the Slave (server2) & choose modify server, it makes it a slave. But it says it is a slave of itself????? How do I tell it that server1 is the master?
I am using Console - beta 0.6, Am I missing a newer version?
* 4.
You should try "show processes". Slaves are detected by looking at the connection. (If your slave is not connected to the master won't find it.)
Where is the "Show Processes" button?
* 5.
We deal with a good number of servers (8 or more), so our biggest problem is problem discovery. This is why this part is the most developed.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Got the GUI going The download file from the Canadian HTTP mirror appears to be Corrupt, use another Mirror....
Other issue, using XsecurePro (a win client for processing X11) we are able to see the gui.
Problems occur with the initial authentication. WE are using RH7.3, MySQL 3.23.49 with 1 way replication.
1. The master & slave have the same uid/pwd, however, we have to use an alternate uid/pwd combo on the master to be authenticated.
2. The master cannot see the slave, info & the Slave cannot see the master info. The slave does say it is running.
3. Both servers indicate to the GUI that they are Master?
4. The button "Detect Slaves" is always greyed out, is that because it is not active yet??
5. What are the planned extensions of this tool, besides showing the status of the servers. What about info when the master or slave dies, resync of the master to the slave data??
Hi,
* 1.
I am not sure I understand... If uid/pwd are the same, you can use "connect to all server", that you can find if you select the server list. It will try to authenticate to all the servers in the list.
* 2. 3.
You have to tell the GUI which server is a slave to what. You can "modify server" and re-select the master.
* 4.
You should try "show processes". Slaves are detected by looking at the connection. (If your slave is not connected to the master won't find it.)
* 5.
We deal with a good number of servers (8 or more), so our biggest problem is problem discovery. This is why this part is the most developed.
Once you are able to execute remote commands and queries, you are basically able to do everything. The main planned extension is to automate slave setup (through remote commands and queries). Another feature we wanted to add is the ability so save some most used queries and commands.
As I am basically the only person working on this project, and I am also involved in other projects, my time is unfortunately limited. But the source code is available, so if you know Java a bit it's not difficult to add a couple more buttons with extra remote queries or commands...
Gabriele
* 1.
I am not sure I understand... If uid/pwd are the same, you can use "connect to all server", that you can find if you select the server list. It will try to authenticate to all the servers in the list.
I have verified that the Linux & Mysql UID & PWD combination are the same on both servers. I still have to connect to my master using a different UID/PWD combination....
Is the connection at the Linuxor MySQL level?
Anway I connect & can see both servers, next....
* 2. 3.
You have to tell the GUI which server is a slave to what. You can "modify server" and re-select the master.
Ok, I see if I point to the Slave (server2) & choose modify server, it makes it a slave. But it says it is a slave of itself????? How do I tell it that server1 is the master?
I am using Console - beta 0.6, Am I missing a newer version?
* 4.
You should try "show processes". Slaves are detected by looking at the connection. (If your slave is not connected to the master won't find it.)
Where is the "Show Processes" button?
* 5.
We deal with a good number of servers (8 or more), so our biggest problem is problem discovery. This is why this part is the most developed.
*1
The connection is a normal MySQL connection.
*2 *3
When you "modify server" you actually tell which server is a slave of...
*4
Above "detect slaves" there is a "query" button. Push it! :-)