Hi everyone
i have 4 mysql servers out of those one server will
be online always and the remaining will be offline and online. the
operations takes place at the offline servers i want to replicate the
data from the offline servers to the online server. for this can any
one help me
if the server is offline , what kind of operation happens on it.
On Thu, Aug 2, 2012 at 11:31 AM, Pothanaboyina Trimurthy
skd.trimur...@gmail.com wrote:
Hi everyone
i have 4 mysql servers out of those one server will
be online always and the remaining will be offline and
There's nothing built in but if you want explore this it is an extension
http://www.securich.com/
On 1 Aug 2012 21:56, Aastha aast...@gmail.com wrote:
Hello,
I have 10 different users and i have to give different accesses to
different tables.
Is it possible to create a groups with
Hi All,
Not sure if anyone has implemented a Proxy for a Master Master Replication
of MySQL, is it doable ? If yes, how, which tools can be used ?
[image: Inline image 1]
Generally Master A will be Master when Proxy hits Master A and Master B
will be slave
When Master A is not able to reach or
There's nothing built in but if you want explore this it is an extension
http://www.securich.com/
That seems like a nice extension.
With regards,
Martijn Tonies
Upscene Productions
http://www.upscene.com
Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL,
1 Master replicationg to 3 Slaves.
You can use any of the Slaves for readonly (online), or you can not use them
(offline).
All writes go to the Master. It will be online for writes, and optionally
online for reads.
-Original Message-
From: Ananda Kumar [mailto:anan...@gmail.com]
I don't really know how to use those files and so like to know how to
stop populating them. or at least control the number and size of them.
I'm running os x 10.6.8, mysql Server version: 5.1.61-log MySQL
Community Server (GPL)
I tried comment out the line log-bin=mysql-bin and those
I don't really know how to use those files and so like to know how to
stop populating them. or at least control the number and size of them.
Used for: disaster recovery / replay modifications on backup, or replication
afaik.
Days kept: expire_log_days:
expire_logs_days=7
and restart the server.
Keep log-bin if you have replication or want a certain flavor of backup.
my.cnf file changes do not take effect until you restart mysqld.
-Original Message-
From: Elim Qiu [mailto:elim@gmail.com]
Sent: Thursday, August 02, 2012 9:56 AM
Hm, due to some popups that was a premature sending... Mea culpa
I don't really know how to use those files and so like to know how to
stop populating them. or at least control the number and size of them.
Used for: disaster recovery / replay modifications on backup, or
replication afaik.
Hi ,,
It would be helpful if you could share the error messages.
Do any of these:
1) Add these lines to my.cnf file:
expire_logs_days = 7
2) Or Try this
log-bin=OFF
or simply u can comment the lines related to the log-bin.
3) Other than this,
if you are using
Thanks a lot to all helped me out. Really appreciated.
Rik Wasmus,
Thanks for the Binary Log Documentation
http://dev.mysql.com/doc/refman/5.0/en/replication-options-binary-log.html#sysvar_max_binlog_size
Rick James,
I'll try this: expire_logs_days=7
Vikas Shukla,
My server-id is 1 (thought
master.info is set by executing CHANGE MASTER TO...
relay-log.info gets created either then or when you do SLAVE START, or
something like that.
-Original Message-
From: Carl Kabbe [mailto:c...@etrak-plus.com]
Sent: Wednesday, July 25, 2012 11:35 AM
To: Richard Reina
Cc:
13 matches
Mail list logo