157 reputation
7
bio website
location
age
visits member for 3 years, 10 months
seen 11 hours ago

11h
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.
12h
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
Oct
17
asked Importance of uniformity of hardware for Galera cluster
Oct
17
comment MySQL cluster concurrency
@Mahesh Patil, Well, your first point is something I was wondering about, so thanks anyway :)
Jun
17
awarded  Supporter
Feb
4
awarded  Popular Question
Jun
14
awarded  Editor