Difference between revisions of "Install MySQL"
m (1 revision imported) |
|||
| Line 1: | Line 1: | ||
[[Category:How_To]] | [[Category:How_To]] | ||
=Overview= | =Overview= | ||
| − | Fusion Registry | + | Fusion Metadata 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 Metadata Registry to use. |
| − | Note that MySQL or | + | Note that MySQL or equivalent services like MariaDB must be MySQL 5.7 compatible. |
[[File:Warning.PNG|30px]] Fusion Registry 10 is not compatible with MySQL 8. | [[File:Warning.PNG|30px]] Fusion Registry 10 is not compatible with MySQL 8. | ||
| Line 12: | Line 12: | ||
Download and install [https://dev.mysql.com/downloads/windows/installer/5.7.html MySQL 5.7 Community]. | Download and install [https://dev.mysql.com/downloads/windows/installer/5.7.html MySQL 5.7 Community]. | ||
| − | =Creating the Fusion Registry schema= | + | =Creating the Fusion Metadata 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. | 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==== | ====MySQL Workbench GUI==== | ||
| Line 21: | Line 21: | ||
[[File:MySQLWorkbench.PNG|200px|thumbnail]] | [[File:MySQLWorkbench.PNG|200px|thumbnail]] | ||
| − | It's usual to give the schema a name like <code> | + | It's usual to give the schema a name like <code>fusion_metsdata_registry</code>, but there's no restrictions so call it what you like. You'll tell Fusion Metadata Registry the name of the schema to use during the install process. |
Revision as of 03:23, 3 November 2020
Contents
Overview
Fusion Metadata 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 Metadata Registry to use.
Note that MySQL or equivalent services like MariaDB must be MySQL 5.7 compatible.
Fusion Registry 10 is not compatible with MySQL 8.
For those without an existing database service, the rest of this guide explains how to install and configure MySQL 5.7 on Windows.
Installing MySQL 5.7
Download and install MySQL 5.7 Community.
Creating the Fusion Metadata 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_metsdata_registry, but there's no restrictions so call it what you like. You'll tell Fusion Metadata Registry the name of the schema to use during the install process.
