On each slave I have a database, radius, which holds auth info and accounting info for each user. I want to limit the accounting info on the slave servers as the tables grow very large, very fast. I would like to move the accounting info over a week old onto the master server for historical use. But I do not want to update the auth info on the slave servers, it would be better to have a single point to update, delete, insert auth info such as the master.
In a nutshell I want,
MASTER.authinfo -> SLAVE.authinfo SLAVE.accounting -> MASTER.accounting delete SLAVE.accounting
I believe the best solution would be to replicate auth info from the master to the slaves using,
--replicate-do-db=radius --replicate-ignore-table=radius.radacct
This would replicate only the radius db, and ignore the radius.radacct table correct? (there are hundreds of DB on this master)
Then I can move the accounting data back to the master by running,
[on the slave] SELECT * INTO OUTFILE '/file/path' FROM radius.radacct (records to keep) DELETE FROM radius.radacct WHERE (records to DELETE)
[on the master] (ftp the outfile from slave to master) LOAD DATA LOCAL INFILE '/file/path' REPLACE INTO TABLE radius.radacct
Does this sound right or am I making this too complicated?
Thanks.
DAve
Gleb Paharenko wrote:
Hello. See:
http://dev.mysql.com/doc/mysql/en/Replication_Options.html Dave Goodrich <[EMAIL PROTECTED]> wrote:Good morning,
Been reading through the docs and checking online info and I m still looking for a answer. I have a radius DB on two radius servers and I want to sync them via a master server. Seems easy enough, but I have one table which holds accounting data. How long a user has been online, when they logged on, when they logged off. This data is sent to the slave servers by the auth equipment.
Is it possible to only replicate a *table* to a slave and not the entire DB?
Thanks,
DAve
-- Systems Administrator http://www.tls.net Get rid of Unwanted Emails...get TLS Spam Blocker!
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
