Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-28 Thread Manuel Lemos
Hello, Boaz Yahav wrote: I don't think you realize the nature of the site. Its an auction site and not a retail site. Prices need to be updated on thousands of clients simultaneously. Our goal is to refresh the data on the client every 3-10 seconds while having 1500 online open

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-28 Thread Manuel Lemos
Hello, Boaz Yahav wrote: Fail Over is not for when the cluster is too busy, it's for when the server dies, or when someone killed it's power, or when you loose your network, or when you get a blue screen (assuming you are on windows :). Ok, it is the same. When the server is dead, the

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-17 Thread Boaz Yahav
Auction site. Thanks berber -Original Message- From: Frank Flynn [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 16, 2002 7:51 PM To: Boaz Yahav; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 There are few things you should consider; perhaps you

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-17 Thread Boaz Yahav
:) -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:45 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 Hello, Boaz Yahav wrote: You realize that what they did will never work with an Ecommerce auction

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-17 Thread Boaz Yahav
and the site will continue to work as if nothing happens... it's pretty amazing to see this in action :) -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 11:38 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-16 Thread Frank Flynn
. Does this help? berber -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 Hello, Boaz Yahav wrote: Hi I'm planning to move my

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Boaz Yahav
11:25 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 Hello, Boaz Yahav wrote: Well, My Site runs now on Solaris. Both the front end (Web Server / php code / Apache) and the Database (Backend server). We had some problems with Mysql and we don't

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Boaz Yahav
You realize that what they did will never work with an Ecommerce auction site where everything must be in real-time... -Original Message- From: Manuel Lemos [mailto:[EMAIL PROTECTED]] Sent: Saturday, January 12, 2002 11:25 PM To: [EMAIL PROTECTED] Subject: Re: [PHP-DB] Re: Moving from

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Boaz Yahav
- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 13, 2002 10:42 PM To: Boaz Yahav Subject: RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 Hi! If you are not happy with MyISAM's lack of transactions or row level locking or crash recovery, you could try InnoDB type

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Heikki Tuuri
PROTECTED] [EMAIL PROTECTED] Date: Sunday, January 13, 2002 10:45 PM Subject: RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 It's not just that... For example, when I want to backup the MySQL server (and we are talking of a few GB of data) the server is practically dead while making the dump

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread ted
Yes. PostgreSQL. On Sun, 13 Jan 2002, Boaz Yahav wrote: It's not just that... For example, when I want to backup the MySQL server (and we are talking of a few GB of data) the server is practically dead while making the dump. MSSQL Server 2000 (for example) does that in the background and

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Manuel Lemos
Hello, Boaz Yahav wrote: It's not just that... For example, when I want to backup the MySQL server (and we are talking of a few GB of data) the server is practically dead while making the dump. MSSQL Server 2000 (for example) does that in the background and you can keep working... Any

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Manuel Lemos
Hello, Boaz Yahav wrote: My main problem is that MySQL is not Cluster Aware. I never heard of a MySQL server being able to perform a Fail Over to another node. Did you? I never used MySQL in a cluster myself, but AFAIK, if it would not do fail-over, what good a cluster would be for when a

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-13 Thread Manuel Lemos
Hello, Boaz Yahav wrote: You realize that what they did will never work with an Ecommerce auction site where everything must be in real-time... Why do you say that? Because you think you will need to handle as much requests as they do but always with upto date information? AFAIK, most of

RE: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-12 Thread Boaz Yahav
, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000 Hello, Boaz Yahav wrote: Hi I'm planning to move my site (Very successful / high traffic Auctions site) from MySQL to MSSQL Server 2000. I was wondering if anyone has done this move

Re: [PHP-DB] Re: Moving from MySQL to MSSQL Server 2000

2002-01-12 Thread Manuel Lemos
Hello, Boaz Yahav wrote: Well, My Site runs now on Solaris. Both the front end (Web Server / php code / Apache) and the Database (Backend server). We had some problems with Mysql and we don't find it 100% reliable for such a busy site. We also want to use a db cluster for high