Re: short e-mail survey on load-balance technology used

2007-11-01 Thread Russell E Glaue
Philip Hallstrom wrote: >> pgpool is a connection pool server for PostgreSQL. pgpool runs between >> PostgreSQL's clients(front ends) and servers(back ends). >> >> Well there are a few solutions out there. >> >> The first comparable product for MySQL is MySQL Proxy. >> http://forge.mysql.com/wiki/

Re: short e-mail survey on load-balance technology used

2007-11-01 Thread Philip Hallstrom
pgpool is a connection pool server for PostgreSQL. pgpool runs between PostgreSQL's clients(front ends) and servers(back ends). Well there are a few solutions out there. The first comparable product for MySQL is MySQL Proxy. http://forge.mysql.com/wiki/MySQL_Proxy Almost, but the faq says it'

Re: short e-mail survey on load-balance technology used

2007-11-01 Thread Russell E Glaue
Philip Hallstrom wrote: ... >> 6) When it comes to scaling MySQL and the use of load-balancing, what >> do you >> feel is a technology that is missing that the MySQL community should >> create? >> (I.e. perhaps some new technical item in the MySQL database server >> software, or >> something on the

Re: short e-mail survey on load-balance technology used

2007-11-01 Thread Russell E Glaue
Philip Hallstrom wrote: ... >> 6) When it comes to scaling MySQL and the use of load-balancing, what >> do you >> feel is a technology that is missing that the MySQL community should >> create? >> (I.e. perhaps some new technical item in the MySQL database server >> software, or >> something on the

Re: Detecting new records

2007-11-01 Thread Baron Schwartz
Hi Naufal, Naufal Sheikh wrote: Hello list. Inorder to do some maintainance, I will be shutting down my production server running mysql4.1. I have already prepared a backup server which is running mysql4 and have imported the current database in it. Though one way of doing things can be to shu

Detecting new records

2007-11-01 Thread Naufal Sheikh
Hello list. Inorder to do some maintainance, I will be shutting down my production server running mysql4.1. I have already prepared a backup server which is running mysql4 and have imported the current database in it. Though one way of doing things can be to shut down the database on the producti

Re: short e-mail survey on load-balance technology used

2007-11-01 Thread Philip Hallstrom
1) Do you use a load-balancer for your MySQL Deployment? Yes. Well, up till just a little while ago... 2) What load-balancer (product name) do you use for your MySQL Deployment? We used to run MySQL's NDB Cluster behind a hardware load balancer (don't remember the name, but it's not that re

short e-mail survey on load-balance technology used

2007-11-01 Thread Russell E Glaue
Permit me to query the users on this list to ask a few questions on if and how they scale their MySQL with the use of load-balancers. I am only expecting very short answers, but you may choose to answer how ever you like. My goal is to try and understand what state the MySQL community is in wit

RE: corrupted query cache?

2007-11-01 Thread Max Thayer
> What's your question? Heh, yah that might be important... Has anyone experienced this? Does it look like anything in the my.cnf could be altered to alleviate or assist me in diagnosing the problem? I do not get an indication of any problems in the log files or the bin-logs. How might I effi

Re: corrupted query cache?

2007-11-01 Thread Baron Schwartz
What's your question? Max Thayer wrote: We are experiencing a certain anomaly here on our db server. The problem had occurred about 3 weeks ago. We ran diagnostics on the hardware over a 48+hour period with no failures or indications of problems with hardware. ( at least the memory.) We reboot

corrupted query cache?

2007-11-01 Thread Max Thayer
We are experiencing a certain anomaly here on our db server. The problem had occurred about 3 weeks ago. We ran diagnostics on the hardware over a 48+hour period with no failures or indications of problems with hardware. ( at least the memory.) We rebooted the server, and had not experienced anym