Authorized != trusted.
If you're a hosting provider who allows access to MySQL for customers, your
users have access to see the version number by way of simply connecting to
their own database. Not that "mysql --version" from a shell doesn't give you
the same thing... but paying for a low end acco
If you want to use DNS, that's the way to go.
You can also use LVS to setup clusters of databases.
http://www.linuxvirtualserver.org
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Friday, March 07, 2003 6:05 PM
To: John Masterson
Cc: [EMAIL PROTECTED]
Subject:
I've devised a solution under Linux, using Heartbeat, DRBD and Perl, but we
have not put it into production yet. We also use LVS to put our database
slaves into HA clusters.
The basic idea is that you have an Active/Standby master, (the standby being a
slave) in a heartbeat cluster. You use DRBD
Since you're posting on a MySQL list, you could probably expect some biased
responses. Could you post more about what you need to use a database for,
i.e., what are your needs, wants, what kind of data are you handling,
connection rates, serving platform, code base, etc.
Here are a few URLs I was
You could try changing the priority of your inserts using INSERT LOW PRIORITY
See: http://www.mysql.com/doc/en/INSERT.html
This will give the selects priority over the inserts, as the table becomes
free, the insert will happen.
Also, look at this:
http://www.mysql.com/doc/en/Insert_speed.html
use Date::Manip
http://www.perldoc.com/perl5.6.1/lib/Date/Manip.html
-J
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 1:33 PM
To: 'Lucas Cowgar'; MySQL Mailing List
Subject: RE: # of Business Days?
>>Can anyone out there help me w
Changing one local variable, IMO, shouldn't replicate.
I would much rather have a REPLICATE command that I could place before any SQL
command that causes it to replicate. This keeps local variables local, but in
the event I need to replicate a change to all my slaves without going to each
one, I
there a way to turn up the verbosity of the log files without building a
debug version of MySQL?
-Original Message-----
From: Jeremy Tinley [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 17, 2003 4:07 PM
To: [EMAIL PROTECTED]
Subject: RE: received 0 length packet from server
A few more
ter 'repl@master1:3306',replication
resumed in log 'binlog.010' at position 540037417
This is one complete cycle of the problem. This time, I see
server_errno=2013. Perror doesn't have anything on this error.
-Original Message-
From: Jeremy Tinley [mailto:[EMAIL P
Howdy,
Running MySQL 3.23.54 on master, 3.23.55 on all slaves, I'm experiencing the
following situation:
slave1 & slave4 both receive 0 length packets from the server.
slave2 & slave3 both work fine.
slave1 & 2 are identical machines both in hardware and configuration
slave3 & 4 are different fr
According to the replication compatibility table, you can.
http://www.mysql.com/doc/en/Replication_Implementation.html
-J
-Original Message-
From: Andrew Braithwaite [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 15, 2002 8:36 AM
To: [EMAIL PROTECTED]
Subject: MySQL Replication - v
show tables;
show tables from catalogName;
show tables from catalogName like 'order%';
-J
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
Of Iikka Meriläinen
Sent: Wednesday, October 09, 2002 10:09 AM
To: Inbal Ovadia
Cc: '[EMAIL PROTECTED]'
Subject: Re: i
What happens when the user reaches their quota limitation from MySQL
doing an insert? IIRC, the filesystem won't allow the write and could
potentially cause problems with the database.
You may choose to put them on another un-quota-ed filesystem and write a
quick perl script to check the size of
ng the position you were
just at.
Is is possible to write two binlogs? One to the local disk, one to a
network device?
-J
-Original Message-
From: Daniel Koch [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 07, 2002 11:47 AM
To: Jeremy Tinley
Cc: [EMAIL PROTECTED]
Subject: Re: HA o
Howdy,
There has been some interest lately in HA of MySQL services both in my
company and on the list. A few of us here sat down on Friday (at 5PM no
less) and started hashing out the details of providing such a service.
Following several possible approaches, we ran into major stumbling
blocks o
Tom,
What type of problems AREN'T you detecting?
I'd take a wild guess and say you're only checking MySQL every 5 minutes
or so. You can decrease the frequency between checks for more updated
status. There are two variables that you need to look at:
normal_check_interval, which is part of the
>> This handles part of the problem but a true load balanced master
>> solution is needed. There's no real advantage in spending 5, 10 or
>> $20,000 on a failover master if you can't load balance and the spare
>> will just sit idle.
> Sure there is. If your master blows up, you have a spare wait
This handles part of the problem but a true load balanced master
solution is needed. There's no real advantage in spending 5, 10 or
$20,000 on a failover master if you can't load balance and the spare
will just sit idle. Master servers should intelligently talk to each
other and determine duplica
First of all, I forgive the rather lengthy post.
Thanks for the repl(y|ies) Benjamin. Decreasing the key_buffer should
be my first step. Back to the questions:
3) I'm somewhat at a loss for this one and perhaps the answer is more
obvious than not. I have 257 total tables from my main DB and
Rummaging through some docs on performance and have come up with some
questions. Let me preface by saying, we don't have any performance
problems. I inherited this monster of a database and am running through
the configuration to make sure that it is indeed setup for optimum
performance.
For cl
subsequently deleting it).
-J
-Original Message-
From: Mike Hall [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 3:14 PM
To: Jeremy Tinley; [EMAIL PROTECTED]
Subject: Re: Tape backups from live slave
> b) I have 200 tables. I don't want to have to recreate indexes for
--Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 1:57 PM
To: Jeremy Tinley
Cc: [EMAIL PROTECTED]
Subject: Re: Tape backups from live slave
On Fri, 30 Aug 2002, Jeremy Tinley wrote:
> Date: Fri, 30 Aug 2002 12:36:28 -0500
> From: Jerem
Howdy,
Before I run off and try it, can anyone offer up any problems with doing
a LOCK TABLES, FLUSH TABLES and then use tar to backup my 16GB of DB
tables from a slave to a tape?
Currently, I redirect the traffic to another slave, and then shut down
this slave to backup the tables and keep repl
23 matches
Mail list logo
