Re: SELECT w/LIKE on Swedish character รถ finds ], why?

2002-03-26 Thread James Housley
Philip Semanchuk wrote: Hi everyone, I am having a little trouble with searching for Swedish characters. When I SELECT using LIKE I get matches that I do not expect. I have created a simple test case that is entirely reproduced below. To summarize, I insert one row into a single-column

Re: Rotation of binary logs on replication master?

2002-03-21 Thread James Housley
Guy Davis wrote: Just wondering if any Linux users of MySQL out there had written a logrotate configuration file for dealing with MySQL binary logs on a replication Master. I want to rotate these logs (6.5 GB now) as some are over a month old. However, I don't want to confuse any of the

Re: High Availability questions

2002-03-20 Thread James Housley
Young Sul wrote: Hi, I've got a website that uses a mysql backend database. Due to the way in which the database and development has been architected, I'm unable to load-balance the database between multiple DB servers, taking advantage of replication inherent in mysql. (this is due

Re: TIMESTAMP not acting as I'd like

2002-03-06 Thread James Housley
[EMAIL PROTECTED] wrote: Hi, small problem. I have a table set up like so. It has a number of entries that were added on a certain date, I use TIMESTAMP to keep track of the date. +-+---+--+-+-+-- --+ | Field |

Re: RH 7.2 connections problems w 16 web servers to 2 MySQL servers

2002-03-06 Thread James Housley
Sam Iam wrote: We have a very high volume site (3 million page views a day) that's run on 16 Apache / PHP web servers 2 MySQL servers. We are using PHP with persistent connections. Each MySQL serves 8 web servers is supposed to act as a failover machine for the other group of 8 web

Re: MySQL Database Replication

2002-03-05 Thread James Housley
Thi Cao wrote: Hello everyone, This is my first attempt at MySQL database replication. Can't seem to get it to work yet. The problem reported in the error log of the slave server is as follows: Error reading packet from server: Access denied for user 'repl@slave_host' (Using