Re: my.cnf file

2009-05-07 Thread Craig Dunn
michel wrote: I set up mysql and can't start it because I need to hard code the IP address parameter (bind-address) into my.cnf ... but I have three of them in different sub directories of /mysql/mysql-test/suite Should there not be one basic one? http://dev.mysql.com/doc/refman/5.1/en/opt

Re: Default my.cnf for (very) high performance servers....

2009-05-06 Thread Craig Dunn
Andrew Braithwaite wrote: Your disk config is good and you'll need all the nessesary my.cnf entries to point all the logs and data to the correct place. Slaves should have the relay-logs going to the OS disk too. I assume you've set up the master slave config in the my.cnf too. Yeah the repl

Re: Default my.cnf for (very) high performance servers....

2009-05-06 Thread Craig Dunn
Andrew Braithwaite wrote: There's no such thing as a generic my.cnf for high performance MySQL servers, you will need to provide more information.. Well, I was more after something a bit more up to date than my-huge.cnf that I could use as a starting point, I see a few example ones posted to

Re: Default my.cnf for (very) high performance servers....

2009-05-06 Thread Craig Dunn
Craig Dunn wrote: Hi All, We're setting up a group of servers using MySQL Enterprise 5.1 - Rather than starting with a blank canvas I wondered if there was a suitable my.cnf that is tuned to the kind of environment I'm running where I can tweak it from there. We're runn

Default my.cnf for (very) high performance servers....

2009-05-06 Thread Craig Dunn
Hi All, We're setting up a group of servers using MySQL Enterprise 5.1 - Rather than starting with a blank canvas I wondered if there was a suitable my.cnf that is tuned to the kind of environment I'm running where I can tweak it from there. We're running on RHEL, on Sunfire X4140's - 8 d

Re: Mysql upgrade from 4.1 to 5.0 to 5.1

2009-05-06 Thread Craig Dunn
A DB politics between mysql & oracle again Thats quite ironic given recent events :) -- Linux web infrastructure consulting, cr...@codenation.net Free live poker tournament listings, http://www.g5poker.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

INNER JOIN order issues.

2009-04-07 Thread Craig Dunn
Hi, I'm trying to migrate an application from 4.1 to 5.1, theres a bunch of queries that seem to be failing and it looks like the order of INNER JOIN's... for example... SELECTetc INNER JOIN tablex AS x ON y.foo = a.bar INNER JOIN tablea AS a ON y.foo = b.bar ... works in 4.1, but in

Re: Master-master replication configuration...how?

2009-03-27 Thread Craig Dunn
blue.trapez...@gmail.com wrote: Hi I have 2 servers and I am trying to set up (for testing purposes) a master-master replication environment. I read the instructions in the manual for master-slave, but am not able to find any information on how to set up a master-master system. Can someone on th

Re: Upgrade large databases from 4.1 to 5.1

2009-03-24 Thread Craig Dunn
Baron Schwartz wrote: If you can't take downtime, I'd go the slave route. You should certainly test your application to make sure 5.1's differences (data types, syntax, etc) don't cause problems. Otherwise you're risking getting badly stuck and having to downgrade to 4.1 again in a crisis. If

Upgrade large databases from 4.1 to 5.1

2009-03-24 Thread Craig Dunn
Hi All, I need to migrate a large (30G) database from 4.1 to 5.1 on a live system that cannot afford a large amount of downtime. The official method (copy files, run mysql_upgrade...etc) is looking like it will take forever, particularly since I need to move it 5.0 before 5.1. How do peop

Operating Systems.

2008-12-12 Thread Craig Dunn
I'm currently spec'ing out a design plan for a large scale MySQL infrastructure to support a high-read large scale web environment for a client. I've got the overall MySQL set up planned out (which I'll post here later to get peoples inputs/advice) but one issue which is currently undecided

Re: Comparing Data

2008-12-11 Thread Craig Dunn
Darvin Denmian wrote: Hello, i need to know : there is a way to compare data between "Mysql Master" and "Mysql Slave". We had some problems with replication and do not know if the data is intact. Thanks. Have a look at http://www.maatkit.org - I think they have a useful tool for this. Reg