Hi,
You should check pt-archiver.
http://www.percona.com/doc/percona-toolkit/pt-archiver.html
"The goal is a low-impact, forward-only job to nibble old data out of the table
without impacting OLTP queries much."
This tool can copy data and insert in another table in chunks of data. The
destin
Hi,
http://bugs.mysql.com/bug.php?id=42039
"The --with-mysqld-libs option should be given an argument, something
like --with-mysqld-libs="-L/path/to/lib -lfoo -lbar"
2009/12/27 Kurian Thayil :
> Hi All,
>
> I was trying to compile MySQL 5.1.41 in a Fedora 12 box. I don't want to do an
> RPM ins
Hi,
> I am getting "Can't execute the given command because you have active locked
> tables or an active transaction" error when I am trying to truncate table. I
> am unable to understand the error as when I am using the mysql query browser
> then the same command is working fine but when I am doi
Hi,
MySQL replicate the databases at SQL level, so if the two servers are
using the same engine (innodb), they will be replicated without
problems.
If the BLOB data is big, don't configure the replication over a WAN or
you will get too much latency (of course, it depends on your
bandwidth).
2009
> Load balancing, or high availability?
>
> I do not think there is anything good and simple AND generic out of
> the box. As previous posters have noted, you generally have to build
> something on top of other tools.
Hi,
I have the HA solved with MMM. Now, I want load balacing, sending read
que
Hi,
El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón
escribió:
> 2009/12/21 Miguel Angel Nieto :
>> Hi,
>>
>> I am searching fot a Mysql Load Balacing tool. I read about mysql
>> proxy, sqlrelay, haproxy...
>>
>> What do you prefer?
>
> Hi,
Hi,
I am searching fot a Mysql Load Balacing tool. I read about mysql
proxy, sqlrelay, haproxy...
What do you prefer?
What are the benefits and bugs?
:)
Thank you.
--
Lo que haría sería hacerme pasar por sordomudo y así no tendría que
hablar. Si querían decirme algo, tendrían que escribirlo
