49 reputation
1
bio website shlomo.shmai.com
location
age
visits member for 4 years, 10 months
seen Apr 1 '10 at 22:57

Apr
1
asked Graphical MySQL tools
Feb
26
comment Replicate MySQL database with “non-permanent” write
Sorry for not being clear, I wasn't saying that 4GB would take 20 hours. I was simply expressing my concern that IF it did take that long, then there would be problems. I spoke with the DBA and he told me that my DB is about 15GB and they did a restore for me and it took maybe 7 hours. Compared to your 500GB in 6 hours, this is very slow, are there anything that you do special to speed things up?
Feb
25
awarded  Student
Feb
24
comment Replicate MySQL database with “non-permanent” write
For Question 2, I'm talking about the initial time required to create the replica. For example, if the initial replication process takes longer than 20 hours, then I can't start the initial replication process on a weekday (it will interfere with our daily update process). I will need to do it in pieces--i.e. start it at 8AM everyday and stop it at 5PM everyday. I understand that once I have a replica of the database, any incremental daily updates will have minimal impact.
Feb
23
asked Replicate MySQL database with “non-permanent” write