mysql optimization

Recently did quite a lot of mysql related administration. Found quite a few ways to optimise that may make future administration easier. 1) If you are going to add/drop databases very frequently, you might want to add innodb_file_per_table=1 into your my.cnf config file. This will allow mysql ...

happy monthiversary

After more than half a year of tweaking + trial and error, I think I have finally pinpointed the cause of my server crashes. Nope, nothing to do with kernel stability, nothing to do with crond or any other service. Probable cause is hardware related, the pcb for the barrel connector power input ...

Problems with FTP

1) No copy feature. There is no way to duplicate the file the file on the server for backup, testing or any other purposes. You have to download the file and upload it to another location, which is quite a hassle especially for large number of files. One would think that this is a common ...

Server cluster for $500

Already have one, seven more needed. Just joking. Looks real nice with all the LEDs and stackable case.Cable management will be a nightmare though. 8 ARM CPUs, 16 cores clocked at 1.4Ghz. Unfortunately, no practical use for me. Unless someone wants to find the next largest prime number.

cloudflare

Finally decided to try out cloudflare to see if my site would load faster. I had already created an account ages ago but was hesitant due a a few reasons. 1) Changing DNS will affect my MX records and during transition period, my emails might be lost if settings are wrong. 2) Complicated setup ...

iptables -F

This command should be removed or come with confirmation message before execution. Today, I wanted to to turn my blacklist into a whitelist. Reason being as I added new services, I don't always remember to add in new rules, as a result, I was exposing quite a number of potentially sensitive ...

Linux box to AP with hostapd/dhcpd/iptables

2 weeks after my last failure, my hands started itching again and I tried to bridge my ethernet connection to a wireless adapter running in AP mode. Some reasons which resulted in my failures in previous occasions 1) Networking on a headless server - When playing with networks, you need to work ...

apache vs nginx/lighttpd

Many articles out there extol the benefits of the event based servers such as nginx/lighttpd over apache. It supposedly consumes less resources under high load and excels at serving static pages. Unfortunately here I am still using apache, which up until recently had very erratic performance. ...