DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(mysql.info.gz) MySQL Cluster Single User Mode

Info Catalog (mysql.info.gz) MySQL Cluster Event Reports (mysql.info.gz) MySQL Cluster Management (mysql.info.gz) MySQL Cluster Backup
 
 16.5.3 Single User Mode
 -----------------------
 
 Single user mode allows the database administrator to restrict access
 to the database system to only one application (API node).  When
 entering single user mode all connections to all APIs will be
 gracefully closed and no transactions are allowed to be started.  All
 running transactions are aborted.
 
 When the cluster has entered single user mode (use the all status
 command to see when the state has entered the single user mode), only
 the allowed API node is granted access to the database.
 
 Example:
      ENTER SINGLE USER MODE 5
 
 After executing this command and after cluster has entered the single
 user mode, the API node with node id 5 becomes the single user of the
 cluster.
 
 The node specified in the command above must be a MySQL Server node.
 Any attempt to specify any other type of node will be rejected.
 
 Note: if the node with id 5 is running when executing `ENTER SINGLE
 USER MODE 5', all transactions running on node 5 will be aborted, the
 connection is closed, and the server must be restarted.
 
 The command `EXIT SINGLE USER MODE' alters the state of the cluster DB
 nodes from "single user mode" to "started".  MySQL Servers waiting for
 a connection, i.e. for the cluster to become ready, are allowed to
 connect.  The MySQL Server denoted as the single user continues to run,
 if it is connected, during and after the state transition.
 
 Example:
      EXIT SINGLE USER MODE
 
 Best practice in case of node failures when running in single user mode
 is to:
 
   1. Finish all single user mode transactions
 
   2. Issue the command exit single user mode
 
   3. Restart database nodes
 
 Or restart database nodes prior to entering single user mode.
 
Info Catalog (mysql.info.gz) MySQL Cluster Event Reports (mysql.info.gz) MySQL Cluster Management (mysql.info.gz) MySQL Cluster Backup
automatically generated byinfo2html