[Cialug] Re: Cialug Digest, Vol 19, Issue 28
Carter McCann
cmccann at novacoast.com
Thu Nov 16 11:18:40 CST 2006
Thanks for the opportunity to speak to you guys. I apologize for
leaving early. I was not feeling well.
Carter McCann, CNS,NCTS
Novacoast, Inc
Midwest Client Executive
402-637-5551
cmccann at novacoast.com
Novacoast, Inc
800 949 9933 ext 5117
fax: 805-564-1809
www.novacoast.com
>>> <cialug-request at cialug.org> 11/15/06 12:00 PM >>>
Send Cialug mailing list submissions to
cialug at cialug.org
To subscribe or unsubscribe via the World Wide Web, visit
http://cialug.org/mailman/listinfo/cialug
or, via email, send a message with subject or body 'help' to
cialug-request at cialug.org
You can reach the person managing the list at
cialug-owner at cialug.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Cialug digest..."
Today's Topics:
1. Re: mysql replication (Dave J. Hala Jr.)
2. Re: mysql replication (Dave Weis)
3. Re: mysql replication (Dave J. Hala Jr.)
4. Ok, Introduction.. (Jim Cole)
----------------------------------------------------------------------
Message: 1
Date: Wed, 15 Nov 2006 10:36:07 -0600
From: "Dave J. Hala Jr." <dave at 58ghz.net>
Subject: Re: [Cialug] mysql replication
To: Central Iowa Linux Users Group <cialug at cialug.org>
Message-ID: <1163608567.2124.1131.camel at dsl-69.marshallnet.com>
Content-Type: text/plain
On mysql 4.x you need to add a line like the following in the my.cnf on
the master and slave for each db you want to replicate.
replicate-do-db=dbdname
I'm guessing that it applies no matter table type you are using.
You'll also need a replication username, password and that account will
have to have replication privileges.
:) Dave
On Wed, 2006-11-15 at 10:26, Dave Weis wrote:
> Has anyone gotten it working? I think I have it set up correctly but
the
> master shows:
> mysql> show master status;
> +------------------+----------+--------------+------------------+
> | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
> +------------------+----------+--------------+------------------+
> | mysql-bin.000002 | 203328 | | |
> +------------------+----------+--------------+------------------+
> but all of the examples I've seen show something in the Binlog_Do_DB
> column. I have the following lines in the my.cnf
> log-bin = mysql-bin
> server-id = 1
> innodb_data_home_dir = /var/lib/mysql/
> innodb_data_file_path = ibdata1:2000M:autoextend
> innodb_log_group_home_dir = /var/lib/mysql/
> innodb_log_arch_dir = /var/lib/mysql/
> innodb_buffer_pool_size = 768M
> innodb_additional_mem_pool_size = 128M
> innodb_log_file_size = 512M
> innodb_log_buffer_size = 256M
> innodb_flush_log_at_trx_commit = 1
> sync_binlog = 1
> innodb_safe_binlog = 1
>
> The files are innodb format.
>
> Thanks
> dvae
--
Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606 www.osis.us
Save a life: Adopt a shelter animal!
------------------------------
Message: 2
Date: Wed, 15 Nov 2006 10:41:02 -0600 (CST)
From: Dave Weis <djweis at internetsolver.com>
Subject: Re: [Cialug] mysql replication
To: Central Iowa Linux Users Group <cialug at cialug.org>
Message-ID:
<Pine.LNX.4.63.0611151039380.23310 at charmed.internetsolver.com>
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
On Wed, 15 Nov 2006, Dave J. Hala Jr. wrote:
> On mysql 4.x you need to add a line like the following in the my.cnf
on
> the master and slave for each db you want to replicate.
> replicate-do-db=dbdname
> I'm guessing that it applies no matter table type you are using.
> You'll also need a replication username, password and that account
will
> have to have replication privileges.
It looks like if they are blank it does all of the databases. I put in
to
ignore the mysql database itself and that does show up. I want it to
copy
everything so I didn't know if it would show % or something.
Everything seems to be going now. It doesn't restart itself very clean
after unplanned restarts of either end...
> On Wed, 2006-11-15 at 10:26, Dave Weis wrote:
>> Has anyone gotten it working? I think I have it set up correctly but
the
>> master shows:
>> mysql> show master status;
>> +------------------+----------+--------------+------------------+
>> | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
>> +------------------+----------+--------------+------------------+
>> | mysql-bin.000002 | 203328 | | |
>> +------------------+----------+--------------+------------------+
>> but all of the examples I've seen show something in the Binlog_Do_DB
>> column. I have the following lines in the my.cnf
>> log-bin = mysql-bin
>> server-id = 1
>> innodb_data_home_dir = /var/lib/mysql/
>> innodb_data_file_path = ibdata1:2000M:autoextend
>> innodb_log_group_home_dir = /var/lib/mysql/
>> innodb_log_arch_dir = /var/lib/mysql/
>> innodb_buffer_pool_size = 768M
>> innodb_additional_mem_pool_size = 128M
>> innodb_log_file_size = 512M
>> innodb_log_buffer_size = 256M
>> innodb_flush_log_at_trx_commit = 1
>> sync_binlog = 1
>> innodb_safe_binlog = 1
>>
>> The files are innodb format.
>>
>> Thanks
>> dvae
>
--
Dave Weis
djweis at internetsolver.com
http://www.internetsolver.com/
------------------------------
Message: 3
Date: Wed, 15 Nov 2006 10:42:53 -0600
From: "Dave J. Hala Jr." <dave at 58ghz.net>
Subject: Re: [Cialug] mysql replication
To: Central Iowa Linux Users Group <cialug at cialug.org>
Message-ID: <1163608973.2124.1137.camel at dsl-69.marshallnet.com>
Content-Type: text/plain
No it doesn't, my experience has been that the best way to stop is stop
the slave, then the master.
On Wed, 2006-11-15 at 10:41, Dave Weis wrote:
> On Wed, 15 Nov 2006, Dave J. Hala Jr. wrote:
> > On mysql 4.x you need to add a line like the following in the my.cnf
on
> > the master and slave for each db you want to replicate.
> > replicate-do-db=dbdname
> > I'm guessing that it applies no matter table type you are using.
> > You'll also need a replication username, password and that account
will
> > have to have replication privileges.
>
> It looks like if they are blank it does all of the databases. I put in
to
> ignore the mysql database itself and that does show up. I want it to
copy
> everything so I didn't know if it would show % or something.
>
> Everything seems to be going now. It doesn't restart itself very clean
> after unplanned restarts of either end...
>
> > On Wed, 2006-11-15 at 10:26, Dave Weis wrote:
> >> Has anyone gotten it working? I think I have it set up correctly
but the
> >> master shows:
> >> mysql> show master status;
> >> +------------------+----------+--------------+------------------+
> >> | File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
> >> +------------------+----------+--------------+------------------+
> >> | mysql-bin.000002 | 203328 | | |
> >> +------------------+----------+--------------+------------------+
> >> but all of the examples I've seen show something in the
Binlog_Do_DB
> >> column. I have the following lines in the my.cnf
> >> log-bin = mysql-bin
> >> server-id = 1
> >> innodb_data_home_dir = /var/lib/mysql/
> >> innodb_data_file_path = ibdata1:2000M:autoextend
> >> innodb_log_group_home_dir = /var/lib/mysql/
> >> innodb_log_arch_dir = /var/lib/mysql/
> >> innodb_buffer_pool_size = 768M
> >> innodb_additional_mem_pool_size = 128M
> >> innodb_log_file_size = 512M
> >> innodb_log_buffer_size = 256M
> >> innodb_flush_log_at_trx_commit = 1
> >> sync_binlog = 1
> >> innodb_safe_binlog = 1
> >>
> >> The files are innodb format.
> >>
> >> Thanks
> >> dvae
> >
--
Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606 www.osis.us
Save a life: Adopt a shelter animal!
------------------------------
Message: 4
Date: Wed, 15 Nov 2006 11:38:08 -0600
From: "Jim Cole" <jrcole at gmail.com>
Subject: [Cialug] Ok, Introduction..
To: cialug at cialug.org
Message-ID:
<e412f1de0611150938q5fc4abacv9d038fd2ecdb7afb at mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"
I signed up for the APC event and so I might see some of you guys there.
I wanted to introduce myself since I haven't attended any meetings and
I'm a
newbie to Iowa.
I've worked in IT for almost 20 years..first in a television station (9
years) and now I work for McKesson Corp implementing surgical systems in
hospitals around the country. McKesson is huge on telecommuting so
they've
let me live in Mankato, Mn(3 years), Rhode Island(5 years) and now
Nevada,
IA(6 months) other than the 1.5 years working out of the office in
Roseville, Mn.
I either travel to the customer data centers and/or connect into them
remotely from my house to do my work..which is mostly on SQL 2000/2005
and
Windows 2000/2003 machines but I've also spent a few years on HPs, IBMs
and
even DG unix machines running Oracle.
I'm liking Iowa..my family(wife and 2 kids) are liking it. I think this
is
the place where I belong.
Anyway, I'd like to network with you guys and get some IT friends from
the
area. Since I work out of my house and my office is in Mn(I go there
once a
year)..It's hard to actually meet local IT people. I think if I had a
local
job it'd be different but you're kind of isolated when you work from
home.
I'll see some of you at the APC event,
-Jim
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://cialug.org/pipermail/cialug/attachments/20061115/79af3376/attachment.html
------------------------------
_______________________________________________
Cialug mailing list
Cialug at cialug.org
http://cialug.org/mailman/listinfo/cialug
End of Cialug Digest, Vol 19, Issue 28
**************************************
More information about the Cialug
mailing list