I setup a replica between two big MySQL server for a customer. Sometimes, when the replica was broken, I had lot of issues with columns defined as “auto-increment”. It’s not always possible to stop updates on the master, dump the data and restore them on the replica (DB’s are used
Category: Software
Firewalling with OpenBSD’s PF packet filter
Great tutorial about OpenBSD’s PF… http://home.nuug.no/~peter/pf/
Is greylisting the solution?
As everybody, I’ve too fight against spammers! I’m running my own MTA for several domain names and the box get it 24 hours a day by spammers. I’ve a quite performant SpamAssassin solution in place (~95% of spam is catched) but I’d like to prevent them to reach my SpamAssassing
PuTTY Session Manager
For a long time, I’m a daily PuTTY user. For business or personal purpose, I’ve always at least four or five opened sessions. My current PuTTY config has more than 40 saved sessions: local servers, customers, with or without tunneling, … PuTTY interface is not the best one to manage
Firefox 2 RC1 !
The Mozilla Firefox browser Release Candidate 2 is available!
mysqld got signal 11
Today I found this nice mysql “feature”: mysql> set password for user@host = old_password(“foobar”); ERROR 2013 (HY000): Lost connection to MySQL server during query This command generated a nice log: mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or
MySQL 5 on OpenBSD 3.9
This is a hot topic on openbsd-msic for a few days. It seems that lot of admins complaint about the MySQL stability. To be honest, I’m also facing issues since I reinstalled my box… 🙁 There is a dedicated page about this problem on openbsdsupport.com. Let’s test it!
Big cleanup!
Today, I spend some time to clean up “my” room @ home (read: where all my IT stuff is 😉 ). I found several old CDs. Some collectors: Netscape DevEdge (1996) Netscape SuiteSport (for Unix) (1996) CDE Linux Client Edition (1997) Linux RedHat 5.0 for Intel Computers (1997) ApplixWare 4.37
MicrosoftSuxx++ (one more time)
One more time, I lost time thanks to a Microsoft issue… With a colleague @ a remote office, we tried to setup a remote Sunray DTU as I did at home. Of course, we faced the fragmentation issue and started to find the best MTU value (thanks to tcpdump 😉
ERROR 2013 (HY000): Lost connection to MySQL server during query
I spent two hours to debug why my $^#@! MySQL server refused to accept connections from remote clients. The firewall was ok, the grant rules too. The connections was interrupted with a nice: ERROR 2013 (HY000): Lost connection to MySQL server during query The server (running OpenBSD was compiled with