08.08.07

SSH Tunneling

Posted in SSH, System Administration at 10:59 am by BrianS

One of the benefits of SSH is that you can tunnel communication through the SSH connection to the remote machine. These communications then act as if they are coming from the remote machine. This provides for a means of allowing access to local services without having to open additional ports on the perimeter or host firewalls.

I won’t go into details on how to accomplish this, there are plenty of tutorials out there. I just wanted to bring it to everyone’s attention as an option for server administration.

References

• Use MySQL GUI tools remotely and securely (TechRepublic)

Permalink Comments

07.13.07

Optimizing MySQL

Posted in MySQL, System Administration at 3:19 pm by BrianS

Slow on the draw
Some of our users were complaining of slow performance on one of our web-based utilities. There are, unfortunately, a number of factors that can affect system performance. I haven’t spent much time learning the best practices for profiling a system to discover the source of bottlenecks, but my hunch was that the problem was in MySQL.

Read the rest of this entry »

Permalink 1 Comment