Anope IRC Services

Please login or register.

Login with username, password and session length
Advanced search  

News:

Pages: [1]   Go Down

Author Topic: MySQL Sync  (Read 4937 times)

0 Members and 1 Guest are viewing this topic.

Ryan Schaffner

  • Anope User
  • Offline Offline
  • Posts: 11
MySQL Sync
« on: May 26, 2013, 03:37:01 PM »

When using MySQL on a remote server, we are recieving lag due to anope having a poor connection.  Is there a possibility to have and external program that could run crontabbed to upload the data from the db files to mysql without having to enable mysql in the anope program itself.
Logged

Adam

  • Team
  • *
  • Offline Offline
  • Posts: 463
Re: MySQL Sync
« Reply #1 on: May 26, 2013, 04:58:21 PM »

Run mysql on both servers and replicate?
Logged

Ryan Schaffner

  • Anope User
  • Offline Offline
  • Posts: 11
Re: MySQL Sync
« Reply #2 on: May 27, 2013, 05:16:20 AM »

Can't.  one of the servers is a shell acct that doesn't allow mysql db access.  I could run mysql on the server that hosts services, but that defeates the purpose of backup services, as they will only be started when the VPS loses it's connection (very rarely).
Logged

Taylor

  • Contributor
  • *
  • Offline Offline
  • Posts: 100
Re: MySQL Sync
« Reply #3 on: May 27, 2013, 05:25:27 AM »

If you are using mysql only for backup... You could do this based on what I do.

Have your main super stable server running anope, setup a rsync task to run every hour to rsync the .db files to the backup/secondary server with a copy of anope ready to roll.

You could even change how often it runs to like 10 minutes if you're super serious about recent backups.

So if your main server dies, your backup can just be started np.
Logged
Cronus
irc.cncirc.net
http://CnCIRC.net
Pages: [1]   Go Up