Re: [PHP-DB] MySQL Clustering, redundancy
Yes,it's called Replication in the MySQL documentation. However, since the info in the manual is kind of sparse so I would hop on google and do a search for specific instructions on how to do it when your ready, but to answer your question, yes, MySQL does do Redundancy/Failover. (Ofcourse you must take account of this in your code interacting with the server, but the data will be sync'd). Adam Voigt [EMAIL PROTECTED] On Tue, 2002-06-18 at 08:47, Matt Babineau wrote: Hi All: I quickly skimmed the MySQL manual and didn't see any information on clustering. Does MySQL have any support for clustering or some type of redundant failover systems? Thanks! Matt Babineau Freelance Internet Developer - e: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] p: 603.943.4237 w: http://www.criticalcode.com/ http://www.criticalcode.com PO BOX 601 Manchester, NH 03105 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL Clustering, redundancy
Thanks for your response Adam! Do you know if there is any way MySQL can be spread across multiple machines? I am looking at a huge application for a client, that will need to support thousands of simultaneous users. I am wondering if MySQL can handle load like that. That's why I was asking about clustering MySQL servers for the ability to handle more users simultaneously. Has anyone had any experience with a large scale application on MySQL? Matt Babineau Freelance Internet Developer - e: [EMAIL PROTECTED] p: 603.943.4237 w: http://www.criticalcode.com PO BOX 601 Manchester, NH 03105 -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 8:55 AM To: [EMAIL PROTECTED] Cc: Matt Babineau Subject: Re: [PHP-DB] MySQL Clustering, redundancy Yes,it's called Replication in the MySQL documentation. However, since the info in the manual is kind of sparse so I would hop on google and do a search for specific instructions on how to do it when your ready, but to answer your question, yes, MySQL does do Redundancy/Failover. (Ofcourse you must take account of this in your code interacting with the server, but the data will be sync'd). Adam Voigt [EMAIL PROTECTED] On Tue, 2002-06-18 at 08:47, Matt Babineau wrote: Hi All: I quickly skimmed the MySQL manual and didn't see any information on clustering. Does MySQL have any support for clustering or some type of redundant failover systems? Thanks! Matt Babineau Freelance Internet Developer - e: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] p: 603.943.4237 w: http://www.criticalcode.com/ http://www.criticalcode.com PO BOX 601 Manchester, NH 03105 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] MySQL Clustering, redundancy
I have never actually tried to program against something which talks to multiple DB's, the quickest way would be in your DB connection code to have something that will either: A. Try the first DB and connect to the second if it's down. B. Randomly choose a SQL server. The most fluid solution I could think of would be an application gateway of some sort which will load balance properly to different IP's while in your code you only point to one. Adam Voigt [EMAIL PROTECTED] On Tue, 2002-06-18 at 09:12, Matt Babineau wrote: Thanks for your response Adam! Do you know if there is any way MySQL can be spread across multiple machines? I am looking at a huge application for a client, that will need to support thousands of simultaneous users. I am wondering if MySQL can handle load like that. That's why I was asking about clustering MySQL servers for the ability to handle more users simultaneously. Has anyone had any experience with a large scale application on MySQL? Matt Babineau Freelance Internet Developer - e: [EMAIL PROTECTED] p: 603.943.4237 w: http://www.criticalcode.com PO BOX 601 Manchester, NH 03105 -Original Message- From: Adam Voigt [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 18, 2002 8:55 AM To: [EMAIL PROTECTED] Cc: Matt Babineau Subject: Re: [PHP-DB] MySQL Clustering, redundancy Yes,it's called Replication in the MySQL documentation. However, since the info in the manual is kind of sparse so I would hop on google and do a search for specific instructions on how to do it when your ready, but to answer your question, yes, MySQL does do Redundancy/Failover. (Ofcourse you must take account of this in your code interacting with the server, but the data will be sync'd). Adam Voigt [EMAIL PROTECTED] On Tue, 2002-06-18 at 08:47, Matt Babineau wrote: Hi All: I quickly skimmed the MySQL manual and didn't see any information on clustering. Does MySQL have any support for clustering or some type of redundant failover systems? Thanks! Matt Babineau Freelance Internet Developer - e: mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] p: 603.943.4237 w: http://www.criticalcode.com/ http://www.criticalcode.com PO BOX 601 Manchester, NH 03105 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] MySQL Clustering, redundancy
On 6/18/02 9:19 AM, Adam Voigt [EMAIL PROTECTED] pressed the keys forming the message: I have never actually tried to program against something which talks to multiple DB's, the quickest way would be in your DB connection code to have something that will either: A. Try the first DB and connect to the second if it's down. B. Randomly choose a SQL server. The most fluid solution I could think of would be an application gateway of some sort which will load balance properly to different IP's while in your code you only point to one. I vaguely remember an article talking about how to implement your choice A. Try weberdev or maybe even webmonkey (heck - just try google.). -- Ed Marczak [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php