Setting Default Database Server

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.

In this chapter:

Request Packet Structure

Response Packet Structure

Samples

 

Request Packet Structure

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.

 

Response Packet Structure

The set-default node of the output XML packet is structured as follows:

 

 

Samples

Changing status of a database server

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>

 

Changing status of multiple database servers

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>