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?

  • Have you checked MySQL Proxy (from oracle) and SQL Relay 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 8:55
  • unfortunately it is not available for Debian, but "Query Routing" mentioned is exactly what i'm looking for – M41DZ3N Oct 16 '15 at 9:04
  • 2
    what about mysql replication? – Martynas Saint Oct 16 '15 at 9: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 9: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 9:59

Your Answer

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.