compress mysql responses / cache them

[cycomate1]

Hi everyone,

I'm running vB and it's database on different servers. A forum hit consumes around 350 kB of traffic (from the database server to the webserver) - that makes more than 100 GB per month.
I already tried the MYSQL_CLIENT_COMPRESS flag but it seems not to be working:

@@ -272,3 +272,3 @@ class vB_Database
                {
-                       $link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password);
+                       $link = $this->functions[$usepconnect ? 'pconnect' : 'connect']("$servername:$port", $username, $password, MYSQL_CLIENT_COMPRESS);
                }

I still see the database content rushing in clear text.
However, a self-written php file that queries the database using MYSQL_CLIENT_COMPRESS works fine, the result gets compressed.

I saw there is many unvarying data being transferred on each forum hit - like the forum templates, phrases, permissions etc. In fact that's the majority of what's being transferred.
Is there a way of caching these tables locally (in php, on the webserver's side)? If not, how to compress the data?

Regards,
cycomate

[Zachery]

Are your mysql and web servers not directly bridged? And is your provider charging your for the bandwidth that they use to comminucate?

Weird, I personally wouldnt even start to think about sending any communications like this over any sort of public network.

[cycomate1]

The servers are on different networks.
It's the only possibility for me to run vB on two webservers with one database (load balancing). I was using ssh to tunnel the sql queries but encryption and compression was too heavy for the machines at high traffic and whenever the ssh tunnel was interrupted the forum I had to check and restart them, which made the forum unusable for some time. A direct mysql connection is far better but insecure?.

So, to get back on topic, is there a way of caching tables or compressing the mysql connection?

?) just to make it clear: I am currently using an ssh tunnel for the communication between the web servers and the database. The traffic for a forum hit is around 350 kB w/o encryption plus ~50 to 75 kB encryption overhead (I disabled the encryption for measuring purpose). I was asking for MYSQL_CLIENT_COMPRESS because I believe letting mysql handle the compression could be better than leaving it to ssh. And there is much unvarying data (forum templates, phrases, ..) that's being transferred over and over each time someone hits the forum. Caching this content on webserver-side would be great.

[Zachery]

It seems to me the better option would be for you to either get new servers that are closer, or new servers that are cross connected. For your own sake.

[cycomate1]

Getting new servers is not an option to me.

Well it seems there's no solution of caching static content on the webserver-side. I'm still curious why MYSQL_CLIENT_COMPRESS won't work.