Archive for the ‘Networking’ Category

mysql jdbc connector autoReconnect=true

Posted: 16th June 2010 by Darren Cassar in MySQL, Networking
Tags: , , , , , , ,
3

What makes you think jdbc autoreconnect is needed? Application is idle for long periods at a time? Wait_timeout too short? Network failure or glitches? Some good suggestions form Mark Matthews – Bug #5020 Having encountered the problem again myself today, trying to make jdbc for mysql reconnect any terminated connections using autoreconnect=true I figured out [...]

MySQL – IP vs DNS

Posted: 4th December 2009 by Darren Cassar in Databases, MySQL, Networking, OS, Solaris
Tags: , , , , ,
2

A MySQL is running happily on a machine situated in a land far far away. I grant access to a user@machine_aaaaaa (grant select on db.* to ‘user’@’machine_aaaaa’ identified by ‘password’; flush privileges;), send an email to the user saying it should run fine and happily go off my way. Mistake! It seems this user can’t [...]