handlersocket and replication galera working together?

[alex]

I have installed Percona Xtradb Cluster Server 5.5 and set up galera replication. Everything worked fine so far. Then I wanted to install the handlersocket plugin in mysql, but it didn't worked out . After many tests, I came to a conclusion:

  - if i install percona-server-server-5.5 package, I can install handlersocket, but the replications won't work (it doesn't recognize anymore wsrep variables in .cfn)

  - if i install percona-xtrabd-cluster-server 5.5 package, the replication works, but the handlersocket cannot be installed (the handlesocket.so file needed it doesn't even exist in this case). I've compiled and installed manually the file but when I want to query in mysql console the install command it gives me this error: errno: 2 /usr/lib/mysql/plugin/handlersocket.so: undefined symbol: _ZN3THDC1Ev

Can percona xtradb cluster work with handlersocket? And if so, what am I doing wrong?

Thanks in advance!

[seppo....@codership.com]

We have not tested with handlersocket so far. I believe there will be
some integration work ahead to deal with possible conflicts with
incoming replicated transactions. But, handlersocket support is in our
backlog, we just did not have time to start with it yet.

-seppo

[Henrik Ingo]

Alex

Whether HandlerSocket will work is a good question. (my guess is that
it will, but if you get deadlocks it will not handle them well!) But
certainly you should be able to compile and load it. The below looks
like maybe you compiled against the wrong headers? Do you have another
version of MySQL installed too, or some remnants of it?

henrik

> --
> You received this message because you are subscribed to the Google Groups
> "codership" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/codership-team/-/LmiPXZT8kIoJ.
> To post to this group, send email to codersh...@googlegroups.com.
> To unsubscribe from this group, send email to
> codership-tea...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/codership-team?hl=en.



--
henri...@avoinelama.fi
+358-40-8211286 skype: henrik.ingo irc: hingo
www.openlife.cc

My LinkedIn profile: http://www.linkedin.com/profile/view?id=9522559

[alex]

Percona with XtraDB can install and use handlersocket, but it cannot replicate. As for Percona Xtradb Cluster, it can replicate but it cannot load handlersocket, even compiled from source code on the same machine. On the percona handlersocket's page it is specified that it works with Percona with XtraDB, but nothing about the cluster version, so I think it may not be compatible. I just wanted a confirmation from someone who tried the same configuration. I have only percona installed and when it installed, it has automatically removed other mysql versions.

> To post to this group, send email to codership-team@googlegroups.com.

> To unsubscribe from this group, send email to

> codership-team+unsubscribe@googlegroups.com.