Reputation
Top tag
Next privilege 200 Rep.
See reduced ads
Badges
1 8
Impact
~3k people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Jul
27
awarded  Notable Question
Dec
1
accepted is it possible to get innobackupex to print the filenames it's busy with?
Nov
28
awarded  Curious
Nov
28
comment is it possible to get innobackupex to print the filenames it's busy with?
Thanks. I did try strace -f -o strace.out -eopen innobackupex --apply-log ... but the files it printed out did not lead me to the cause of the crash. As @eroomydna suspected, I was using a different version of Xtrabackup. In future I will make sure to prepare the backup immediately instead of before trying to restore it.
Nov
28
comment is it possible to get innobackupex to print the filenames it's busy with?
Thanks. Not sure what you mean by uncompressing all files, but it turns out the version difference was the problem. I successfully ran the apply log on the original server.
Nov
27
asked is it possible to get innobackupex to print the filenames it's busy with?
Nov
26
comment Migrate existing database onto Percona XtraDB Cluster (using innobackupex?)
It seems the best way to do this is to set up the original server as a cluster node, join the other nodes to it and then remove the original server at the end.
Nov
26
asked How do I recover from MySQL InnoDB table/index corruption?
Nov
17
awarded  Tumbleweed
Nov
11
comment Migrate from Percona Cluster to MariaDB Cluster
Thanks for the answer.
Nov
10
revised Migrate existing database onto Percona XtraDB Cluster (using innobackupex?)
Added thoughts on migrating by adding the original server into the cluster.
Nov
10
asked Migrate existing database onto Percona XtraDB Cluster (using innobackupex?)
Nov
10
comment Migrate from Percona Cluster to MariaDB Cluster
I'm about to roll out a Percona XtraDB Cluster. Did you solve your problems?
Oct
27
awarded  Commentator
Oct
27
comment Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Thanks. I suppose that's a fair comment :)
Oct
22
accepted Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Oct
22
comment Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Thanks. I've skimmed the links you sent, but will go through them more thoroughly as soon as I am able.
Oct
21
comment Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Thanks for the answer. The Samsung 850 Pro is surely going to perform much better than e.g. SAS drives, right? In what way is it "not server-grade"? If I understand your answer correctly, you think that it's unlikely for the faster CPU to make a difference unless the config is bad, (but of course it depends on the queries.)
Oct
21
asked Upgrading hardware for MySQL. If we get SSDs, are CPUs likely to become a bottleneck
Oct
20
accepted Importance of uniformity of hardware for Galera cluster