We are all engineers
On the overuse of the term engineer in the computing industry. Read more
On the overuse of the term engineer in the computing industry. Read more
Tags: overuse engineer database suggested facebook reminded interview pursue declined insisted benchmarking automation cluster center electrical warehouse recruiting escalation arm validation manufacturing mysql integration partner graph supplier mechanical streaming frankly exhausting looked flickr baldwin steam locomotive silverton staticflickr
Some high-level notes from an evaluation of Redis. Read more
Tags: thoughts redis evaluation broadly caching queuing addressing architectural operational caveats nosql statements pinch salt expert encounters sharing consumers apis php evaluated tackled memcache mysql rabbitmq varying degrees appealing leverage architecture workloads inverse replication architectures slave writes slaves nodes clustering fastest unix socket cache losses stale synchronize manages dataset ram database snapshotting harder fulfill grows fork phenomenon io forking interconnect limits ttl permanent datastore linux swap exhausted evict stuff config commands keys max sadly issuing cool api failover ranks reflex sentinel monit pidfile cycles totalmem children cpu backups rdb temporary renamed destination atomically snapshot critical performing comparisons memchache github resque managing winning ini tcp bunch lag clustered replacement cluster endless solve http
Subqueries in MySQL 4.1 Read more
Tags: subqueries mysql surely database
A detailed tutorial on how to migrate an existing latin1 encoded MySQL database to utf8 (UTF-8) encoding. Read more
Tags: converting mysql database migrate encoding latin alphabet japanese arabic convert utf tables procedure columns collation null privileges sometext schemata garbled alter testmigration collate bash terminal mysqldump root sed iconv restore inspect bell labs cat
A tutorial on how to kill all of the currently running queries on a MySQL server. Read more
Tags: killing mysql occasion etl transform locking loader misbehaving issuing impacting database statements dynamically separator processlist outfile terminal bash cat sql
A list of technical questions for use during interviewing a MySQL DBA candidate. Read more
Tags: screening mysql dba candidate dozens dbas backgrounds sql oracle nuances specifics approximate answers myisam innodb locking foreign keys acid compliant stuff candidates struggle replication slave balancers gotcha shooting lag isolation ranging uncommited dirty serializable commited prevents repeatable phantom root database passwords tight grant ssl honest paid surprised pursuing studying
A new core controller should be added to Alpha to handle CRUD requests. Read more
Tags: activerecordcontroller alpha controller crud apis violates dry convinced http api activerecordtype optionally activerecordoid frontcontroller marshal database activerecord controllers reduce centralize records pagination investigation alphaframework php
The 2.0 beta release of the Alpha Framework for PHP is now available. Read more
Tags: alpha framework php commits branch readme validation checks mappings database ui widgets mysql sqlite rendering html json caching apcu redis memcache crud controller elegant routing admin rss atom markdown cms voting tagging clouds encryption tokens cross embedding http filters ips logging audit trail retain consists github
A detailed tutorial on how to backup a single MongoDB server with mongodump and restore it with mongorestore Read more
Tags: mongodb mongodump sinle restore mongorestore describes database linux subsequently shards replication multi node cloud dumps param mkdir mongobackup restaurants localhost illustration binary json records metadata meta bson index namespace descriptions cat cron scheduled restoring logging issuing db dbs collections dir indexes restored
A guide on how to set up two separate instances of MongoDB running on the same server. Read more
Tags: mongodb instances sharding replication database seperate virtualization fedora laptop assumes instance alphadevx redhat config cp conf paths nano interfere init mongod binary mkdir chown mongo commands flag
Displaying 11 to 20 of 47.