Re: Mysql backup for large databases

2012-11-02 Thread Manuel Arostegui
Hello, Just one more suggestion to do full backups in large databases: - Dedicated slave (either physical machine, a disk cabinet using iscsi connections from a machine just with a bunch of RAM etc) - Get the slave delayed a certain time (ie: 1 hour, 2 hours...depends on your workload) using

Re: Mysql backup for large databases

2012-11-02 Thread Karen Abgarian
Hi... Quite often, they create a replica for the purposes of switching to it immediately if the master completely fails. I like the idea of taking backups on that replica, and not create another replica just for doing backups. One reason why I like it is that if I am to recover a

RE: MySQL Thread Pool Plugin + Percona Server?

2012-11-02 Thread Rick James
(I'm not using such.) Would you explain what your application is doing that would push the limits of thread concurrency? -Original Message- From: Singer Wang [mailto:w...@singerwang.com] Sent: Wednesday, October 31, 2012 2:08 PM To: mysql@lists.mysql.com Subject: MySQL Thread Pool