dbinfo — For LiveJournal installations with many databases, the database connection info, roles, and weightings can be stored in the database instead of the %LJ::DBINFO hash, for easier (web-based) management.
| 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 |