skip-name-resolve to speed up MySQL and avoid problems

MySQL

MySQL Reverse DNS took us all day to debug and before reinstalling MySQL on another server guy who had this problem told us the solution: skip-name-resolve skip-name-resolve Problem After searching the net I’ve found that by default MySQL grants authentication on users based on IP address or hostnames. When there is a connection from a particular host, MySQL does a ...

Read More »

Site-to-Site IPSec VPN using Mikrotik Routers

VPN Tunnels

Some time ago i had a client that needed Site-to-Site IPSec VPN connection between 5 locations but ware not ready to pay for Cisco routers. So it was time to my favorite cheep but reliable solution Mikrotik. They didn’t need any special requirements, on the main location they had a server with a application and a on the other locations ...

Read More »

MySQL Full-Text Search with Multiple words

MySQL

Few weeks ago i had a project where i needed to search a large database and provide results based on their relevance. The answer was MySQL Full-Text Search. Normaly i have started coding and used the LIKE finction in MySQL to get the results and started testing on a small temporary database that i’ve created. After some part of the ...

Read More »