Thanks,

I'm using Mysql 4.11 from the ports install on FreeBSD 5.4 and the ndb cluster available with it.

I've set up a table like this :

+-------------+-------------+------+--------+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+--------+---------+-------+ | data_id | int | NO |Primary | | | | zone | varchar(255)| NO | | | | | host | varchar(255)| NO | | | | | type | varchar(255)| NO | | | | | data | varchar(255)| | | | | | ttl | int(11) | YES | | NULL | | | mx_priority | int(2) | YES | | NULL | | | refresh | int(11) | YES | | NULL | | | retry | int(11) | YES | | NULL | | | expire | int(11) | YES | | NULL | | | minimum | int(11) | YES | | NULL | | | serial | bigint(20) | YES | | NULL | | | resp_person | text | YES | | NULL | | | primary_ns | varchar(255)| YES | | NULL | | +-------------+-------------+------+--------+---------+-------+

I've set up indexes on the zone, host and type column, and load data from it with the following request :

{select zone from dns_records where zone = '%zone%'} {select ttl, type, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') when lower(type) = 'soa' then concat_ws(' ', data, resp_person, serial, refresh, retry, expire, minimum) else data end from dns_records where zone = '%zone%' and host = '%record%'} {} {select ttl, type, host, mx_priority, case when lower(type)='txt' then concat('\"', data, '\"') else data end, resp_person, serial, refresh, retry, expire, minimum from dns_records where zone = '%zone%'}

Where %zone% and %record% are replaced by the actual values when bind serves record (for instance, for a nslookup www.example.com, the %zone% is replaced by'example.com' and the %host% by 'www')

Regards, François

---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program.