dbinfo

dbinfo — Global. Stores database connection and replication info, instead of in the %LJ::DBINFO hash, for easier (web-based) management of LiveJournal installations with many databases.

dbinfo

Column name Type Null Default Description
dbid tinyint unsigned   0 Unique database ID. Recommended to use the mysql server-id value.
name varchar(25) YES A unique name of the server.
fdsn varchar(255) YES The DBI connection DSN, username, then password, delimited by pipe characters.
rootfdsn varchar(255) YES The fdsn to connect as root, to do administrative stuff.
masterid tinyint unsigned   0 The dbid which this server replicates from, or 0 for the master server. Note: only one server should have a master of 0!
Key name Type Column(s)
PRIMARY PRIMARY
name UNIQUE