background preloader

Mysql

Facebook Twitter

Linux

Migrate from MySQL or PostgreSQL to DB2 Express-C. IBM Data Movement Tool The tool described in this article has been replaced with a new IBM Data Movement Tool.

Migrate from MySQL or PostgreSQL to DB2 Express-C

Please click this link to get the new tool . Back to top. Sphinx - Free open-source SQL full-text search engine. Our product OwnerRez, which helps vacation rental owners manage their properties, is an online SaaS product running on Windows 2008 servers, built in .NET and using MySQL as the database.

Sphinx - Free open-source SQL full-text search engine

We're hosted with a cloud provider, and our development style follows a barebones commodity design - everything should scale easily, systems should never have to wait for other systems to complete, everything should be fast. We needed a full-text search engine so that our users could search their booking, quote and inquiry data with a simple "Google style" one-box. The idea was that a user could have a name or email address, drop it into the one-box and pull up all the records that matched in a fast clean way.

MySQL was the default go-to for fulltext search since that was the DB and the dev team could shoehorn search into it fairly easily. Problems abounded. Fast and scalable sql based mail services. Planet MySQL.