Removing xcatdb from MySQL/MariaDB

If you no longer want to use MySQL/MariaDB to maintain xcatdb, and like to switch to PostgreSQL or just default SQLite ( Note: SQLite does not support xCAT Hierarchy (has service nodes)), use the following documentation as guide to remove xcatdb.

  • Run a backup of the database to save any information that is needed (optional):

    mkdir -p ~/xcat-dbback
    dumpxCATdb -p ~/xcat-dbback
    

    If you want to restore this database later:

    XCATBYPASS=1 restorexCATdb -p ~/xcat-dbback
    
  • To switch to PostgreSQL, follow: Install PostgreSQL

  • To switch to default xCAT database, SQLite (Note: xCAT Hierarchy cluster will no longer work):

  1. Stop the xcatd daemon on the management node.

    service xcatd stop
    
  2. Remove the xatdb from MySQL/MariaDB (optional):

    /usr/bin/mysql -u root -p
    

    drop the xcatdb:

    mysql> drop database xcatdb;
    

    remove the xcatadm database owner :

    mysql> drop user xcatadm;
    
  3. Move, or remove, the /etc/xcat/cfgloc file as it points xCAT to MySQL/MariaDB. (without this file, xCAT defaults to SQLite):

    rm /etc/xcat/cfgloc
    
  4. Restart xcatd:

    service xcatd start