attachment restrictions

[Alice]

I was just trying to add a noavatar resource and found that the attachment restriction has been halved to 512Kb, bit annoying since I enquired about an increase not so long ago but that is up to you guys here. Can we have .rar file extensions allowed please, it is getting ridiculous attaching larger files, I have to make split .rars and then zip the split .rars, it's getting to be a real nuisance to be honest.

 

[0ptima]

I have a cron job on the backup machine that first does a MySQL dump, then an rsync. To copy the data.

I have all my tables as InnoDB (with a couple as MEMORY for who's online and flood control). Having all my tables as InnoDB allows me to use the --single-transaction parameter to mysqldump. This allows MySQL to take a consistent snapshot without downtime or delay. I also pipe mysqldump through gzip to reduce the disk writes, which makes the writing of the backup, then the rsync faster.

The rsync will occasionally get new attachments that the data set doesn't know about, and occasionally an avatar might be lost (old one gets deleted after the new one is created; they have unique filesnames), but that's it.

The backup is approximately 500 MB (450 MB of which is the compressed MySQL dump).

The backup is run at daily approximately 5 AM EDT/EST, as that's when traffic is the lowest.

That is impressive

I rsync the mysql dump (150 megs) and the file system attachments to another server. I also run this backup at 5am.

 

[Jesepi]

We really need to implement per-filetype limits - I've seen four one-megabyte images attached already today.

I'll make it a priority item.

Yes please. My users don't see the issue with dragging images directly off their phone/cameras and uploading them.