Re: Is mysql 3.2x stable enough for HA requirement?

2002-04-04 Thread Patrick Hsieh
Hello Raúl Alexis Betancort Santana [EMAIL PROTECTED], What software did you use to make the load-balancing? Does PostgreSQL support async replication only just like MySQL does? How about Sync replication? On Thu, 4 Apr 2002 02:35:17 +0100 Raúl Alexis Betancort Santana [EMAIL PROTECTED]

Re: Is mysql 3.2x stable enough for HA requirement?

2002-04-03 Thread Jean-Francois Dive
i totally agree. I used postgres in prod in several cases and it never fall, got stucked or anything. Especially if you need transaction, i think postgres is the way to go.., otherwise, text files is a very solid approach ;) JeF On Mon, Apr 01, 2002 at 07:20:02PM +1200, Dave Watkins wrote: Hi

Re: Is mysql 3.2x stable enough for HA requirement?

2002-04-03 Thread Patrick Hsieh
Hello Jean-Francois Dive [EMAIL PROTECTED], I have no problem with the robustness of PostgresSQL. However, does PostgreSQL have built-in replication? If not, how do I implement high-available PostgreSQL clusters? In addition, since InnoDB has been stable in MySQL-3.23.49, is InnoDB ready for

Re: Is mysql 3.2x stable enough for HA requirement?

2002-04-03 Thread Raúl Alexis Betancort Santana
El Thu, Apr 04, 2002 at 08:58:50AM +0800, Patrick Hsieh escribió: Hello Jean-Francois Dive [EMAIL PROTECTED], I have no problem with the robustness of PostgresSQL. However, does PostgreSQL have built-in replication? If not, how do I implement high-available PostgreSQL clusters? Umm,

Is mysql 3.2x stable enough for HA requirement?

2002-03-31 Thread Patrick Hsieh
Hello, I am planing to have some woody with mysql-server running on a mission-critical environment. My criteria is: 1. HA requirement: By using mysql built-in replication, I'd like to have a load-balancing and fail-over mysql clusters 2. minimal data loss risk How much can mysql 3.2x

Re: Is mysql 3.2x stable enough for HA requirement?

2002-03-31 Thread Dave Watkins
Hi Patrick MySQL replication is only one way in 3.2x so all writes have to be sent to the master server, but the reads can be done from the slaves. If you loose a slave then no big deal round robin DNS alone should take care of that with very little impact, but if you loose the master then