English (United Kingdom)
Jms Multi Site, formerly joomla multisite.
Create, share multiple joomla sites in few clicks !
Message
  • EU e-Privacy Directive

    This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

    View e-Privacy Directive Documents

Welcome, Guest
Please Login or Register.    Lost Password?

Using sql to update shared tables
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Using sql to update shared tables
#6527
Using sql to update shared tables 13 Years, 10 Months ago Karma: 0
Hi there,

If I use a sql query to update records of a shared table in the master site (e.g. master__users), will it populate the tables for the other sites (sl1_users, sl2_users)? Are the slave tables views of the master or synchronized? I'm trying to understand how sharing works to figure out how to make integration of another component work.

Thanks!
phleum
Fresh Boarder
Posts: 13
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#6534
Re: Using sql to update shared tables 13 Years, 10 Months ago Karma: 54
The sharing is like a shortcut in windows.
When you create a shortcut on a folder, this create an alias on the physical (real folder).
This is the same with the "link" we create in MySQL.
The data is present only once in the DB and therefore whereever you update the content, it is automatically available by all the websites as the data is not duplicated but just linked. This is the reason why we don't need to synchronize as we are sharing the data.
edwin2win
Moderator
Posts: 5370
graph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
get the latest posts directly to your desktop
2Win, Multisite(s) are trademarks of Edwin2Win.
Joomla