Re: cluster

2008-07-17 Thread MarisRuskulis
What kind of querys there is, how many writes and reads? How complex is querys. Krishna Chandra Prajapati wrote: > Hi all, > > Is there any way to know that mysql cluster setup is required there is a lot > of aborted clients on my production server. Every day it is increasing 150 > per day. > >

Re: cluster or replication

2005-09-13 Thread Lorenzo De Vito
This isn't a constraint, this is a limit, the goal is to have a bi-directional replication but I've not found solutions to my problem using mysql. I've a control access system with 9 minitowers which controls people access via RFID, each minitower is provided with linux and mysql synchronized w

Re: cluster or replication

2005-09-13 Thread Cory Robin
Is it possible to have cluster and replication? (ie clusters at each location and replication to sync each location) Alan Williamson wrote: I've 10 server in differents locations, I want to make a broadcast, I would like to have always datas synchronized between this network, each database h

RE: cluster or replication

2005-09-13 Thread Alan Williamson
> I've 10 server in differents locations, I want to make a broadcast, I > would like to have always datas synchronized between this network, each > database have the same tables and same structure. Each insert or update > in database will be executed for each server within this broadcast, > wha

RE: cluster or replication

2005-09-12 Thread Cory Robin
Since MySQL-Cluster is not recommended over a WAN that's not an option. I soon will be looking for a method to syncronize real-time data between a active/passive datacenter setup. (One datacenter in Salt Lake City, Utah and another in Las Vegas, Nevada) At this time I don't think any 'out of t

Re: Cluster on Solaris 9/x86 works

2004-07-22 Thread Alexander Haubold
Yes, I have set the ByteOrder to Big for Sparc. Changing that to Little (even though this is wrong) had no effect. At 05:05 PM 7/20/2004, Justin Swanhart wrote: You do have ByteOrder: Big in the .ini file for the sparc database servers, right? --- Alexander Haubold <[EMAIL PROTECTED]> wrote: > H

Re: Cluster on Solaris 9/x86 works

2004-07-20 Thread Justin Swanhart
You do have ByteOrder: Big in the .ini file for the sparc database servers, right? --- Alexander Haubold <[EMAIL PROTECTED]> wrote: > Hi everyone, > > Just to follow up on my previous post regarding > Cluster on Sparc/Solaris 9: > On an x86 Solaris 9 machine that was set up similar > to the Sp

Re: Cluster and Fulltext indexes?

2004-06-01 Thread Jon Drukman
Santino wrote: Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? i had a meeting with the mysql cluster sales team and they said it is not supported. fulltext is for myisam only. cluster uses NDB storage eng

Re: Cluster and Fulltext indexes?

2004-05-30 Thread Santino
At 15:21 -0500 29-05-2004, mos wrote: At 01:39 PM 5/29/2004, you wrote: Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? Thank you. Santino Cusimano - Santino, Where does it say that in the docs? Can y

Re: Cluster and Fulltext indexes?

2004-05-29 Thread mos
At 01:39 PM 5/29/2004, you wrote: Hello, Does the cluster support fulltext indexes? After a quick reading of preliminary documentation it seems NO. Can someone confirm it? Thank you. Santino Cusimano - Santino, Where does it say that in the docs? Can you post the documentation that says f

Re: Cluster/replication

2002-12-19 Thread sam
Does any one have any advise about clustering and replication with of course mysql. Are there any third party products? Sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql

Re: Cluster?

2001-12-06 Thread Shakeel Sorathia
I can tell you how we solved this problem. we have a 24/7 op where we need to constantly pull data from mysql machines. This data can be updated at anytime by our tools, but the live servers will only be reading data. So we have one machine which is connected to our tools box, this is wher

RE: Cluster?

2001-12-06 Thread Greg_Cope
> -Original Message- > From: Barry Roomberg [mailto:[EMAIL PROTECTED]] A few notes: > 1) All data is readonly. No write requirement except > monthly load. use myisam pack to compress the data / indexs. Also use -rq --analyse --sort-index as myisam arguments to rebuild the index