Hi,
I have two servers Mysql 5.5 with master to master replication.
The second server failed and I needed to remove it to repair the operating
system.
After this incident the application users have been notice that the
application response have been very slow.
Both servers have RAID 1 (mirroring)
> > >
> > >-Original Message-
> > >From: Machiel Richards [mailto:machi...@rdc.co.za]
> > >Sent: 02 June 2010 9:41 AM
> > >To: mysql@lists.mysql.com
> > >Subject: Strange errors / messages on slave server
> > >
> > &
mailto:machi...@rdc.co.za]
> >Sent: 02 June 2010 9:41 AM
> >To: mysql@lists.mysql.com
> >Subject: Strange errors / messages on slave server
> >
> >Good day all
> >
> >
> >
> > I hope someone can assist me with this.
> >
> >
> >
>
Thank you for the response...
My question now is, will I be able to set the innodb buffer pool size for
the slave server to be the same as the master server?
If so, can I only restart the slave server and keep the master server
running in order to cancel out the requirement for downtime?
On
>-Original Message-
>From: machiel.richards [mailto:machiel.richa...@gmail.com]
>Sent: Wednesday, June 02, 2010 3:56 AM
>To: mysql@lists.mysql.com
>Subject: RE: Strange errors / messages on slave server
>
>Hi All
>
> Just one other note on this issue ex
.
However, this change is only done on the master server and not on
the slave server.
I am not sure how the buffer pools are handled in replication
though, but would this not perhaps need to be set on the slave server as
well.
My thinking around this is that the error occurred specifically
Good day all
I hope someone can assist me with this.
While doing the normal routine daily health checks on one of
our clients' servers I came across some strange behaviour from the slave
server. (two servers setup in master / slave replic
, 6 February, 2010 3:05:25 PM
>
> *Subject:* Re: MY SQL Slave Server
>
> Hi Vikram,
>
> Ya sure, slave can be in vista. Yes, you can install 2 or more setups in
> same system but port has to be different, and if its linux platform change
> the sock name too.
>
> Rega
0:08 PM, Vikram A wrote:
> I tried to install once again mysql at vista? but deducts the previous
> installation. and it is ask for the modify , repire and remove options
>
> You said that we can install any number of setups in a same system.
>
> Is there any other way to install
From: Thiyaghu CK
To: Vikram A
Sent: Sat, 6 February, 2010 3:05:25 PM
Subject: Re: MY SQL Slave Server
Hi Vikram,
Ya sure, slave can be in vista. Yes, you can install 2 or more setups in same
system but port has to be different, and if its linux platform change the sock
name
Hi Vikram,
So as my understanding you need to have a master slave setup in a single
machine(FEDORA 11).
1. Make the already running mysql instance as Master
2. Install a new mysql in the same machine in different port which will be
your slave
3. Replicate
4.You can also add more slave in same mac
Dear Experts,
I would like to configure the slave for my main server. My server is running in
the FEDORA 11.
I would like to make another mirror of the DB in the same server/ The copy of
the DB can be kept at win server / another Fedora server.
Can you suggest how to do the above?
Thank you
In the last episode (Oct 13), AM Corona said:
> In mysql 4, can one replicate a database to another server but have the DB
> name on the slave server be different?
>
> Master : dbname1
> Slave: dbname1
> AND
> Slave : dbname2 (but contains data from db2name1)
So you want
On Mon, Oct 13, 2008 at 11:43 AM, AM Corona <[EMAIL PROTECTED]> wrote:
> In mysql 4, can one replicate a database to another server but have the DB
> name on the slave server be different?
>
> Master : dbname1
> Slave: dbname1
> AND
> Slave : dbname2 (but contain
In mysql 4, can one replicate a database to another server but have the DB
name on the slave server be different?
Master : dbname1
Slave: dbname1
AND
Slave : dbname2 (but contains data from db2name1)
A project manager is asking for this.. don't blame the guy asking :-)
Regards,
M
p; Review
> -Original Message-
> From: Shanmugam, Dhandapani [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 12:14 AM
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Slave Server
>
>
> Hi There,
>
> I am setting up a replication with one m
>-Original Message-
>From: Shanmugam, Dhandapani [mailto:[EMAIL PROTECTED]
>Sent: Friday, May 16, 2008 4:01 AM
>To: Phani; Ananda Kumar
>Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
>Subject: RE: Slave Server
>
>
>Ok..But if I do any changes on slave databases
, Dhandapani [mailto:[EMAIL PROTECTED]
>> Sent: Friday, May 16, 2008 1:07 PM
>> To: Ananda Kumar
>> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
>> Subject: RE: Slave Server
>>
>> No Anand..My question is ..If the developer do any changes on the slave
>>
23390080 | Ext: 337 | F +91 40 23390934 |
> Vongage +1 714 209 7484
>
> -Original Message-
> From: Shanmugam, Dhandapani [mailto:[EMAIL PROTECTED]
> Sent: Friday, May 16, 2008 1:07 PM
> To: Ananda Kumar
> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: RE:
ailto:[EMAIL PROTECTED]
Sent: Friday, May 16, 2008 1:25 PM
To: Shanmugam, Dhandapani; 'Ananda Kumar'
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: Slave Server
You can try circular replication between server. So each server will act
as both Master and Slave.
Regards,
Phani | B
Message-
From: Shanmugam, Dhandapani [mailto:[EMAIL PROTECTED]
Sent: Friday, May 16, 2008 1:07 PM
To: Ananda Kumar
Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
Subject: RE: Slave Server
No Anand..My question is ..If the developer do any changes on the slave
server, it will not get reflected to the
No Anand..My question is ..If the developer do any changes on the slave
server, it will not get reflected to the Master server right? So there
will be data inconsistency. My requirement is When the developer do any
testing on slave databases. I need to revert back as of Master server
data...In
Hi Shanmugam,
Your question quite confusing.
Do you mean to say, if any changes happen to slave it should get refeleted
in the master, if yes, then u can setup two masters which are slave to each
other.
regards
anandkl
On 5/16/08, Shanmugam, Dhandapani <[EMAIL PROTECTED]> wrote:
>
>
> Hi There,
Hi There,
I am setting up a replication with one master and one slave.
I have created two databases in Master Server and it gets replicated to
the slave. When developer do changes on the slave database, It will not
be sync with the Master server. My requirement is when ever developer do
changes
Ashok Chauhan wrote:
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master & Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
queries.
if yes, then how ?.
Thanks
Ashok
T
Sep 2007 07:05:31 +0200, Ashok Chauhan <[EMAIL PROTECTED]
> >
> > wrote:
> >
> >> Hi All,
> >>
> >> I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and
> 8GB
> >> of RAM.
> >> Master & Slave servers
> On Fri, 07 Sep 2007 07:05:31 +0200, Ashok Chauhan <[EMAIL PROTECTED]>
> wrote:
>
>> Hi All,
>>
>> I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
>> of RAM.
>> Master & Slave servers have same hardware configration.
&
On Fri, 07 Sep 2007 07:05:31 +0200, Ashok Chauhan <[EMAIL PROTECTED]>
wrote:
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master & Slave servers have same hardware configration.
Now i want to know, should i use slave server for fet
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master & Slave servers have same hardware configration.
Now i want to know, should i use slave server for fetching read only
queries.
if yes, then how ?.
Thanks
Ashok
--
MySQL General Mailing
2:37 AM
> To: mysql@lists.mysql.com; [EMAIL PROTECTED]
> Subject: Error in mysql slave server
>
> Hi All,
>
> I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2
> CPU and 8GB
> of RAM.
> Master & Slave servers have same hardware configration.
>
Hi All,
I'm using Mysql 5 (with replication) on CentOS 4.4 OS with 2 CPU and 8GB
of RAM.
Master & Slave servers have same hardware configration.
Yesterday my master server, suddenly not established new connections.
i checked the log of master server there is no error, then i checked the
log of sl
Is there a way to check that data on slave server is the same as data on
master ?
Thanks
From: Paul DuBois <[EMAIL PROTECTED]>
To: "Mike Mapsnac" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject: Re: updates on slave server??
Date: Mon, 26 Jan 2004 21:58:42 -0600
At 0:
ncy in replication.
John A. McCaskey
-Original Message-
From: Mike Mapsnac [mailto:[EMAIL PROTECTED]
Sent: Monday, January 26, 2004 4:50 PM
To: [EMAIL PROTECTED]
Subject: updates on slave server??
Hello
I found today that some data on slave server were different than on master
ser
At 0:49 + 1/27/04, Mike Mapsnac wrote:
Hello
I found today that some data on slave server
were different than on master server. I dont
know how that can happen. Slave server was
running, "show slave statu"s show no errors
If I make some updates on slave server. Does this updat
Hello
I found today that some data on slave server were different than on master
server. I dont know how that can happen. Slave server was running, "show
slave statu"s show no errors
If I make some updates on slave server. Does this updates will be reflected
on
master server? Or sl
nal Message-
From: Dan Rossi [mailto:[EMAIL PROTECTED]
Sent: Sunday, March 02, 2003 7:33 PM
To: Dan Rossi; [EMAIL PROTECTED]
Subject: RE: permissions error for the slave server
has anyone got any idea why it wont let the slave connect properly ?
here is my slave settings
port
-host=localhost
report-port=3307
server-id=2
-Original Message-
From: Dan Rossi [mailto:[EMAIL PROTECTED]
Sent: Saturday, March 01, 2003 7:55 PM
To: [EMAIL PROTECTED]
Subject: RE: permissions error for the slave server
hi there my sql slave server cannot replicate as its getting
hi there my sql slave server cannot replicate as its getting permissions
errors dont know what happened but its not happy now
030302 7:09:24 Slave I/O thread killed while connecting to master
030302 7:09:24 Slave I/O thread exiting, read up to log 'FIRST', position
4
030302 7:09:2
ailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 26, 2002 2:14 PM
To: Carl McNamee
Cc: [EMAIL PROTECTED]
Subject: Re: Question about slave server
Carl,
- Original Message -
From: "Carl McNamee" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, Novem
Carl,
- Original Message -
From: "Carl McNamee" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, November 26, 2002 11:10 PM
Subject: Question about slave server
> sql,query
>
> In a replicated environment, are slave servers "read only&
sql,query
In a replicated environment, are slave servers "read only" or can a user
attach to one and perform updates?
Carl McNamee
Systems Administrator
Billing Concepts
(210) 949-7282
-
Before posting, please check:
http://w
On Fri, Oct 04, 2002 at 12:51:16AM +0300, Heikki Tuuri wrote:
>
> only successful queries are written to the binlog and replicated. It is a
> bug in MySQL replication if a duplicate key error in the master is
> propagated to the slave.
Or someone accidentallly muged data on the slave. We've had
James,
- Original Message -
From: "James Kelty" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, October 04, 2002 12:13 AM
Subject: Slave server and InnoDB
> sql,query
>
> Hello.
>
> Is there an option for the slave server to NOT stop
sql,query
Hello.
Is there an option for the slave server to NOT stop when an error
inducing query is run on the master?
For instance, if someone tries in insert a duplicate entry, and the
master shows the error, but updates the binlog, how can I keep the slave
from seeing the same error, and
d max_allowed_packet - increase max_allowed_packet on master
(read_errno 0,server_errno=65535)
On the master, max packet is set to 8M.I have one slave server working
correctly and the other isn't.
Justin Best
NOC - Infostations
---
Well, if it is read only, it won't be able to update from the master.
GRANT your users no write permission.
Pierre Baridon wrote:
>
> is it possible to start a server in 'read only' mode ?
> so that users cannot write in my slave server ?
>
> thanks,
>
&
is it possible to start a server in 'read only' mode ?
so that users cannot write in my slave server ?
thanks,
Pierre
--sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (
On Thu, Oct 25, 2001 at 06:53:28PM -0500, William Robbins wrote:
> I am getting this error message on my slave server
>
> 011025 16:46:14 mysqld started
> /usr/local/mysql/libexec/mysqld: ready for connections
> 011025 16:46:14 Slave thread: error connecting to master: Unknown
I am getting this error message on my slave server
011025 16:46:14 mysqld started
/usr/local/mysql/libexec/mysqld: ready for connections
011025 16:46:14 Slave thread: error connecting to master: Unknown MySQL
Server Host '' (0) (0), retry in 60 sec
This is my my.cnf config file on
CREATE DATABASE command is not replicated in the slave server. The database
is created on the master but not on the slave. The SQL statement does not
appear in the replication log file on the MASTER.
I have set the master to ignore replicating one database on the master. Is
this causing
50 matches
Mail list logo
