[Andy8]

What has happened to the post count? I seem to have lost 60 posts overnight :-(

[tooki]

http://forums.macnn.com/feedback/announcement/a/

It always pays to look at the announcements.

tooki

[Dork.]

FYI, I normally access these forums using the "New Posts" search, and this announcement does not appear in that search....

edit: Holy crap, I made close to 300 posts since March 30th that have evaporated from my post count! I spend too much time here....

[production_coordinator]

I was at 19,203!

Just kidding

[tooki]

The posts themselves are fine. The maintenance/repair isn't done, but capping it off with a post re-count (which will bring them back into sync) shouldn't be a problem.

tooki

[Person Man]

Originally Posted by tooki

The posts themselves are fine. The maintenance/repair isn't done, but capping it off with a post re-count (which will bring them back into sync) shouldn't be a problem.

tooki

Hmm...

It appears that people who have been temporarily banned since March 30 are currently unbanned as well... will a post recount fix that as well, or will people have to be re-banned by hand?

[Goldfinger]

omg test 1 2 3
EDIT: I guess I lost about a 100.

[tooki]

Originally Posted by Person Man

Hmm...

It appears that people who have been temporarily banned since March 30 are currently unbanned as well... will a post recount fix that as well, or will people have to be re-banned by hand?

So it would seem!

Since I don't have a backup of them, I guess they get a reprieve, unless Monish is able to recover the ban database, too.

tooki

[harrisjamieh]

Originally Posted by Goldfinger

omg test 1 2 3
EDIT: I guess I lost about a 100.

At least you didn't loose 700 posts, and drop back down to elite member from a green star forum-er. Wow, that means I posted about 700 times since March... I really do spend waaaaay too much time on here....

Ah well, hopefully this will all be sorted out soon. I swear everyone on this forum is mad on backup - ironic really, seeing as the last forum DB backup seems to be from March..

[Person Man]

Originally Posted by tooki

...I guess they get a reprieve...

I highly doubt you'll give Ca$h a reprieve

[rickey939]

gorickey® is still at 10,000 posts.

Phew!

[tooki]

Originally Posted by harrisjamieh

Ah well, hopefully this will all be sorted out soon. I swear everyone on this forum is mad on backup - ironic really, seeing as the last forum DB backup seems to be from March..

The people who moderate the forums are completely separate from those who maintain the servers. I run daily backups of my machine, and I can only point to this unfortunate event as proof of why backups are critical. (And also as why RAID is not a backup, since the cause of data loss here was corruption, which a RAID would dutifully replicate.)

tooki

[harrisjamieh]

All I want is my green stars back! I worked hard for them, and now they're gone.

[Person Man]

Originally Posted by harrisjamieh

All I want is my green stars back! I worked hard for them, and now they're gone.

As tooki said above, they're still working on the forums. Once they're done, they'll run another post count and things should sync up again, and then you'll get your green stars back.

[harrisjamieh]

Yay. They seem to be having major problems somewhere, the server was down again, like, 5 minutes ago.

[mkbhatia]

Hey guys, i completely agree. Within the next 4-5 days, we will have daily backups of the forums (remember how the nightly pause went away??). If anyone has any mysql expertise (replication, automated backups,) and would like like some monthly admin work, for a small stipend, please let me know. Again, that was really unacceptable. I apologize, but we were admist a server transition and it caught us at a (very) bad time.

[Velocity211]

Nooooo. I only lost about 200, but still...

[doucy2]

well i got a random problem
my PM's say i have 1 new message but i really don't

its been like that all day

[Scotttheking]

Originally Posted by mkbhatia

Hey guys, i completely agree. Within the next 4-5 days, we will have daily backups of the forums (remember how the nightly pause went away??). If anyone has any mysql expertise (replication, automated backups,) and would like like some monthly admin work, for a small stipend, please let me know. Again, that was really unacceptable. I apologize, but we were admist a server transition and it caught us at a (very) bad time.

I've been thinking about this, and the solution I came up with apparently is one that is decently used: http://www.onlamp.com/pub/a/onlamp/2.../MySQLian.html
I may be able to help set it up if need be. It should provide the solution you are looking for.

[Person Man]

Originally Posted by Velocity211

Nooooo. I only lost about 200, but still...

Just wait until they have the problems fixed. Then they will recount the posts and everyone should get their posts back.

Why can't people understand this?

[tooki]

Originally Posted by doucy2

well i got a random problem
my PM's say i have 1 new message but i really don't

its been like that all day

Thanks for reporting that. I am experiencing the same thing but wasn't sure if anyone else had.

tooki

[Dork.]

At least it gives me a chance to get to Post#666 again!

[skyman]

Hello........ Has MacNN not heard of the word "Backup"???

[besson3c]

Originally Posted by Scotttheking

I've been thinking about this, and the solution I came up with apparently is one that is decently used: http://www.onlamp.com/pub/a/onlamp/2.../MySQLian.html
I may be able to help set it up if need be. It should provide the solution you are looking for.

This is a cool way of sort of doing a RAID-1 mirror of your databases, if you will. If you are looking for incremental snapshots, using rsync with mysqldump files or the MySQL datadir is a very inexpensive way of managing backups without overwhelming a server. I have backups in triplicate on different machines and different networks, because it is pretty easy to setup.

If you are interested in my help or further advice, feel free to PM me.

[besson3c]

Originally Posted by mkbhatia

Hey guys, i completely agree. Within the next 4-5 days, we will have daily backups of the forums (remember how the nightly pause went away??). If anyone has any mysql expertise (replication, automated backups,) and would like like some monthly admin work, for a small stipend, please let me know. Again, that was really unacceptable. I apologize, but we were admist a server transition and it caught us at a (very) bad time.

See my last message, I might be interested in helping... What did you have in mind?

[Scotttheking]

Originally Posted by besson3c

This is a cool way of sort of doing a RAID-1 mirror of your databases, if you will. If you are looking for incremental snapshots, using rsync with mysqldump files or the MySQL datadir is a very inexpensive way of managing backups without overwhelming a server. I have backups in triplicate on different machines and different networks, because it is pretty easy to setup.

If you are interested in my help or further advice, feel free to PM me.

Are you commenting on doing those operations to the slave database? I assume when you say running on the MySQL datadir that you mean while the DB is offline.

[besson3c]

Originally Posted by Scotttheking

Are you commenting on doing those operations to the slave database? I assume when you say running on the MySQL datadir that you mean while the DB is offline.

I'm not sure I understand what you are asking. Doing the mysqldump by default will enable the --opt flag which will lock the database to prevent further writing at that time. You could write a script that would take MySQL or Apache offline before backing up the datadir if you wanted.

I'm assuming that for MacNN, using mysqldump would be ideal, as backing up the datadir is more of a strategy I use for a more general overall system backup. However, this scheme also works fine for restoring a database providing there is integrity with the backup database files pulled out of the MySQL datadir.

[Scotttheking]

Originally Posted by besson3c

I'm not sure I understand what you are asking. Doing the mysqldump by default will enable the --opt flag which will lock the database to prevent further writing at that time. You could write a script that would take MySQL or Apache offline before backing up the datadir if you wanted.

I'm assuming that for MacNN, using mysqldump would be ideal, as backing up the datadir is more of a strategy I use for a more general overall system backup. However, this scheme also works fine for restoring a database providing there is integrity with the backup database files pulled out of the MySQL datadir.

I was trying to figure out what you were saying.

The goal, as I understand it, is regular backups without having to take the DB offline or block writing during the backup. As a result, mysqldump cannot be run on the main database. Setting up a slave solves this.

Sidenote: Raid1 is a bit level mirror of 2 hard drives, not mirroring data on different drives via rsync or any other such thing. Just for terminology correctness.

[besson3c]

Originally Posted by Scotttheking

I was trying to figure out what you were saying.

The goal, as I understand it, is regular backups without having to take the DB offline or block writing during the backup. As a result, mysqldump cannot be run on the main database. Setting up a slave solves this.

Yes, but like a RAID-1 solution, the master/slave setup will gain you a constant replica of the master database - that may be perfect for what they need.

However, what I was describing was something that would handle incremental backups. Yes, the forum would be temporarily unwritable during this time, but incremental backups would allow the admins to roll back to an earlier state. I had no idea whether this would be something that would be useful or not.

I realize there is no direct comparison between RAID-1 and database backups, I recognize the difference. I was trying to make a reference as to what would be gained with this sort of solution. If the database corrupts on the master, it will be corrupt on the replica/slave too, which is where an incremental backup/snapshot scheme can be useful.

[Scotttheking]

Originally Posted by besson3c

Yes, but like a RAID-1 solution, the master/slave setup will gain you a constant replica of the master database - that may be perfect for what they need.

However, what I was describing was something that would handle incremental backups. Yes, the forum would be temporarily unwritable during this time, but incremental backups would allow the admins to roll back to an earlier state. I had no idea whether this would be something that would be useful or not.

I realize there is no direct comparison between RAID-1 and database backups, I recognize the difference. I was trying to make a reference as to what would be gained with this sort of solution. If the database corrupts on the master, it will be corrupt on the replica/slave too, which is where an incremental backup/snapshot scheme can be useful.

Ahh, ok. The purpose of the slave is to be the database that can be taken offline for backups. It functions as a mirror, but since nothing uses it, you stop it, run mysqldump off it, and then have your backups. It will allow daily backups (or even more frequently) with ease.

--Scott

[besson3c]

Originally Posted by Scotttheking

Ahh, ok. The purpose of the slave is to be the database that can be taken offline for backups. It functions as a mirror, but since nothing uses it, you stop it, run mysqldump off it, and then have your backups. It will allow daily backups (or even more frequently) with ease.

--Scott

Ahhh.. interesting! I hadn't thought of that.

[Demonhood]

postcounts are back.

[rickey939]

Originally Posted by Demonhood

postcounts are back.

Yes, I'm immortal again.®

[besson3c]

Originally Posted by rickey939

Yes, I'm immortal again.®

You just better not be stealing any more of them bases, you hear?

[rickey939]

Originally Posted by besson3c

You just better not be stealing any more of them bases, you hear?

I've been grounded it appears, so I'm not too worried about that.

[besson3c]

Originally Posted by rickey939

I've been grounded it appears, so I'm not too worried about that.

Perhaps you should just give your bases back, and apologize? An apology can go a long way

[Andy8]

Originally Posted by Demonhood

postcounts are back.

thank you
謝謝
ども

[rickey939]

Originally Posted by rickey939

gorickey® is still at 10,000 posts.

Phew!

Nevermind, gorickey has 10,211 posts now!!

How can that be??

[Kevin]

My post count was like raised 3k :o

[rickey939]

Originally Posted by Kevin

My post count was like raised 3k :o

I need that sort of raise on my salary.