Difference between revisions of "Install MySQL"
| Line 7: | Line 7: | ||
For versions of the Fusion Registry from version 11 onwards, MySQL version 8 may be used. | For versions of the Fusion Registry from version 11 onwards, MySQL version 8 may be used. | ||
| − | |||
=Installing MySQL 5.7= | =Installing MySQL 5.7= | ||
| Line 22: | Line 21: | ||
It's usual to give the schema a name like <code>fusion_registry</code>, but there's no restrictions so call it what you like. You'll tell Fusion Registry the name of the schema to use during the install process. | It's usual to give the schema a name like <code>fusion_registry</code>, but there's no restrictions so call it what you like. You'll tell Fusion Registry the name of the schema to use during the install process. | ||
| + | |||
| + | =Troubleshooting MySQL= | ||
Revision as of 13:34, 23 May 2022
Contents
Overview
Fusion Registry needs an operating database to store the structural metadata, configuration settings and other operating information like audit logs. MySQL, Oracle and SQL Server are supported. If you already have one of those services available, use that and simply create a new schema for Fusion Registry to use.
For versions of the Fusion Registry up to version 11, the MySQL database or eqivalent services like MariaDB must be MySQL 5.7 compatible.
For versions of the Fusion Registry from version 11 onwards, MySQL version 8 may be used.
Installing MySQL 5.7
Download and install MySQL 5.7 Community.
Creating the Fusion Registry schema
We recommend that you create a dedicated schema for Fusion Registry to use. You can do that using the mysqlsh command line interface, but a simple option is to install the MySQL Workbench which provides a graphical user interface for Windows users.
MySQL Workbench GUI
Download and install MySQL Workbench.
Using MySQL Workbench, connect to your MySQL database service and create a new schema. There's a button on the toolbar to do that.
It's usual to give the schema a name like fusion_registry, but there's no restrictions so call it what you like. You'll tell Fusion Registry the name of the schema to use during the install process.
