split database Magento 2.2 not working

[giacomoleopardi]

Hi,

I have installed Magento 2.2 Commerce on my host.

After Istallation, I tried to make the split database. 

 http://devdocs.magento.com/guides/v2.1/config-guide/multi-master/multi-master_masterdb.html

Here the commands done by user root in MySql:

create database magento_quote;
GRANT ALL ON magento_quote.* TO magento_quote@localhost IDENTIFIED BY 'magento_quote';
create database magento_sales;
GRANT ALL ON magento_sales.* TO magento_sales@localhost IDENTIFIED BY 'magento_sales';

Next the commands done with console:

bin/magento setup:db-schema:split-quote --host="172.19.0.4" --dbname="magento_quote" --username="root" --password="magento2"
bin/magento setup:db-schema:split-quote --host="172.19.0.3" --dbname="magento_sales" --username="root" --password="magento2"

Now I have 3 DB:

magento => 424 tables;
magento_quotes => 11 tables;
magento_sale => 0 tables;    :( :(

Why there are not tables inmagento_sale?

Thanks for help!

FC

[Damian Culotta]

Hi @giacomoleopardi,

Just to be sure, are you using Magento Commerce Edition (formerly known as Enterprise Edition), right?

[giacomoleopardi]

Hi Damian,

Yes, I am using Magento 2.2 Commerce (Enterprise Edition).
Can you help me?

Thanks

[Damian Culotta]

Hi @giacomoleopardi,

I will try to replicate the configuration and I'll come back with the result.

[giacomoleopardi]

Thanks @Damian Culotta

[Damian Culotta · Accepted solution]

Hi @giacomoleopardi,

I've tested and everything works fine.

I saw en error on your first post. The second command is wrong.

You've used:

bin/magento setup:db-schema:split-quote --host="172.19.0.4" --dbname="magento_quote" --username="root" --password="magento2"
bin/magento setup:db-schema:split-quote --host="172.19.0.3" --dbname="magento_sales" --username="root" --password="magento2"

The second one is wrong. It should be:

bin/magento setup:db-schema:split-quote --host="172.19.0.4" --dbname="magento_quote" --username="root" --password="magento2"
bin/magento setup:db-schema:split-sales --host="172.19.0.3" --dbname="magento_sales" --username="root" --password="magento2"

You've used split-quote 2 times and never executed the spilt-sales command.

I guess your only problems is there.

I got the environment running with 3 databases (inside the same mysql server, but there are 3 databases and Magento is running).

[giacomoleopardi]

Now it works!

Thanks so much!