Miguel,
On Fri, Dec 25, 2009 at 4:56 PM, Miguel Angel Nieto
wrote:
>> Load balancing, or high availability?
>>
>> I do not think there is anything good and simple AND generic out of
>> the box. As previous posters have noted, you generally have to build
>> something on top of other tools.
>
> Hi
Baron:
> Load balancing, or high availability?
> I do not think there is anything good and simple
We use MySQL master-master replication to keep
geographically separated databases in sync.
It works very well.
We built a management layer on top of it to allow
the endpoints (Web servers) to talk
> Load balancing, or high availability?
>
> I do not think there is anything good and simple AND generic out of
> the box. As previous posters have noted, you generally have to build
> something on top of other tools.
Hi,
I have the HA solved with MMM. Now, I want load balacing, sending read
que
Miguel,
On Sun, Dec 20, 2009 at 6:21 PM, Miguel Angel Nieto
wrote:
> Hi,
>
> I am searching fot a Mysql Load Balacing tool. I read about mysql
> proxy, sqlrelay, haproxy...
Load balancing, or high availability?
I do not think there is anything good and simple AND generic out of
the box. As pre
Hi,
I've had quite a bit of success deploying mysql-proxy in my clients
infrastructure.
The standard read/write splitting is quite easy to achieve - but I
also add some custom code to match with specific case (connection
pooling, x second to the same master after a write/update, specific
command
El día 22 de diciembre de 2009 13:44, Miguel Angel Nieto
escribió:
>> It depends a lot on how you plan to coordinate the db servers
>> (sharding, replication, ndb), the kind of applications you are going
>> to deploy and how much scability you need.
>
> Thank you. I have read about LVS and keepali
Hi,
El día 22 de diciembre de 2009 10:14, Jaime Crespo Rincón
escribió:
> 2009/12/21 Miguel Angel Nieto :
>> Hi,
>>
>> I am searching fot a Mysql Load Balacing tool. I read about mysql
>> proxy, sqlrelay, haproxy...
>>
>> What do you prefer?
>
> Hi,
>
> The solutions I have heard most from our cu
2009/12/21 Miguel Angel Nieto :
> Hi,
>
> I am searching fot a Mysql Load Balacing tool. I read about mysql
> proxy, sqlrelay, haproxy...
>
> What do you prefer?
Hi,
The solutions I have heard most from our customers (in production) are
not mysql-specific:
1) Simple, not load-aware *DNS balancin
can u please show use the content of the test.csv file. Also is "comapny
name" a single column or two different columns
If its two different columns than try this
load data file '/foo/test.csv' into table abc.test fields terminated by ','
(company,name)";
On 6/28/08, bruce <[EMAIL PROTECTED]> w
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
Ed Pauley II wrote:
This is another geographical location with automatic failover if there
is a problem, network, hardware etc. with the primary location. When the
problem is corrected, or corrects itself the traffic is automatically
sent back to the primary location. Without 2-way replication
Renato Golin wrote:
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in the replication (2-way
to make switching back and forth easy) chain.
Why do you need a ba
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN.
Yeah, known problem...
We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain.
Why do you need a backup site to write th
Ed Pauley II wrote:
Continuent's m/cluster will not work for me as it does not allow
replication across a WAN. We have an offsite backup that needs to be in
the replication (2-way to make switching back and forth easy) chain. I
am thinking of a master, slave setup at each location where
Peter Zaitsev wrote:
On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote:
I am looking into a scale-out solution for MySQL. I have read white
papers and searched the web but I can't find a load balancer that claims
to work well for MySQL. MySQL's white paper shows NetScaler in the
scale-
On Fri, 2006-08-04 at 15:54 -0400, Ed Pauley II wrote:
> I am looking into a scale-out solution for MySQL. I have read white
> papers and searched the web but I can't find a load balancer that claims
> to work well for MySQL. MySQL's white paper shows NetScaler in the
> scale-out stack but noth
I should mention that the below concerns read-only daemons, Dan's post
reminded me of that. Having multiple masters in a load balanced
environment is extremely difficult to do right.
I would wager that for most applications, at least internet related,
you'll have a much higher read-to-write ratio
Ed, in Jeremy Zawodny's (excellent) book "High Performance MySQL",
there is a chapter on load balancing - though it's a bit more of a
theoretical discussion than a how-to.
There are a couple of commercial products mentioned briefly - Veritas
and EMIC Networks.
One idea he presents might work for
You can have a simple LVS setup running with a plugin from Nagios,
check_mysql, which will connect to the mysql daemon and run a status
query. If you want anything more than that you most likely will have to
write a custom check plugin (shouldn't be that hard). LVS works nicely as
a mysql loadbalan
Ian Sales (DBA) wrote:
Kevin A. Burton wrote:
Define DoS?
- Denial of Service...
ug... Thats not what I meant... I mean what type of behavior were you
noticing? Just all connections being occupied on the server?
Kevin
--
Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an
Kevin A. Burton wrote:
Jason J. W. Williams wrote:
Has anyone ever had a problem with Alteon load balancers leaving the
MySQL connections half open? After about a minute of heavy use the
Alteon has completely DoS'd our MySQL servers. I know we must be doing
something wrong...just not sure what. Any
Jason J. W. Williams wrote:
Has anyone ever had a problem with Alteon load balancers leaving the
MySQL connections half open? After about a minute of heavy use the
Alteon has completely DoS'd our MySQL servers. I know we must be doing
something wrong...just not sure what. Any help is greatly apprec
eries.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Sheni R. Meledath
Sent: Wednesday, January 05, 2005 12:18 AM
To: Tom Crimmins
Cc: mysql@lists.mysql.com
Subject: RE: MySQL Load on server
Dear Tom,
Thank you very much. Is there a way to log al
Dear Tom,
Thank you very much. Is there a way to log all the processes on the MySQL
server to analyze later.
At 09:48 AM 1/5/2005, Tom Crimmins wrote:
If I understand correctly, this is what you want:
SHOW PROCESSLIST
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original
If I understand correctly, this is what you want:
SHOW PROCESSLIST
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Sheni R. Meledath [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 04, 2005 11:40 PM
To: MySQL Masters
Subject: MySQL Load on ser
Kevin A. Burton wrote:
Was curious what people on the list are using for load balancing.. there
are a number of techniques here but it would be interesting if people
could share some real-world experiences
HTTP load balancing is pretty well understood but there's not a bunch
out there on My
We also use Linux Virtual Server for load balancing, but only on our
read-only cluster. Our current levels of RW traffic do not demand more
than one machine.
Russell E Glaue wrote:
We have fail-over using Linux Virtual Server, now upgrading to Red Hat
Cluster Suite. We do not implement load-ba
We have fail-over using Linux Virtual Server, now upgrading to Red Hat
Cluster Suite. We do not implement load-balancing.
Here is why.
In order to have full true load balancing, you need to have two or more
MySQL database server replicating data to each other in real time.
Currently your only c
Problem: all the mod_perl pages run a few write queries, so they will require a
connection to the main database server. Since around
80% of our queries are reads, would you recommend that each script has two
connections: one for read queries, and one for write
queries? We can determine which quer
At 02:06 PM 2/25/2004, you wrote:
Hi,
Currently our web infrastructure has one main MySQL server, to which
connections are made by (mostly) mod_perl running under Apache
(on 3 different machines), and several other custom-built application
servers on other servers (which have persistant connecti
On Fri, Jan 16, 2004 at 10:14:08AM -0800, Andrew Kwiczola wrote:
> I was wondering how many records A mysql table can comfortably handle.. and
> which table type supports the greatest amount of record capacity. Can I
> have a few million records in 1 table? Over 10 million? Thanks !
>
Hi, Andrew
[snip]
It's a little messy but that's the only other way I can think of doing
it.
Sorry.
[/snip]
If he has the file locally to himself he can do this via phpMyAdmin
through the load text file option. Depending on the version there is
always a way to load files ... even to remote servers
For i
is_one` FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\r\n'
>
> I am using phpMyAdmin 2.3.3 - would an upgrade to the latest version
> remedy the issue?
>
> Thanks,
>
> -Mike
>
>
>
>> -Original Message-
>> From: Donald Tyler
[snip]
Sorry, that is the error - my mistake. I am getting this:
LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
TERMINATED BY ';' LINES TERMINATED BY '\r\n'
[/snip]
Mike, could we see just a bit of the php9GOwvw file...just out of
curiosity
--
MySQL General Mailing List
Fo
nks,
-Mike
> -Original Message-
> From: Donald Tyler [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 3:42 PM
> To: [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just re
[snip]
70050;451
70322;451
> LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
> TERMINATED BY ';' LINES TERMINATED BY '\r\n'
> [/snip]
[/snip]
I am going to recommend that you specify which columns the data goes
into
> LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_
o: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> [snip]
> 70050;451
> 70322;451
>
> > LOAD DATA LOCAL INFILE '/tmp/php9GOwvw' INTO TABLE `this_one` FIELDS
> > TERMINATED BY ';' LINES TERMINATED BY
; Sent: Friday, August 08, 2003 4:08 PM
> To: [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> Oh and just a note. This solution won't work if you are uploading the file
> to the server through the browser. You will need to put the file on the
> server
[snip]
I see you still have the word LOCAL in there. Did you try and remove it?
To do that in PHPMyAdmin you will need to run the import so you get the
error message and then copy and paste it into the SQL section of the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It
should
wor
MAIL PROTECTED]
> Sent: Friday, August 08, 2003 3:24 PM
> To: Donald Tyler; [EMAIL PROTECTED];
> [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> Ah. No wonder it dinna work. Neither did specifying the columns as Jay
> suggested.
>
> I also have no choic
over 15,000 of them. :)
-Mike
> -Original Message-
> From: Jay Blanchard [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 08, 2003 3:58 PM
> To: Mike At Spy; Donald Tyler; [EMAIL PROTECTED]
> Subject: RE: mysql LOAD DATA INFILE
>
>
> [snip]
> Sorry, that
the
PHPMyadmin tool. Delete the world LOCAL and then run the query. It should
work.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:59 PM
To: Donald Tyler; [EMAIL PROTECTED]
Subject: RE: mysql LOAD DATA INFILE
Sorry, that is the error - my
PHPMyAdmin uses the "LOAD DATA LOCAL INFILE" command. Just remove the word
LOCAL and it should work fine.
-Original Message-
From: Mike At Spy [mailto:[EMAIL PROTECTED]
Sent: Friday, August 08, 2003 2:35 PM
To: [EMAIL PROTECTED]
Subject: mysql LOAD DATA INFILE
When I come across this er
Hi!
On Aug 01, Dan Muey wrote:
>
> > Dear Ladies and Sirs,
> >
> > can anyone give me a hint please, if it is possible toimport
> > data data from a zipped File, without unzipping it before.
> > I'm using MySQL 3.23 on a LINUX System. I guess it is
> > possible using a 'named pipe' and 'funzi
> Dear Ladies and Sirs,
>
> can anyone give me a hint please, if it is possible toimport
> data data from a zipped File, without unzipping it before.
> I'm using MySQL 3.23 on a LINUX System. I guess it is
> possible using a 'named pipe' and 'funzip' , but I don't lnow how.
I've used Perl and
Tim,
[returned the conversation to the list, so that others may benefit]
> Right now in the config.inc.php file i have it set as:
>
> ### MySQL data
> $mysql_host = "localhost"; // localhost name
> (usually:localhost)
> $mysql_user = "mine"; // MySQL username
> $mysql_pass = "mine2"; // MySQL pass
Tim,
Normally PHP/MySQL doesn't run as "mine", even if that is your Windows login
name - but it is possible...
Use command line.
Log on as root.
Check localhost privileges for user "mine".
(good coverage in the manual)
Regards,
=dn
> I have been trying to get mysql db to run but keep
> getting acc
Hi Maximo,
> How should I set my memory usage in my.cnf I have a hard time
> understanding how MySQL works with memory, how it manages it, etc. What
> should I consider when setting my memory settings??? I have included a
> paste of my.cnf
>
> # The MySQL server
> [mysqld]
> port
Maximo,
- Original Message -
From: "Maximo Migliari" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, November 13, 2002 11:31 PM
Subject: MySQL load problems.
> Hello all,
>
> I've been having some problems with MySQL crashing. I use a mixture of
> MyISAM and Inno
Taylor,
Thursday, May 23, 2002, 11:46:16 PM, you wrote:
TL> What priviledge does a user need in order to be able to execute the load data
infile command in mysql..? is it FILE?
Yes, you are right. Your user must have file privilege.
Note: MySQL must have permissions on that file in your OS.
T
Yes it is ...
See: http://www.mysql.com/doc/P/r/Privileges_provided.html
Gurhan
-Original Message-
From: Taylor Lewick [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 4:46 PM
To: [EMAIL PROTECTED]
Subject: mysql load data question
What priviledge does a user need in order to be
Hi,
Look at http://www.mysql.com/doc/L/O/LOAD_DATA.html
and you can try this...
load data infile 'yourfile' into table your_table fields terminated by
'\your_separator_char_for_fields' lines terminated by
'\your_separator_char_for_row';
Regards,
Gelu
__
Everytime you have something to ask, first point your browser to :
http://www.mysql.com/doc/
Type in the keywords (in this case LOAD DATA)
The first url in the resultset will be :
http://www.mysql.com/doc/L/O/LOAD_DATA.html
which is what you are looking for.
Gurhan
-Original Message-
[EMAIL PROTECTED] (Trond Eivind Glomsrød) writes:
> FWIW, reproducible testcases are good... all complex software products
> have bugs (MySQL, gcc 2.95.x, gcc 2.96RH, gcc 3.0.x, egcs), often in
> interaction with oneanother (e.g. timing/locking issues), so
> reproducible testcases are a necessity
"Mike Robinson" <[EMAIL PROTECTED]> writes:
> Thanks for your note.
>
> You wrote:
>
> >
> > There are known problems with gcc-2.96 which comes with RH 7.2
> > distribution. There is disclaimer about it at
> > www.mysql.com/downloads/mysql-3.23.html as you noticed.
>
> There is much reading
Mike,
BTW, have you been able to build Mysql 4.0 under RH7.x from the development
tree lately?
I keep getting some missing definitions messages as of last week, when I
performed a regular 'bk resync'. Prior to that, all had been just fine.
TIA,
Vadim P.
Mike Robinson wrote:
>
> Hello to all,
Vadim P. writes:
> Mike, what kind of problem? What exactly goes wrong with PHP4?
>
> Thanks,
> Vadim
>
> Mike Robinson wrote:
> >
>
> > I am able to reproduce this problem very easily, including on
> > Redhat-7.2. Basically, any app using the libmysqlclient.so
> > compiled with gcc-2.96 connecti
Mike, what kind of problem? What exactly goes wrong with PHP4?
Thanks,
Vadim
Mike Robinson wrote:
>
> I am able to reproduce this problem very easily, including on
> Redhat-7.2. Basically, any app using the libmysqlclient.so
> compiled with gcc-2.96 connecting to a server compiled with
> gcc-2
Thanks for your note.
You wrote:
>
> There are known problems with gcc-2.96 which comes with RH 7.2
> distribution. There is disclaimer about it at
> www.mysql.com/downloads/mysql-3.23.html as you noticed.
There is much reading on the GCC 2.96 issue.
There seems to be two paths of dicussion.
Hello,
Mike Robinson wrote:
> Hello to all,
>
> I've had some severe issues on redhat-7.x boxes and
> mysql compiled from source with gcc-2.96 much like
> the warning states on the download page. On these boxes,
> more than say 20-25 concurrent or near-concurrent connects
> produced unexpected re
On Sun, May 12, 2002 at 12:06:33PM -0400, Mike Robinson wrote:
> Hello to all,
>
> I've had some severe issues on redhat-7.x boxes and mysql compiled
> from source with gcc-2.96 much like the warning states on the
> download page. On these boxes, more than say 20-25 concurrent or
> near-concurren
At 13:13 -0600 2/22/02, Craig Westerman wrote:
>I have a table that has following fields
>
>id (auto increment)
>date
>appleprice
>orangeprice
>pearprice
>
>When I try to LOAD DATA INFILE with this file using comma as field delimiter
>and newline as end of row
You need to add the column list:
.
You need to specify the columns you're loading, if they aren't all the
columns in the table in the same order. So, you need to add
(date, appleprice, orangeprice,pearprice)
at the end of your LOAD DATA INFILE statement.
As for only loading one row, I'd guess your input file line endings don'
63 matches
Mail list logo
