mysql_pitr_restorable_windows

Creates, updates, deletes, gets or lists a mysql_pitr_restorable_windows resource.

Overview

Name	mysql_pitr_restorable_windows
Type	Resource
Id	railway.storage.mysql_pitr_restorable_windows

Fields

The following fields are returned by SELECT queries:

get

One MysqlPitrRestorableWindow row.

Name	Datatype	Description
archive_configured	boolean
ceiling_at	string
fetched_at	string
floor_at	string
full_backup_count	integer
full_backups_taken_at	array
lineage_count	integer
listing_truncated	boolean

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get	select	environment_id, service_id		The point-in-time window a MySQL service's binlog archive can restore to, resolved from the archive bucket: the oldest full backup (floor), the newest shipped binlog (ceiling) and every full backup's timestamp. archiveConfigured is false when the service carries no complete BINLOG_ARCHIVE_* contract. Backed by the Railway GraphQL query mysqlPitrRestorableWindow.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
environment_id	string
service_id	string

SELECT examples

get

The point-in-time window a MySQL service's binlog archive can restore to, resolved from the archive bucket: the oldest full backup (floor), the newest shipped binlog (ceiling) and every full backup's timestamp. archiveConfigured is false when the service carries no complete BINLOG_ARCHIVE_* contract. Backed by the Railway GraphQL query mysqlPitrRestorableWindow.

SELECT
archive_configured,
ceiling_at,
fetched_at,
floor_at,
full_backup_count,
full_backups_taken_at,
lineage_count,
listing_truncated
FROM railway.storage.mysql_pitr_restorable_windows
WHERE environment_id = '{{ environment_id }}' -- required
AND service_id = '{{ service_id }}' -- required
;