Отказано в доступе: невозможно настроить кластер Sandbox InnoDB в Windows 10 с помощью установщика MySQL
Под
High Availability
я выбралInnoDB Cluster
и выбралиSet Up a Local Server Cluster for Testing Only
.За
Cluster Log Verbosity Level
я выбралDEBUG
.В
InnoDB Cluster Size
был установлен на3 MySQL Server Sandbox Instances
. Я также предоставилMySQL Root Password
Под
Authentication Method
Я выбралUse Strong Password Encryption for Authentication
.
Под Apply Configuration
вот где проблема начинается:
Preparing administrative tools for InnoDB Cluster
ПРОШЛОDeleting existing sandbox innoDB cluster
ПРОШЛОCreating sandbox InnoDB cluster instances
ПРОШЛОConfiguring sandbox InnoDB cluster
НЕ УДАЛОСЬ
LOG:
Beginning configuration step: Configuring sandbox InnoDB cluster (check the Log tab for details)
Configuring sandbox InnoDB cluster...
Setting up InnoDB cluster...
A new InnoDB cluster will be created on instance 'localhost:3310'.
Validating instance configuration at localhost:3310...
Please note that sandbox instances are only suitable for deploying test clusters for use within the same host.
NOTE: Instance detected as a sandbox.
This instance reports its own address as 127.0.0.1:3310
Instance configuration is suitable.
NOTE: Group Replication will communicate with other members using '127.0.0.1:33101'. Use the localAddress option to override.
Creating InnoDB cluster 'sandboxCluster' on '127.0.0.1:3310'...
Adding Seed Instance...
Cluster successfully created. Use Cluster.addInstance() to add MySQL instances.
At least 3 instances are needed for the cluster to be able to withstand up to
one server failure.
Waiting until seed instance reaches ONLINE status.
Failed to create the InnoDB cluster. Message: Cluster.addInstance: Argument #1: Invalid URI: Illegal character [|] found at position 6 at C:\Users\msode\AppData\Local\Temp\de6f7c87-819f-4428-b049-ea0cdd667508\innodbclusteradmin\bin\ic.js:309:6
Seed instance reached ONLINE status.
in throw ("Failed to create the InnoDB cluster. Message: " +
Adding instances to the cluster...
^
Setting the recovery method to clone.
An error occurred while configuring the sandbox InnoDB cluster.
Deleting the production InnoDB cluster administrative tools temporary directory...
An error occurred trying to dele the InnoDB cluster administrative tools temporary directory after 3 attempts:
The process cannot access the file 'C:\Users\msode\AppData\Local\Temp\de6f7c87-819f-4428-b049-ea0cdd667508\innodbclusteradmin\bin' because it is being used by another process.
Ended configuration step: Configuring sandbox InnoDB cluster (check the Log tab for details)
Две ключевые проблемы (я предполагаю) из приведенного выше ЖУРНАЛА:
1. Failed to create the InnoDB cluster. Message: Cluster.addInstance: Argument #1: Invalid URI: Illegal character [|] found at position 6 at C:\Users\msode\AppData\Local\Temp\de6f7c87-819f-4428-b049-ea0cdd667508\innodbclusteradmin\bin\ic.js:309:6
2. An error occurred trying to dele the InnoDB cluster administrative tools temporary directory after 3 attempts:
The process cannot access the file 'C:\Users\msode\AppData\Local\Temp\de6f7c87-819f-4428-b049-ea0cdd667508\innodbclusteradmin\bin' because it is being used by another process.
Вот что я обнаружил с Process Explorer
а также Resource Monitor
:
ATTEMPT-1
cmd.exe > conhost.exe > mysqld.exe (path: Access Denied)
ATTEMPT-2
cmd.exe > conhost.exe > mysqld.exe (path: Access Denied)
ATTEMPT-3
cmd.exe > conhost.exe > mysqld.exe (path: Access Denied)
Как я могу исправить эту проблему?