最近给一个朋友做服务器配置，他买的一个独立的服务器，因为服务器商防火墙的设置，很多网络访问都被禁用（比如Ping, 怀疑他们的能力）；

我想让朋友用GUI工具直接访问远程数据库，不过可恶的是尽管配置了Mysql 服务器绑定远程地址，还是不能访问；尝试用 SSH 隧道来代理访问了；

执行这条命令:

 ssh -L 3306:localhost:3306 romote_user@remote_server_address

语法是: ssh -L <localport>hostname<remoteport> <username>@<servername>

这条命令的含义是将localhost:port 的请求重定向到绑定的地址:port

（所以如果本地安装了Mysql 监听着3306端口，那把本地端口配置改成其他的；）

再链接一下远程的服务器吧:

mysql --host=localhost --port=locate_port --user='user' --password='pass'

执行命令后，　SSH 会把这个请求重定向到服务器上;

Yesterday a friend was requesting a MYSQL/PHP Consultant to speed up his websites, and today I was reading few comments and solutions on his facebook : Use APC, mem_cache for PHP, mysql query caching, use nginx instead of Apache, Use mysqli extension instead of adodb or mysql extension ... etc. Of course all of these could be solutions, but unless you have previously located what the problem really is.

A website could be slow for many reasons, and to be able to fix it and make it run faster you have to first find problem. What you will need to know is :

1- Understand the business :

Before looking into PHP or MySQL, have a first look at the website(s) and answer these two questions :

- What is slow
- Why is it slow

Look at the page size, images, video, flash, ... your issue might be in the client side and everything else might be good.
Use a tool like Firefox web developer extension and disable everything : CSS, Javascript, Images... and load the page as html to feel the difference.
The business here is NOT the business logic behind the website, it's the interface that people use to interact with the website. If everything looks okay, you can go for further server-side investigations.

note: I copy below example from internet.

Below is a simple program using node.js for translating text using google API.

var http = require('http');
 
var url = ('ajax.googleapis.com')
var google = http.createClient(80, url);
 
var text = "Hello World from node!";
var requestUrl = '/ajax/services/language/translate?v=1.0&q=' + 
                 escape(text) + '&langpair=en%7Cfr'
var request = google.request('GET', requestUrl, 
              {"host": "ajax.googleapis.com"});
request.end();
 
request.addListener('response', function (response) {
  var body = '';
 
response.addListener('data', function (chunk) {
body += chunk;
    });
 
    response.addListener("end", function() {
        var jsonData = JSON.parse(body);
    console.log(jsonData.responseData.translatedText);
    })
 
});

This simple example does not to justice to the true power of node.js. I’ll be posting useful examples in the near future. Keep watching.

step by step:

1. Should install certain libraries:

sudo apt-get install g++ curl libssl-dev apache2-utils

2. Now, Download node.js with GIT

git clone git://github.com/ry/node.git

3.You are ready to install node.js
cd node
./configure
make
sudo make install

note:if need, you can type : sudo apt-get install git-core to install GIT.

ps -ef | grep eclipse

kill PID