mysql load balancing

2009-12-20 Thread Miguel Angel Nieto
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

Why does this query return no rows?

2009-12-20 Thread René Fournier
This query works as expected: mysql SELECT id, AsText(coordinates) FROM qs WHERE latitude 48.6 AND latitude 53.4 AND longitude -116.4 AND longitude -111.6 LIMIT 3; ++--+ | id | AsText(coordinates) |

Most data sort

2009-12-20 Thread HaidarPesebe
Dear All, I need your help to how to call the database. I've got a mysql database as follows: -- Name | qty - A 1 B 2 A 4 A 1 B 1 A 2 C 2 D 1 C 4 How calling if I want to sort the data according to the most, or the