I am eager to write something based on my experience in the software business. Hey, it is a good reminder for me in the future as well!
1. Backup Plan
Do you have a software or script to backup both database and raw files regularly?
2. Failure Plan
What do you do when things fall apart? How do you [...]
I was involved in a big project and our team couldn’t deliver the product in time. We went through a 3 hr debrief and everyone agreed that our biggest problem is the lack of a centralised person, ie a project manager to bring all resources together. We thought that was simple but often overlooked. In [...]
I am using command line most of the time because of the nature of my work. Normally, when I discovered new techniques to do things, solved a problem or had a cool idea, I would write them down on my exercise book. It soon became clear that I needed something more concrete as copying lines [...]
Some Mysql db is using innoDB which implements foreign key contraints. If you can’t drop or alter a table, check that it doesnt have foreign key contraints. Well, innoDB can be an angel or devil…
In mysql command line, check existence of foreign keys
show create table demographic_type
CREATE TABLE `demographic_type` (
`id` int(10) unsigned NOT NULL auto_increment,
`user_group_id` varchar(255) [...]
I got inspired by the 10 commandments for system administrators from http://www.linux.com/feature/44315
This is my list:
1. Be WARY about COST CUTTING.
(cheap hardware, cables, labour)
2. KNOW THE NETWORK well.
(keep network, routing diagrams, track public and private IP, label cables if necessary)
3. ESTABLISH STRONG SECURITY POLICIES in the system.
(Security Access, File Permission, good password choice, encryption, SetUID, LDAP, [...]