Skip to content

Latest commit

 

History

History
43 lines (22 loc) · 1.3 KB

mysql_remove.rst

File metadata and controls

43 lines (22 loc) · 1.3 KB
Raw

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: /advanced/hierarchy/databases/postgres_install
  • 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