Golden Hill Country Park
while visiting Hong Kong this winter my colleague and ex-flatmate from Goteborg times took me to the Kowloon Byewash Reservoir / Golden Hill Country Park.
bridge on vlans on active-backup bonding under debian
the idea: i’d like to run kvm/lxc on debian, have guests bridged to couple of vlans and handle the network failover on the host level. network failure should be detected using arp probes not just the link [ mii ] status. after few attempts i got it working in the test environment.
debian on dell poweredge 13th gen – r630
i’ve received for testing a new dell r630. before buying few of those i wanted to make sure that debian wheezy has kernel including all the needed drivers. it seems that it has.
UNION instead of OR in MySQL
i have MySQL that is run on arrays of increasing size: i remembered that the query optimizer will not be able to use existing indices for lastModified columns but.. the query execution time was acceptable, so i did not bother. recently much more data was added and query above, repeated quite often, caused a lot …
balkans
i’ve sepnt two August/September weeks traveling with my parents from Dubrovnik via Sarajevo and Zagreb to Budapest. short brain-dump with hiking maps follows.
OVH, failover IPs, IPv6, VMs
at work we rent a dedicated server from OVH; except unexplained openvpn throttling all is working pretty well for the price we pay. besides primary IPv4 address OVH can provide few additional ‘failover’ IPv4 addresses and /64 IPv6 subnet. in our setup some of IPv4s and IPv6s are routed to a KVM VM. below – …
Dell PowerEdge T20
i’ve bought 2x Dell PowerEdge t20 – they’ll serve as HA pair of routers/vpn endpoints/file servers for a new office. it was the first time i played with intel amt. it’s not bad but neither perfect.
around Gran Canaria
i’ve spent 2 weeks at the beginning of March at Gran Canaria. below – list of the more interesting walking trails we’ve taken.
sphinx text search – sorting the results by relevancy
a while ago i helped a colleague with moving away from mysql-based text search based on MATCH .. AGAINST to sphinxsearch to improve the performance. without much surprise this helped a lot to improve the response time. recently i was asked to take a look at the setup again and see if we can do …
Continue reading ‘sphinx text search – sorting the results by relevancy’ »
hk, mc, sg, my
some walking trails i’ve taken during my last trip to Hong Kong, Macau, Singapore, Malaysia.
pigz –rsyncable, rdiff
i’m backing up in total ~90GB of mysqldumps each night. the more data, the bigger pain it is.
hu/sk/at/cz
a brain-dump from my recent trip to Hungary, Slovakia, Austria and Czech Republic.
chrooted bind9 with geodns under debian wheezy
at work we’ll soon make use of dns-based geo load balancing to have users in americas / asia ‘talk’ with north am site and rest of the world – with the european site. we preferred to avoid modifying the client application so the dns based solution seemed reasonable. below – quick overview of the setup …
Continue reading ‘chrooted bind9 with geodns under debian wheezy’ »
cloning GPT disk to a smaller drive
while rescuing data from server having problems with either disk or raid controller i had to clone data from 2x 1TB RAID1 to 4x 500GB RAID10. as it turned out the space available on the destination server was 1GB less than on the source machine. shrinking the source drive with gparted-live and dd’ing over the …
[somewhat] byzantine backup setup
below – a description of somewhat convoluted backup system that so far have been serving me pretty well.
installation of debian wheezy on mdadm raid1 + gpt
in branch offices i tend to install two identical pcs running linux and working in active – hot-spare setup. things evolved over time – one location has both routers running under vmware esxi on two different hosts, another – hardware raid, other – desktop-class pcs with single hard drives. hardware raids are good as long …
Continue reading ‘installation of debian wheezy on mdadm raid1 + gpt’ »
adventure with green drives
wd [and other vendors] sell green drives; they are reasonably cheap but have annoying tendency to spin down very very quickly. i bought recently 2x WD20NPVT-00Z2TT0 with intention of using them [in very unprofessional fashion] in PERC6 RAID1 array.
hk/mc/sg/vn
i got another chance to visit Asia. instead of suffering cold, dark and cold January in Sweden i’ve spent 3 weeks in mild Hong Kong & Macau, tropically hot Singapore and pleasantly warm Vietnam.
raspberry pi
few days ago, after 19 weeks of waiting, i have finally received my raspberry pi.
ansible – centralized configuration management…
… that did not drive me crazy so far.