mysql disaster recovery

2003-12-02 Thread Andrew Hall
Greetings Gurus, I have a mysql server that I need to create a disaster recovery system for. What I am planning on doing is putting the data dir on a NFS mounted directory so that I can start mysql on either of two servers in case one dies. The inbound connections would be load balanced in a fai

RE: mysql disaster recovery

2003-12-03 Thread Andrew Hall
hat you look at MySQL's excellent replication > facility rather than NFS mount a drive. Having your data on an NFS mounted drive > will significantly degrade the performance of your database. Replication will not. > > > John Griffin > > --Original Message-- > From:

Re: Off Topic: MySQL Icons

2003-12-04 Thread Andrew Hall
Try google images... It's where I go every time I need to find an image that I don't have on hand. Drew On Thu, 2003-12-04 at 18:01, Daniel Kasak wrote: > Hi all. > > I'm prettying up my Gnome desktop, and I'm after a MySQL icon for my > MySQLCC launcher. > Anyone know of some icons? > > -- >

replication question

2003-12-05 Thread Andrew Hall
Greetings, Firstly I have searched the archives and received exactly 0 results returned for 'START SLAVE 1064' so... I have a mysql server I wish to replicate, its running 3.23.54. I have two test FreeBSD 5.1 servers I installed and from ports version 3.23.58. I completed the following steps to

RE: replication question

2003-12-05 Thread Andrew Hall
DUH!! I should have tried that... Thank you! Drew On Fri, 2003-12-05 at 15:49, Victor Pendleton wrote: > Try slave start > > -Original Message- > From: Andrew Hall [mailto:[EMAIL PROTECTED] > Sent: Friday, December 05, 2003 2:46 PM > To: [EMAIL PROTECTED] >

[Fwd: RE: replication question]

2003-12-05 Thread Andrew Hall
Didn't have the list cc-ed. -Forwarded Message- > From: Andrew Hall <[EMAIL PROTECTED]> > To: Mike Johnson <[EMAIL PROTECTED]> > Subject: RE: replication question > Date: Fri, 05 Dec 2003 16:17:14 -0500 > > Ok, at this point it appears my rep

replication/InnoDB errors

2003-12-08 Thread Andrew Hall
e please shed some light on what I have done wrong here. Thank you in advance, Andrew Hall -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: replication/InnoDB errors

2003-12-10 Thread Andrew Hall
Greetings, > > Didn't find any fields in table 'blah' > 031208 18:15:16 InnoDB error: > Cannot find table db/blah from the internal data dictionary > of InnoDB though the .frm file for the table exists. Maybe you > have deleted and recreated InnoDB data files but have forgotten > to delete the c

connection problems

2004-07-28 Thread Andrew Hall
Greetings, I have what I hope is an easy problem. I have installed mysql 4.0.20 and when I execute mysqladmin to set the root password using the -h flag my hostname is truncated, and I get a connection refused message. The hostname on this box is a fqdn like blah.1.2.3.net. My command line is

RE: connection problems

2004-07-28 Thread Andrew Hall
Yes I have. The hostname of the box returned with 'hostname' is the fqdn and is in the format of blah.1.2.3.net. Drew On Wed, 2004-07-28 at 17:16, Victor Pendleton wrote: > Can you check the host name again? You have a five segment address. > > -Original Message-----

RE: connection problems

2004-07-28 Thread Andrew Hall
localhost. > > -Original Message- > From: Andrew Hall > To: Victor Pendleton > Cc: '[EMAIL PROTECTED] ' > Sent: 7/28/04 4:35 PM > Subject: RE: connection problems > > Yes I have. The hostname of the box returned with 'hostname' is the > fqdn and is in the

RE: connection problems

2004-07-28 Thread Andrew Hall
> My apologies I was reading an ip address. Have you tried logging in from the > server itself? Since this is the initial install I think root needs to log > in from the localhost. > > -Original Message- > From: Andrew Hall > To: Victor Pendleton > Cc: '[EMAIL