On 10/10/07, Ratheesh K J <[EMAIL PROTECTED]> wrote:
> So every morning all the queries will be slow for the first time on the DB
> server 2 and thereafter will be served by the query cache as they will be
> cached and never invalidated until the night.
Sorry for the late reply, I'm trying to ge
Hi,
Ratheesh K J wrote:
@all,
Currently we run all our complex reporting queries on a different
server. We are not using replication though. What we are doing is to
restore the backup of the live data every night onto the reporting
server. So we are running reports on data that is not real time
@all,
Currently we run all our complex reporting queries on a different server. We
are not using replication though.
What we are doing is to restore the backup of the live data every night onto
the reporting server. So we are running reports on data that is not real time.
And we are OK with tha
During Replication the SLAVE reads data from its MASTER's log. Chances
are LOAD DATA gets no logging -- I won't be surprised.
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Friday, February 02, 2007 9:44 AM
To: MySQL List
Subject: Replication & LOAD DAT
I've just performed a LOAD DATA INFILE on the master server, and I've waited
a while now, and the data has not shown up in the SLAVE. Does Replication
not handle LOAD DATA INFILE?
Jesse
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://
Hello List,
Has anyone seen any problems using LOAD DATA FROM MASTER on a second slave
using a secondary network interface?
I have:
mysql-master / {172.25.7.20 / eth0, 192.168.7.20 / eth1} / Red Hat EL V.4 /
MySQL 5.0.22
mysql-slave1 / 172.25.1.58 / Windows XP / MySQL 5.0.18
mysql-slave2 / 19
Ed Pauley II wrote:
I need to come up with a high availability, high performance MySQL
server setup. I have two database servers half way across the country
from one another being replicated through a VPN. These db servers
serve two very busy web sites with multiple applications accessing th
I need to come up with a high availability, high performance MySQL
server setup. I have two database servers half way across the country
from one another being replicated through a VPN. These db servers serve
two very busy web sites with multiple applications accessing the db.
During busy tim
On Wed, Jul 18, 2001 at 07:38:10PM +0200, Warren van der Merwe wrote:
> Hi
>
> If you use the load infile to insert images into a blob field, and
> then the path does not exist when the replication takes place, will
> there be an error, or is it clever enough to get the blob data from
> the db?
Hi
If you use the load infile to insert images into a blob field, and then the
path does not exist when the replication takes place, will there be an
error, or is it clever enough to get the blob data from the db?
THanks
~
Warren van der Merwe
Software Director
10 matches
Mail list logo
