MySQL GA clustering
Good day all I would just like to confirm the following please. I have a client who is running the free downloadable version of MySQL and they would like to go the clustering route for quite a couple of reasons. Does anybody know whether clustering is available with the downloadable version or is this only available with Enterprise? They would also like to know what they need for proper clustering in terms of disks (shared storage or local) memory (i found this on a website though) etc... and resouces they can look at on how to implement. I don't know clustering on MySQL at all so I will really appreciate some help on this. Regards Machiel
Re: MySQL Web Clustering...
Apparently OpenMosix won't work with MySQL because MySQL uses Shared Memory. There is apparently a component called MAASK which might help. Roy Nasser wrote: Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL Web Clustering...
Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy
Re: MySQL Web Clustering...
Go for a simple MySQL master - slave configuration. I'm runing 1 master 3 slaves for performance issues and doesn't have any problem at all for 1 year.. Of course in this case you should change some code in your webservers to direct SELECT queries to slave machine to gain performance on the master. I will also keep in touch with MySQL Cluster development and probably go for this in the near future. Best Regards, Cemal Dalar a.k.a Jimmy System Administrator Web Developer http://www.gittigidiyor.com http://www.dalar.net - Original Message - From: Roy Nasser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 18, 2004 4:58 PM Subject: MySQL Web Clustering... Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
I currently run LVS (pre-distribution) on my farm, which gets about 100M hits/month. Good points about LVS are that it is completely rock solid, and runs on minimal hardware. I have never run MySQL behind it, as I think that would be a bit flaky for a live site. Probably worth checking out though. I would think that instead of LVS Load Balancing, server failover might be a more viable path for MySQL. P Roy Nasser [EMAIL PROTECTED] 06/18/2004 01:58 PM To: [EMAIL PROTECTED] cc: Subject:MySQL Web Clustering... Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. -Mike From: Peter J Milanese [EMAIL PROTECTED] To: Roy Nasser [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: MySQL Web Clustering... Date: Fri, 18 Jun 2004 11:25:45 -0400 I currently run LVS (pre-distribution) on my farm, which gets about 100M hits/month. Good points about LVS are that it is completely rock solid, and runs on minimal hardware. I have never run MySQL behind it, as I think that would be a bit flaky for a live site. Probably worth checking out though. I would think that instead of LVS Load Balancing, server failover might be a more viable path for MySQL. P Roy Nasser [EMAIL PROTECTED] 06/18/2004 01:58 PM To: [EMAIL PROTECTED] cc: Subject:MySQL Web Clustering... Hi All, We have recently acquired some new machines for our ASP service, and I am investigating different options and setups to optimize everything. We currently have one large DB server, with RAID5, etc, running mysql and a few smaller servers for web applications, and e-mail. These smaller servers arent all identical in their software, and they run different services. We currently have reached a certain limit in the DB as well as in some of our applications on the webservers, hence the need for something expandable. I have read slightly about MySQLCluster, as well as some other solutions such as openMosix, Mosix and LVS. I was wondering if you guys have experience, and what you would recommend for the DB and for the webservers. I still want to maintain them separate, even if I end up having 2 different clusters, I prefer to keep the DB away from the application for security reasons. Thanks! Roy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ MSN Premium with Virus Guard and Firewall* from McAfee® Security : 2 months FREE* http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote: Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. Daemons? Client side code? Can you explain this please? mysql handles all the replication. Depending on your setup, client won't know the difference. Its really all depends on how your replication is gonna be set up. - -- SUSHIDO--The way of the Tuna. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA0xuZld4MRA3gEwYRAv1EAKCot3j1j16j892FtrTEea8Brlk0NgCcCKou 9K0QzPH4uFz+TYynwdNpxbY= =a/OR -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL Web Clustering...
The meaning of that was client-side being sending inserts/updates to the master server. This would be done in the program/script upon an insert query. A daemon could forward insert/update requests to a master and all others round-robin and simply pass packets. This is if you have to make it seamless. Would require some work to make one though. -Mike From: Jeff Smelser [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: MySQL Web Clustering... Date: Fri, 18 Jun 2004 11:43:05 -0500 -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday 18 June 2004 11:05 am, Mike Miller wrote: Unless you have a specific need for it, you could save yourself a lot of trouble by putting select tables or databases or even clients on each server. This also means you don't incur the added overhead of keeping the database in sync, creating actions if a master goes down, etc. Then just tell client1 to use database5 as their hostname for example. Replication requires that updates go to the master, which requires client-side code, or an intermediate daemon which analyzes the statement and forwards the request. Daemons? Client side code? Can you explain this please? mysql handles all the replication. Depending on your setup, client won't know the difference. Its really all depends on how your replication is gonna be set up. - -- SUSHIDO--The way of the Tuna. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFA0xuZld4MRA3gEwYRAv1EAKCot3j1j16j892FtrTEea8Brlk0NgCcCKou 9K0QzPH4uFz+TYynwdNpxbY= =a/OR -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] _ Free yourself from those irritating pop-up ads with MSn Premium. Get 2months FREE* http://join.msn.com/?pgmarket=en-capage=byoa/premxAPID=1994DI=1034SU=http://hotmail.com/encaHL=Market_MSNIS_Taglines -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql and clustering
On Sat, Jun 14, 2003 at 03:27:52PM +0200, Roberto Barbieri wrote: Yes but it can be done? If i'm not wrong actually db replication is only supported between secondary db or not? It can be done if you avoid auto-increment columns. That's not the only way, but it's the easiest to explain and has the least surprises. There are documents which explains how to build a two master replicated server? Simply configure each one as a slave of the other. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 13 days, processed 439,701,155 queries (373/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql and clustering
Yes but it can be done? If i'm not wrong actually db replication is only supported between secondary db or not? There are documents which explains how to build a two master replicated server? Thanks so much! Roberto - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Roberto Barbieri [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, June 12, 2003 8:38 PM Subject: Re: mysql and clustering On Wed, Jun 11, 2003 at 12:21:17PM +0200, Roberto Barbieri wrote: They're completely different clustering solution. What, exactly, are you trying to acheive? LVS is primarily for load balancing and possibly fail-over. OpenMosix is a different beast entirely. Jeremy Thanks for the reply Jeremy. What i need to build are a mysql master server with two nodes both active at the same time. Perhaps MySQL's replication in a dual-master setup? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 9 days, processed 310,123,483 queries (378/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql and clustering
On Wed, Jun 11, 2003 at 12:21:17PM +0200, Roberto Barbieri wrote: They're completely different clustering solution. What, exactly, are you trying to acheive? LVS is primarily for load balancing and possibly fail-over. OpenMosix is a different beast entirely. Jeremy Thanks for the reply Jeremy. What i need to build are a mysql master server with two nodes both active at the same time. Perhaps MySQL's replication in a dual-master setup? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 9 days, processed 310,123,483 queries (378/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql and clustering
They're completely different clustering solution. What, exactly, are you trying to acheive? LVS is primarily for load balancing and possibly fail-over. OpenMosix is a different beast entirely. Jeremy Thanks for the reply Jeremy. What i need to build are a mysql master server with two nodes both active at the same time. Don't know how this is called in english but we call it an HA active-to-active; while standard HA clustering is considered active-to-passive because only one node at time is working while the other one it will come up only if the first one is falling. I'm not a DBA and i know very little on setting up DB servers, but for what i have understand from the online documentation, if i use a slave server with db replication, when the master fails, the slave can only manage queries and not commits; I've also read that db replication fo the master servers will be supported starting at v.5.0 of mysql. Now, how i can achieve the active-to-active task? I've tought to put up two nodes with a shared disk-array where the db stands, and to share the processes between the two nodes using openmosix. What do you (and the others) think about that? Any advice is really welcome! :) Thanks in advance for any reply! Roberto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql and clustering
Hello to all, I'm requested to build an HA cluster for a mysql master server which is running on a redhat 8.0 box . Does anyone have done this before? I've though to use lvs or openmosix as clustering software. I'm interested on which clustering software you may have used, and to have a feedback of problems you may have encontered. Thanks! Roberto -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql and clustering
On Tue, Jun 10, 2003 at 02:45:42PM +0200, Roberto Barbieri wrote: Hello to all, I'm requested to build an HA cluster for a mysql master server which is running on a redhat 8.0 box . Does anyone have done this before? I've though to use lvs or openmosix as clustering software. They're completely different clustering solution. What, exactly, are you trying to acheive? LVS is primarily for load balancing and possibly fail-over. OpenMosix is a different beast entirely. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 7 days, processed 223,350,323 queries (351/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql 4.1 clustering/hign avaliability
Hello, I have two servers each one has mysql 4.1 running with seperate disks Is there a way that the 2 mysqld have exactly the same data (besides replication) ? Is there a way that if one server crashes mysql will be avaliable? Does mysql 4.1 have any extra culstering capabilities? Thank you -- Kissandrakis S. George [[EMAIL PROTECTED]] Network and System Administrator [http://www.phaistosnetworks.gr/] Phaistos Networks S.A. - A DOL Digital Company - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 4.1 clustering/hign avaliability
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kissandrakis -- ...and then Kissandrakis Giorgos said... % % Hello, Hi! % ... % Does mysql 4.1 have any extra culstering capabilities? I don't know about mysql directly, but I'm sure it would work just fine as an application under an OS cluster. What platform are you using? % % % Thank you HTH HAND mysql query, :-D - -- David T-G * There is too much animal courage in (play) [EMAIL PROTECTED] * society and not sufficient moral courage. (work) [EMAIL PROTECTED] -- Mary Baker Eddy, Science and Health http://justpickone.org/davidtg/ Shpx gur Pbzzhavpngvbaf Qrprapl Npg! -BEGIN PGP SIGNATURE- Version: GnuPG v1.0.7 (FreeBSD) iD8DBQE+Sm33Gb7uCXufRwARAqgPAJ9WGTSUy7m9ILS1pLq5/xX+E0M1MgCg3oOD t5CFGJPYeqIGdwOfSz9/nBg= =E1OO -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php