MySQL Replication Status Plugin

how do I install the Mysql Replication Status plugin

Asked by Dereck Zenda

I would like to add the Mysql Replication Status plugin to mysql but i am having problems as there no notes on how to do it.

Question information

Language:
English Edit question
Status:
Answered
For:
MySQL Replication Status Plugin Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Mark (pythonrules) said : 		#1

I haven't tested it 100%, but I got through the configure like this

wget http://code.launchpad.net/is-replication-status/trunk/0.1/+download/MySQL-is_replication_status-0.1.tar.gz
tar -zxvf MySQL-is_replication_status-0.1.tar.gz
cd MySQL-is_replication_status-0.1

./configure --prefix=/usr/local/mysql_cluster --with-mysql-src=/usr/src/other/mysql-cluster-gpl-6.3.20
make
make install

cd /usr/local/mysql_cluster/lib
 mv -v is_replication_status.* mysql/plugin/
`is_replication_status.a' -> `mysql/plugin/is_replication_status.a'
`is_replication_status.la' -> `mysql/plugin/is_replication_status.la'
`is_replication_status.so' -> `mysql/plugin/is_replication_status.so'

Restart MySQL.

mysql> install plugin SLAVE_STATUS soname 'is_replication_status.so';
Query OK, 0 rows affected (0.07 sec)

mysql> install plugin MASTER_STATUS soname 'is_replication_status.so';
Query OK, 0 rows affected (0.00 sec)

Revision history for this message
Mark (pythonrules) said : 		#2

Looks good.

mysql> show tables like '%STATUS';
+----------------------------------------+
| Tables_in_information_schema (%STATUS) |
 +----------------------------------------+
| GLOBAL_STATUS |
| SESSION_STATUS |
| MASTER_STATUS |
| SLAVE_STATUS |
 +----------------------------------------+
4 rows in set (0.00 sec)

Can you help with this problem?

Provide an answer of your own, or ask Dereck Zenda for more information if necessary.

To post a message you must log in.