With NodeJS (built on V8) it's pretty simple to access libraries written in C/C++.
Since NodeJS is 100% non-blocking I/O you'll need to tell your libraries to do the same. Even though libmysql is not yet capable of doing that, you may use postgres for this.
Ryan's node_postgres is a binary binding.
Compiling is easy as usual:
$ node-waf configure build
If you receive the error: The program pk_config could not be found, you'll need to install postgres dev libraries package first. On debian/ubuntu you do that the following way:
$ sudo apt-get install libpq-dev
It may fail to build then with the message: "Build failed", "cxx binding.cc -> binding_1.o". I am currently running into the same issue and will post an update as soon as I got this fixed.