0

I have a Web-application on a Linux Debian 8 Server saving in MySQL.

I need a backup which is always the latest version(not even a minute behind) so the only way i could think off to archive this is to execute every Query on a second MySQL server with identical database

Is there a way to do this without my Application having to handle this?

M41DZ3N
  • 103
  • 2
  • Have you checked MySQL Proxy (from oracle) and SQL Relay http://sqlrelay.sourceforge.net/documentation.html. Both can be setup in a way to send the query to a second server. – zeridon Oct 16 '15 at 08:55
  • unfortunately it is not available for Debian, but "Query Routing" mentioned is exactly what i'm looking for – M41DZ3N Oct 16 '15 at 09:04
  • 2
    what about mysql replication? – Martynas Saint Oct 16 '15 at 09:39
  • then i had to read from the slave and insert into the master but i cant "touch" the application – M41DZ3N Oct 16 '15 at 09:52
  • if you are careful - you can have master/master replication. also maybe proxysql can help, though it probably is not available with debian packages – Martynas Saint Oct 16 '15 at 09:59

0 Answers0