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?

I can not run mysql slaves in different
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: I can not run mysql slaves in different
#9553
I can not run mysql slaves in different 12 Years, 9 Months ago Karma: 0
Hey. I've installed and configured JMS. Works well when slaves working in the same mysql master. But I can not master tables that are stored in other different database.
Just save the first 15 tables ad_agency component but there is left and continue past the tables.

The error I get: Fatal error:
Allowed memory size of 67108864 bytes exhausted (tried to allocate 64 bytes) in / home / midiario / public_html / (dominio.com) / libraries / joomla / database / database / mysql.php on line 462
vendedorcomercial@hotmail.com
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#9564
Re: I can not run mysql slaves in different 12 Years, 9 Months ago Karma: 54
As the message tells you, it seems that you don't have enought memory to replicate the website.
When you have have website with different DB and different MySQL user for each DB and that you don't have a shared MySQL user that is able to access both DB then JMS perform sequential read from 1 DB and write into the DB. So you need memory to read/write the DB content.
Otherwise, the replication is done by MySQL.

So check the PHP memory size.
If you have a small value like 32M or 64M, perhaps you need to increase it.
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