cancel
Showing results for 
Search instead for 
Did you mean: 

split database Magento 2.2 not working

SOLVED

split database Magento 2.2 not working

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

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: split database Magento 2.2 not working

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).

View solution in original post

6 REPLIES 6

Re: split database Magento 2.2 not working

Hi @giacomoleopardi,

 

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

Re: split database Magento 2.2 not working

Hi Damian,

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

Thanks

Re: split database Magento 2.2 not working

Hi @giacomoleopardi,


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

Re: split database Magento 2.2 not working

Thanks @Damian Culotta

Re: split database Magento 2.2 not working

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).

Re: split database Magento 2.2 not working

Now it works!

Thanks so much!