Is WPDataTables compatible with WordPress Multisite?
Would it be possible for me to use WPDatatables to access data from an external MySQL database shared among multisite users, but have the WPDatables tables unique to the individual sites?
Yes it is multisite compatible. You can either network activate it or activate it on the subsite separately. It will create a separate tables for every subsite.Also you can use our built in tools to query results from other tables in the multisite.
To clarify just a bit more - my database is extremely large (about 150 gigabytes and 30 million records).
Does the software duplicate the entire database for each subsite? Can it track only the differences when records are changed by a given subsite? Or could I / should I make the main database read-only but have separate tables unique to each subsite?
If the database is that big my best suggestion would be to use it as main database and connect to it with separate database connection option. This way all the sub-site would have access to the same data and you all the changes will be made on the same data - Documentation
For testing purpose we have sandbox website where you can see and test all plugin functionalities
Hi
Is WPDataTables compatible with WordPress Multisite?
Would it be possible for me to use WPDatatables to access data from an external MySQL database shared among multisite users, but have the WPDatables tables unique to the individual sites?
Hi Richard,
Thank you for your inquire.
Yes it is multisite compatible. You can either network activate it or activate it on the subsite separately. It will create a separate tables for every subsite.Also you can use our built in tools to query results from other tables in the multisite.
Thank you - that is helpful
To clarify just a bit more - my database is extremely large (about 150 gigabytes and 30 million records).
Does the software duplicate the entire database for each subsite? Can it track only the differences when records are changed by a given subsite? Or could I / should I make the main database read-only but have separate tables unique to each subsite?
Hi Richard,
If the database is that big my best suggestion would be to use it as main database and connect to it with separate database connection option. This way all the sub-site would have access to the same data and you all the changes will be made on the same data - Documentation
For testing purpose we have sandbox website where you can see and test all plugin functionalities
sandbox.wpdatatables.com
username: demo
password: demo
Thanks
To clarify - I need the ability for each subsite to be able to have its own private comments and private edits to the data.
In that case, do I need to clone the database for each subsite? If so, how do I distribute new records which are to be shared by all of the sites?