Re: [Maria-discuss] Per-db binlogging

2010-12-14 Thread Weldon Whipple
It's been awhile since I first posted about db-binlogging (actually, file-per-database binlogging). Our requirement is to enable the migration of a user account--including the user's MySQL database(s)--from one physical server to another, minimizing database downtime. After being briefly sidetrack

Re: [Maria-discuss] Per-db binlogging

2010-09-16 Thread Sergei Golubchik
Hi, Weldon! On Sep 16, Weldon Whipple wrote: > Sergei, > > Thanks for all the helpful links! I've been reading them as I > downloaded 5.5 with bzr and building the source. (In the process I > stumbled onto your and Andrew's new book on plugins. I bought an > electronic copy and downloaded it to m

Re: [Maria-discuss] Per-db binlogging

2010-09-16 Thread Weldon Whipple
Sergei, Thanks for all the helpful links! I've been reading them as I downloaded 5.5 with bzr and building the source. (In the process I stumbled onto your and Andrew's new book on plugins. I bought an electronic copy and downloaded it to my iPad to read tonight and this weekend. Hopefully the boo

Re: [Maria-discuss] Per-db binlogging

2010-09-16 Thread Sergei Golubchik
Hi, Weldon! On Sep 15, Weldon Whipple wrote: > > > See where mysql_bin_log.write is called. > > Excellent information! (I was hoping it might be that easy ???). If I > succeed in making a DB_BIN_LOG class derive from MYSQL_BIN_LOG (with an > instance of DB_BIN_LOG for each database that is curre

Re: [Maria-discuss] Per-db binlogging

2010-09-15 Thread Weldon Whipple
Henrik, Thanks for your response! (See my replies below.) On Wed, Sep 15, 2010 at 2:33 PM, Henrik Ingo wrote: > On Tue, Sep 14, 2010 at 3:02 AM, MARK CALLAGHAN wrote: >> +maria-discuss as they are working in replication too > > To be exact, maria-developers@ is the counterpart to intern...@mysq

Re: [Maria-discuss] Per-db binlogging

2010-09-15 Thread Weldon Whipple
Sergei, Thank you very much for your reply! A later post by Henrik Ingo seems to say that I should cc maria-disc...@lists.launchpad.net. I'll try it and see if it bounces--I THINK I'm registered with launchpad.net :-) Let me know if sending to both lists annoys anyone, and I will quit the cc :-)

Re: [Maria-discuss] Per-db binlogging

2010-09-15 Thread Henrik Ingo
On Tue, Sep 14, 2010 at 3:02 AM, MARK CALLAGHAN wrote: > +maria-discuss as they are working in replication too To be exact, maria-developers@ is the counterpart to intern...@mysql, although everyone should be reading maria-discuss@ too. I'm now leaving both in CC. > On Mon, Sep 13, 2010 at 1:52

Re: [Maria-discuss] Per-db binlogging

2010-09-13 Thread MARK CALLAGHAN
+maria-discuss as they are working in replication too +robert.hodges as tungsten replicator has features that could be used here I am very interested in a subset of this. I want one SQL thread per database on a slave (stream per database on the slave). However I don't need to split the binlog on t