Questions tagged [xtradb]

50 questions
0
votes
1 answer

How to setup multi instances using percona xtradb cluster?

we are using 3node percona-xtradb cluster. Now we are planning to add one more instance in all 3 nodes and make it as a another cluster group. How to setup multi instances using percona xtradb cluster?
user3048109
  • 217
  • 2
  • 8
0
votes
1 answer

Mysql Xtradb build indexes by sort instead of via insertion

This post says: If you’re running Innodb Plugin on Percona Server with XtraDB you get benefit of a great new feature – ability to build indexes by sort instead of via insertion However I could not find any info on this. I'd like to have an…
Fluffy
  • 27,504
  • 41
  • 151
  • 234
0
votes
1 answer

Issues setting up Percona Xtradb Cluster with 2 servers

I'm trying to set up a Percona XtraDB cluster on two machines.. but i'm having a terrible time in getting the second machine up and running. I have used this article as a reference, and while it seems to be almost working, there's probably something…
GoldieNZ
  • 53
  • 7
0
votes
2 answers

MySQL Subquery With LIMIT vs JOIN

I would prefer to use a JOIN for this, but none of the solutions are either viable due to performance impacts or they don't return the right result set. The RunTime column is a UNIX timestamp captured every night at midnight. Not every entry will…
Mike Mackintosh
  • 13,917
  • 6
  • 60
  • 87
-1
votes
1 answer

Percona XtraDB Cluster : Server quit without updating PID file ... server startup failed

Can some one help me please ? 1) Host of my VPS (Centos) was down (Provider problem) 2) After VPS reboot, the node XtraDB cluster refuse to start 3) Other nodes (2) were note impacted I read lot of posts and try to by many ways but nothing works.…
1 2 3
4