A default database server manages all databases of the corresponding type. Only one default database server for each type of databases is available in Plesk. Use the set-default operation to set a database server as default.
A request XML packet setting a default database server includes the set-default operation node:
<packet>
<db_server>
<set-default>
...
</set-default>
</db_server>
</packet>
The set-default node has the following graphical representation:
Note: You can set only one default database server for each type of databases.
Remarks
You can set multiple database servers as default in a single packet. Add as many set-default operations as the number of database servers which status is to be changed.
<db_server>
<set-default>
...
</set-default>
...
<set-default>
...
</set-default>
</db_server>
Important: When creating request packets, put nodes and elements in the order they follow in the packet structure.
The set-default node of the output XML packet is structured as follows:
database_output.xsd
).
Upon supposition that the type of remote database server with ID 1 is mysql, the following request packet sets the database server as default for managing MySQL databases.
<packet>
<db_server>
<set-default>
<id>1</id>
</set-default>
</db_server>
</packet>
Response:
<packet>
<db_server>
<set-default>
<result>
<status>ok</status>
<id>1</id>
</result>
</set-default>
</db_server>
</packet>
If the database server with ID 1 was not found on the server, the response looks as follows:
<packet>
<db_server>
<set-default>
<result>
<status>error</status>
<errcode>1013</errcode>
<errtext>Database server does not exist.</errtext>
</result>
</set-default>
</db_server>
</packet>
This packet sets the remote database server with ID 1 and local Microsoft SQL database server as default for MySQL and Microsoft SQL databases correspondingly.
<packet>
<db_server>
<set-default>
<id>1</id>
</set-default>
<set-default>
<type>mssql</type>
</set-default>
</db_server>
</packet>
Response:
<packet>
<db_server>
<set-default>
<result>
<status>ok</status>
<id>1</id>
</result>
</set-default>
<set-default>
<result>
<status>ok</status>
</result>
</set-default>
</db_server>
</packet>