164 reputation
8
bio website
location
age
visits member for 3 years, 10 months
seen Dec 8 at 12:57

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?
Nov
10
comment How to migrate a mysql server in production to Percona XtraDB Cluster
I think that using mysqldump to back up the data and then restoring it onto the cluster would be easiest as long as the database is not too big. I'm trying to do something similar with a largish database for which mysqldump and load is too slow. Did you find a solution to your problem?
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