RE: Strange Replication Behavior

2012-08-02 Thread Rick James
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: mysql@l

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Elim Qiu
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 that

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Vikas Shukla
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 se

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rik Wasmus
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

RE: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rick James
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 >

Re: manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Rik Wasmus
> 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: http://dev.mysql.com/doc/refman/5.5/en

manage mysql-bin.xxxxxx files on mac

2012-08-02 Thread Elim Qiu
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 mysql-bin.

RE: Replication setup hep

2012-08-02 Thread Rick James
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] > S

Re: create roles/groups in MYSQL

2012-08-02 Thread Martijn Tonies
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, In

Proxy for Master - Master Replication

2012-08-02 Thread Kishore Vaishnav
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

Re: create roles/groups in MYSQL

2012-08-02 Thread Andrew Moore
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" 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 different set of a