Support

Admin Tools

#23945 AdminTools in master-slave replication sites

Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket

Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.

Environment Information

Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a

Latest post by nicholas on Thursday, 17 December 2015 02:11 CST

febchk
 I replicate a Joomla site with master-slave replication.

The site is mostly read-only so normally there is no write operation at slave. When AdminTools at the slavve gets security exception or autoban it writes to table admintools_log and others, which causes database replication fail.

How do I avoid this problem in such an environment? Do I configure ignore-table at replication so that AdminTools at master and slave do not step over each other?

I also synchronize the sites with rsync and I exclude logs, cache and tmp folders. Do I need to take measures in regards of AdminTools?

nicholas
Akeeba Staff
Manager
I'm afraid you can't. It is not an issue specific to Admin Tools. What you describe would require a special Joomla! database driver that uses different servers for read and write operations. Admin Tools DOES need to be able to write to its tables to operate correctly (it needs a way to keep track of security exceptions to block attackers).

Nicholas K. Dionysopoulos

Lead Developer and Director

🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!

Support Information

Working hours: We are open Monday to Friday, 9am to 7pm Cyprus timezone (EET / EEST). Support is provided by the same developers writing the software, all of which live in Europe. You can still file tickets outside of our working hours, but we cannot respond to them until we're back at the office.

Support policy: We would like to kindly inform you that when using our support you have already agreed to the Support Policy which is part of our Terms of Service. Thank you for your understanding and for helping us help you!