Skip to main content
Version: 0.0.20

AWS Route53 Hosted Zones

Install the AWS Route53 module for hosted zones. Read more about AWS Route53 hosted zones here.

SELECT * FROM iasql_install('aws_route53_hosted_zones');

Create a hosted zone

Create a hosted zone and new record within it. Finally, apply it.

INSERT INTO hosted_zone (domain_name)
VALUES ('iasqlsample.com');

INSERT INTO resource_record_set (name, record_type, record, ttl, parent_hosted_zone_id)
SELECT 'test.iasqlsample.com', 'CNAME', 'example.com.', 300, id
FROM hosted_zone
WHERE domain_name = 'iasqlsample.com';

SELECT * FROM iasql_apply();

Check default record sets have been added

Join over the hosted_zone and resource_record_set tables.

SELECT *
FROM resource_record_set
INNER JOIN hosted_zone ON hosted_zone.id = parent_hosted_zone_id
WHERE domain_name = 'iasqlsample.com';