Configure a Database

SQLite

xCAT uses the SQLite database (https://www.sqlite.org/) as the default database and it is initialized during xCAT installation of the Management Node. If using Service Nodes, SQLite cannot be used because Service Nodes require remote access to the xCAT database. One of the following databases should be used:

• MySQL/MariaDB
• PostgreSQL

MySQL/MariaDB

• Install MySQL/MariaDB
  • Red Hat Enterprise Linux
  • Suse Linux Enterprise Server
  • Debian/Ubuntu
• Configure MySQL/MariaDB
  • Migrate xCAT to use MySQL/MariaDB
  • Granting/Revoking access to the database for Service Node Clients
• Using MySQL/MariaDB
  • Start/Stop MySQL/MariaDB service
  • Basic MySQL/MariaDB commands
• Removing xcatdb from MySQL/MariaDB

PostgreSQL

• Install PostgreSQL
  • Red Hat Enterprise Linux
  • Suse Linux Enterprise Server
  • Debian/Ubuntu
• Configure PostgreSQL
  • Migrate xCAT to use PostgreSQL
  • Setting up the Service Nodes
  • Modify PostgreSQL database directory
• Using PostgreSQL
  • Useful Commands
• Removing xcatdb from PostgreSQL and restoring data into SQLite