Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 27th January 2012, 10:57
Blackbit Blackbit is offline
Junior Member
 
Join Date: Feb 2011
Posts: 11
Thanks: 3
Thanked 4 Times in 3 Posts
Question sys_datalog after successfull replication

Hi!

Do you think there's any reason why the clients should not clear the entry from the master sys_datalog after the successfull replication?

I patched the file server/lib/classes/modules.inc.php to do after the replication. Like this:

Code:
if($app->db->errorNumber > 0) {
	$replication_error = true;
	$app->log("Replication failed. Error: (" . $d[dbtable] . ") in MySQL server: (".$app->db->dbHost.") " . $app->db->errorMessage . " # SQL: " . $sql,LOGLEVEL_ERROR);
} else {
	$app->log('Replicated from master: '.$sql,LOGLEVEL_DEBUG);
	$app->dbmaster->query("DELETE FROM sys_datalog WHERE datalog_id = ".$d["datalog_id"]);
	$app->log("Deleting sys_datalog ID ".$d["datalog_id"]." on master",LOGLEVEL_DEBUG);
}
Reply With Quote
Sponsored Links
  #2  
Old 27th January 2012, 11:25
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,792
Thanks: 821
Thanked 5,338 Times in 4,188 Posts
 
Default

There are several reasons why the entrys are kept for 30 days in the system:

1) A server can have more then one slave replicating the same records (mirror), if you delete records immedeately, then the other slaves cant replicate them anymore or will only partially replicate them. The current system ensures that all slave servers get back in sync automatically even if a slave is offline for some days.

2) The sys_dalaog is kept as detailed action log for every action that ISPConfig has done so that the administrator can reproduce problems and can investigate actions done by its users or clients.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
Blackbit (27th January 2012)
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
My SQL Replication issue ? jithinkcs Server Operation 5 10th September 2010 16:47
MYsql replication questions. scottrill2 Server Operation 7 3rd September 2010 17:53
I've lose the mysql master-master replication of ISPConfig voltron81 Installation/Configuration 6 2nd September 2010 09:04
Master Master replication questions and problems marchost HOWTO-Related Questions 5 4th October 2008 13:50
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59


All times are GMT +2. The time now is 23:33.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.