Hi,
How does piwik behave in case MySQL goes down ?
Does it start logging everything in log files and appends once MySQL is up ?
In our case; the backend failures might lead to loss of tracking and hence some thing like above mentioned feature can help.