Glastopf

my ideas for central db all users running a glastopf may use:

in glastopf.cfg:

[glasmaster]
enabled: True
masterhost: 192.168.1.141
masterport: 2306
masteruser:
masterpass:
masterdb: glasmaster
topf_name: testing #unique name in glasmaster.toepfe

structure (pls discuss)

/*
[[MySQL]] Backup
Source Host:           192.168.1.141
Source Server Version: 5.0.27
Source Database:       glasmaster
Date:                  2009.03.24 20:37:24
*/

use glasmaster;
SET FOREIGN_KEY_CHECKS=0;
#----------------------------
# Table structure for toepfe
#----------------------------
drop table if exists toepfe;
CREATE TABLE @toepfe@ (
  @id@ int(11) NOT NULL auto_increment,
  @name@ varchar(255) default NULL,
  @server_ip@ varchar(128) NOT NULL,
  PRIMARY KEY  (@id@),
  UNIQUE KEY @name_index@ (@name@)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
#----------------------------
# Records for table toepfe
#----------------------------
insert  into toepfe values (1, 'trunk', '192.168.1.150') ;
insert  into toepfe values (2, 'testing', '192.168.1.167') ;
#----------------------------
# Table structure for log
#----------------------------
drop table if exists @log@;
CREATE TABLE @log@ (
  @id@ int(11) NOT NULL auto_increment,
  @topf_id@ int(11) NOT NULL,
  @domain@ varchar(255) NOT NULL default _,
  @ip@ varchar(15) NOT NULL default _,
  @attime@ datetime NOT NULL default '0000-00-00 00:00:00',
  @tzone@ varchar(5) NOT NULL default '+0000',
  @req@ varchar(255) NOT NULL default _,
  @ref@ varchar(255) NOT NULL default _,
  @agent@ varchar(255) NOT NULL default _,
  @count@ int(11) NOT NULL default '1',
  @filename@ varchar(32) NOT NULL default 'once_unknown',
  @victim@ varchar(255) NOT NULL,
  PRIMARY KEY  (@id@)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;
#----------------------------
# No records for table log
#----------------------------

insert into master db parallely to the existing db queries

greetz,

kat