Results 1 to 2 of 2

Thread: MySQL++

  1. #1
    Join Date
    Nov 2009
    Posts
    4

    Unanswered: MySQL++

    I'm developing an application which connects to a MySQL server.

    My quesiton is:
    Is there any option that when the server is down, my INSERT queries, will be saved in a buffer, and when the server is back online, the buffer will be executed into the server?

    Any ideas? is this linked to MySQL Proxy in some way?


    Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Im not aware of anything like that built into MySQL, but presumably its easy enough to write those queries to a flat fiel, and then red 'em back from the file when the server is active again. you'd need to be leetle bit clever about file locks. I suppose you could go for a slightly more refined approach, each task write to its own timestamped file. then you have a periodic task, say a cron job or windows scheduler, which picks up all those individual files and stuffs 'em into a single file and deltes the individual files, then tries to execute those statements, if they succeed the big file is killed, if not the big file stays there til they do succeed
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •