Hi, in this particular case there is only one master without any slaves.
;) On Mon, Nov 18, 2013 at 11:05 PM, Andrew Cassidy < [email protected]> wrote: > Perhaps a master/slave setup is in order? At least that way you can make it > look to a read-only copy for the backups without affecting the site too > much. > > > On 18 November 2013 21:39, Florian Effenberger < > [email protected]> wrote: > > > Hi, > > > > we're currently running a larger SQL database backup, which exceeds the > > currently allowed amount of parallel connections. > > > > Given that SQL right now uses about 30 GB (!) of RAM, I can't extend the > > number of allowed connections further right now, so we have to wait until > > the backup is finished. (It's 10:30 pm here, but I'm awake for a while, > so > > if it lasts too long, I will kill it to bring back the website.) > > > > Mid-term solution is to get stronger hardware, or at least put the SQL > > server on a different machine. I'm still looking into what is causing the > > high load. We know since when the problems occur, but sadly, it's not > clear > > what _what_ causes the high load - the database size seem to have grown > > massively, and first investigations look like Piwik is using it heavily. > I > > will check with Cloph to see if that is true. > > > > Note that neither internal nor external e-mails, nor mailing lists, nor > > the download per se is affected. > > > > Sorry for the inconveniences, > > Florian > > > > -- > > To unsubscribe e-mail to: [email protected] > > Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to- > > unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/website/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > > -- > *Andrew Cassidy BSc (Hons) MBCS SSCA* > Managing Director > > > *T <[email protected]> *03300 100 960 *F > <[email protected]> *03300 100 961 > *E <[email protected]> *[email protected] > *W <[email protected]> *www.cassidywebservices.co.uk > > -- > To unsubscribe e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/website/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/website/ All messages sent to this list will be publicly archived and cannot be deleted
