-SOLVED- Use Hikeshop tables in another database

  • Posts: 81
  • Thank you received: 0
7 years 8 months ago #264115

-- url of the page with the problem -- : 200mphmedia.net/justducks
-- HikaShop version -- : 3.0.0 BUSINESS
-- Joomla version -- : 3.6.5
-- PHP version -- : 5.6.3
-- Browser(s) name and version -- : All

Our main site uses Database B, in which the primary hikashop is installed.

Because of design variations, the mobile version of the site must use Database A, which also has hikashop installed.

Both are are the same server, same domain.

What we would like to do is:Connect the mobile version installed to the static site hikashop tables.

Goal: Use one hikashop, the main site, on both main and mobile installs.

How can we use the static site hikashop tables on the mobile site version?

Assistance and guidance is appreciated.

Last edit: 7 years 8 months ago by herb200mph.

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13377
  • MODERATOR
7 years 8 months ago #264117

Hi,

There are several solutions I know of:
- You can use views in your MySQL database: stackoverflow.com/questions/10694601/cre...-different-databases
- You could use JMS multisites. That extension handles master/slave websites for such needs. It's the easy solution.
- You could use the replication system of MySQL to replicate the tables from one database to the other: dev.mysql.com/doc/refman/5.5/en/replication.html
- You coul also have a look at this for table replication: www.percona.com/doc/percona-toolkit/2.1/pt-table-sync.html

I would personally recommend using either views or JMS. JMS actually uses views to handle the sharing of data between the master website and slaves. Having views avoid data conflict between both databases which is really important.

Please Log in or Create an account to join the conversation.

  • Posts: 81
  • Thank you received: 0
7 years 8 months ago #264153

Thank you.

We will explore the options suggested.

Please Log in or Create an account to join the conversation.

Time to create page: 0.055 seconds
Powered by Kunena Forum