Myself and several of the clients that I work with use the web hosting services of Zen Internet, based nearby in sunny Rochdale.
I’ve been a Zen customer for around two years now, and cannot fault them on either reliability, customer service, or technical support. PC Pro magazine agrees, awarding them Best ISP for 2010, the seventh consecutive time Zen have won this award. And perhaps this would be a good example of why…
I was recently asked to help migrate several client websites from another hosting company’s dedicated server, over to a new Zen shared hosting account. More often than not, this would be fairly straightforward. However, one of the websites included an application for agents and franchisees to manage projects, and the database for this particular application included a MySQL Trigger. Problem was that the insertion of MySQL Triggers apparently requires the user to have Super privileges, which would be no problem on a dedicated server but understandably Zen could not allow individual users to have Super privileges on a shared hosting environment.
Following a bit of time learning more about MySQL Trigger problems, and considering alternative solutions, I decided to email Zen and ask if they could insert the Trigger into the database on my behalf, also defining Trigger (but not Super) privileges for a specific database user. I didn’t hold out much hope, and their initial response wasn’t too promising but they said they would look into it. Amazingly, after another couple of emails back and forth, Zen say the jobs a goodun!
I’ve had dealings with dozens of hosting providers over the years, and reckon I can safely say that very few if any would have taken this on, or would have resolved it so quickly. Most likely I’d have spent hours on hold or in a queue for technical support, and then ended up trying to explain the issue to someone who knew even less about it than I initially did.
Nice one Zen!
Read more →