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 r

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 > a

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

2002-01-17 Thread Boaz Yahav
de 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 MS

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

2002-01-17 Thread Boaz Yahav
mess :) -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 Ecomme

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

2002-01-17 Thread Boaz Yahav
Ecommerce 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; p

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

2002-01-16 Thread Frank Flynn
change > in that. Only the access to the Database will change. > > 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

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-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 fo

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... >

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 an

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

2002-01-13 Thread Heikki Tuuri
EMAIL PROTECTED]>; [EMAIL 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

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

2002-01-13 Thread Boaz Yahav
ssage- 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 I

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
Saturday, January 12, 2002 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). &g

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 a

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

2002-01-12 Thread Boaz Yahav
ry 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 site (Very successful / high traffic Auctions > site) from MySQL to MSSQL Server 2000. > I was wondering if anyo

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

2002-01-12 Thread Manuel Lemos
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 and if there are any pit > falls to notice. > > 1. Is ODBC the only way to work from a Solaris / Apa