Best way to handle multiple databases?

[inmn]

We have 3 databases. Write, read, and log.

We're switching between the databases but find inconsistent behavior when doing so. Sometimes write keeps a sleep connection open. Sometimes it doesn't switch and the data goes into the wrong location.

Should we be trying to explicitly close a connection? Or any other way to debug this.

It's only under extreme duress that it fails.

[Matthew Frederico]

I'd recommend tuning mysql and your tcp timeouts in the linux kernel of where the server is located so that it doesn't keep connections in time_wait status and other networking performance tuning.  Here is a great article:

http://www.lognormal.com/blog/2012/09/27/linux-tcpip-tuning/  

--
You received this message because you are subscribed to the Google Groups "redbeanphp" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redbeanorm+unsubscribe@googlegroups.com.
To post to this group, send email to redbe...@googlegroups.com.
Visit this group at https://groups.google.com/group/redbeanorm.
For more options, visit https://groups.google.com/d/optout.

--

-`;'- Matthew Frederico