Scheduled downtime 30 Oct 2011 22:00 EDT

Evan Prodromou's picture
Submitted by Evan Prodromou on Sun, 10/30/2011 - 06:03

I'm scheduling some downtime for this evening to fix up our database server situation. 

2011-10-30 22:28 EDT: took identi.ca down. I need to set up replication between our master server and a slave server, which requires stopping all writes to the database.

 2011-10-30 23:04 EDT: started transferring cold backup of master database server to new slave. Looks like about an hour to get that done.

 2011-10-31 00:04 EDT: 5 more minutes.

 2011-10-31 07.56 EDT: Argh! I'd backed up the /var/log/mysql/ directory on the master DB, and it ran out of disk space!  I think that's cleared up, but now I need to restart the whole process. Copying files again, will probably be back up by 10AM  EDT.

 

Comments

Hi Evan, has the missing

Submitted by Avax on Thu, 11/03/2011 - 18:36.

Hi Evan, has the missing dents issue been fixed? Have not seen an update to this post since 3 November, and most of my dents 2 weeks ago are still not restored. Wondering if it is just me or the recovery is still not complete. Thanks.

Wrong DBMS

Submitted by Leandro Dutra on Mon, 10/31/2011 - 08:21.

Seems like most failures in Identi.ca are related to MySQL, just as expected from the experience of other sites. Better to just go PostgreSQL…

Post new comment

Please note that blog comments are not monitored by our support staff. If you need assistance please visit our forums at forum.status.net or see the Support page for other options.
The content of this field is kept private and will not be shown publicly.
CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.