GridSQL set-up on a database other than PostgreSQL

Hi,

I am interested in setting up Grid SQL against a JDBC complaint database that has most of the ANSI-92 SQL support. Any information in this regard is appreciated.

Thanks,

-Venks

This message was edited 1 time. Last update was at 08/12/2008 10:25:24

Hi Venks,

GridSQL is targeted towards PostgreSQL, but you can run it against other databases.

There are a myriad of configurable settings in the gridsql.config file that are mostly documented in the Admin Guide. You can also map data types, SQL statement syntax and more. The most important thing as far as performance is concerned is row shipping and loading. For that, you want to set xdb.loader.nodewriter.use_edb_jdbc_copy to false and override xdb.loader.nodewriter.template to use the particular database's bulk loading facility. For some databases that don't take STDIN as input, you'll have to write a wrapper script.

There will be a lot of things to override, like xdb.gateway.createdb, xdb.gateway.dropdb, and various other settings depending on the RDBMS behavior, like xdb.sort.trim and xdb.sort.case.sensitive, but you can get far with the existing configuration options without having to resort to modifying the code. You will probably end up needing to change 30-40+ settings to get it to work properly.

Anyway, I encourage you to consider PostgreSQL for you solution. You can use PostgreSQL's constraint exclusion partitioning and range partition into smaller subtables, and have each of these spread out across multiple nodes in the GridSQL cluster.

Good luck,

Mason

Mason,

Thanks for your reply. I will check out all the configuration parameters. I am hoping that updating the necessary configuration parameters is enough to make it work. At this stage I don't think it's worth while to look into code changes (either Java or the scripts). I understand PostgreSQL would work fine and is the default choice, but it may be enough for the performance that I would like to achieve. I will keep you posted and I look forward to depend on your valuable input/feedback/guidance as I try to evaluate GridSQL.

Thanks,

-Venks

Hi Venkats,

I don't think you will need to change the scripts. They do need to refer to the JDBC driver jar of your RDBMS, but if you set CLASSPATH in your environment, it will find it.

Thanks,

Mason