Hi Charles,
I believe you would already have bin-log configured, is that right? If not, you
need to.
Secondly, If you think the bin-log generated for the entire stack of
databases/schemas is too big, you may want to restrict it using "binlog-do-db"
BUT that may create problem if you have any D
I guess, it only makes things even more simple.
You should use "replicate-do-table=db1.tb1" and so one in slave's cnf to ensure
that only this particular table gets replicated. However, all the databases on
master will get bin-logged and you may or may not want to do that.
So making it even s
Hello Rick,
I think I'll go with your recommendations - but help me here a little bit.
Because all look fuzzy like a brain surgery. So make it simple and clean for me.
For the sake of simplicity, here is what my master has:
Database: db1
Tables: db1tb1, db1tb2, db1tb3
Database: db2
Table
Here's the use case that screws up a lot of people:
USE db_that_is_not_replicated;
INSERT INTO db_that_IS_replicate.tbl ...;
Surprise! That INSERT is not replicated. Workaround: *wild will notice it.
The other way around, the INSERT will be replicated, then hang replication
because the table
Doing both is redundant. Doing binlog (on the Master) is more efficient
because it eliminates sending the other dbs.
> -Original Message-
> From: a.sm...@ukgrid.net [mailto:a.sm...@ukgrid.net]
> Sent: Wednesday, May 02, 2012 8:50 AM
> To: mysql@lists.mysql.com
> Subject: Re: Can the mysq
Nothing in the slave's my.cnf.
On the Master, binlog-do/ignore-* filters before leaving the Master.
On the Slave, replicate-do/ignore-* (if used) would filter after getting to the
Slave.
That is, you _could_ do the replicate-* instead of the binlog-*, but that would
be inefficient. Doing both
Some mixture. Perhaps 35% of RAM for buffer_pool and 10% for key_buffer. It
depends on which needs more caching.
Note: The key_buffer does not need to be bigger than the total of all MyISAM
indexes (Index_length in SHOW TABLE STATUS, or size of .MYI files). The
buffer_pool does not need to
Hello Rick,
What goes into your my.cnf slave ?
Given dbname1 and dbname2
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: Wednesday, May 02, 2012 12:05 PM
To: Brown, Charles
Cc: mysql@lists.mysql.com
Subject: RE: Can the mysql replication limited to one databas
RBR solves the default db case..
S
On Wed, May 2, 2012 at 1:25 PM, Claudio Nanni wrote:
> I recommend to use the 'wild' modifier, if you have a default db and you
> specify the schema in the query like update
> schemanotreplicated.mytable. you will miss that.
>
> Claudio
>
> 2012/5/2 Rick
I recommend to use the 'wild' modifier, if you have a default db and you
specify the schema in the query like update
schemanotreplicated.mytable. you will miss that.
Claudio
2012/5/2 Rick James
> Yes, doable. In my.cnf on master:
> Binlog-do-database = dbname1
> Binlog-do-database = db
Yes, doable. In my.cnf on master:
Binlog-do-database = dbname1
Binlog-do-database = dbname2
Would replicate those two dbs only.
There are many other combinations using
binlog/replicate-do/ignore-db/table/wild. See the manual on replication, and
especially the flowchart on how those interact
On Wed, May 2, 2012 at 4:58 AM, vishesh kumar wrote:
> I am getting following in error log
>
>
> 120502 07:52:05 mysqld started
> 120502
Quoting "Brown, Charles" :
Can the mysql replication limited to selected schema or database?
Hi, yes it can. On the master side you control what is written to the
binlog with my.cnf entries for each DB like:
binlog-do-db=DB1
binlog-do-db=DB2
And on the slave side you use entries like:
r
I think you need deal with only these:
* Diff my.cnf (set as a parameter to mysqld)
* Diff tree for all the data (and reflect this in my.cnf)
* Diff port (3306 can't be shared between the instances)
> -Original Message-
> From: Andrés Tello [mailto:mr.crip...@gmail.com]
> Sent: Wedne
Thread_stack_size should be at least 256K (maybe more?)
Other memory issues to check on:
http://mysql.rjweb.org/doc.php/memory
> -Original Message-
> From: vishesh kumar [mailto:linuxtovish...@gmail.com]
> Sent: Wednesday, May 02, 2012 4:58 AM
> To: Reindl Harald
> Cc: mysql@lists.mys
- Original Message -
> From: "Reindl Harald"
>
> why does this idiotic list-server not add
> Precedence-Headers to supress autoreplies?
How many autoreplies did you get to that? :-D
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras e
On 04/27/2012 03:26 PM, Shawn Green wrote:
I frequently need to have multiple versions ready to operate on my
machine at any time. I solved the configuration file problems by only
setting them up in the basedir of the installed version.
For those special occasions when I need to configure multip
Sever OS is CentOS 5 and limits.conf settings is unlimited for open files .
Thanks
~Vishesh
On Wed, May 2, 2012 at 5:37 PM, LinuxInfo wrote:
> Hello,
>
> what is the Server OS? I know on my Ubuntu Server i have config the
> /etc/limits.conf and the my.cnf
> After the modification you have to r
Hi,
I am pleased to announce the release of ODB 2.0.0.
ODB is an open source object-relational mapping (ORM) system for C++. It
allows you to persist C++ objects to a relational database without having
to deal with tables, columns, or SQL and without manually writing any of
the mapping code.
Maj
Hello,
what is the Server OS? I know on my Ubuntu Server i have config the
/etc/limits.conf and the my.cnf
After the modification you have to restart the Server.
Am 02.05.2012 um 13:58 schrieb vishesh kumar :
> I am getting following in error log
>
>
I am getting following in error log
120502 07:52:05 mysqld started
120502 7:52:05 [Warning] Asked for 196608 thread stack, but got 1269
Thanks for response .
I didn't set any open_files limit in my.cnf .
For testing i set open_files_limit to 300 but still MySQL crashing after
128.
~Vishesh
On Wed, May 2, 2012 at 4:28 PM, Reindl Harald wrote:
>
>
> Am 02.05.2012 12:52, schrieb vishesh kumar:
> > Hi Members,
> >
> > I am using My
Am 02.05.2012 12:52, schrieb vishesh kumar:
> Hi Members,
>
> I am using MySQL 5.0.67 . I am facing the problem of MySQL crashing
> problem . MySQL Crash after every a few minutes . On investigation i
> noticed that when the Open_files status variable reach 128 MySQL Crash and
> i get followin
23 matches
Mail list logo
