Re: Problem running multi master replication

Shawn Green wrote: I understand now. You have 3 slave server processes replicating independently from their own separate master servers. You have a fourth MySQL server process that shares the same data files as your 3 slaves but it does not know when replication occurs and when it hasn't

Problem running multi master replication

Hi All, I have a problem with my multi master replication plan. I have set my server (linux) to run 4 instance of mysqld, each with a different port, socket, tmpdir, log file, relay log file, master info and relay info. the illustration as follow : Server 1 (non slave) db1 db2 db3

Re: Problem running multi master replication

[EMAIL PROTECTED] wrote: Leonardus Setiabudi [EMAIL PROTECTED] wrote on 04/07/2006 05:33:50 AM: Hi All, I have a problem with my multi master replication plan. I have set my server (linux) to run 4 instance of mysqld, each with a different port, socket, tmpdir, log file, relay log file

Re: crosstabs and pivot tables

hi there this might be an extreme solution.. but i thought you could come up with just one query instead of 20 temp tables.. if you dont mind to write it :) select id, max(if(datetype='entered_date',date,'')) entered_date, max(if(datetype='modified_date',date,'')) modified_date,

Re: Prepared Statement questions/issues

Hi Ken.. this might not solve your problem.. but, did you really have to do this create table raddata ( granIDinteger not null, scanIDtinyint unsigned not null, fpID tinyint not null, c1smallint, c2

Re: Problem with 4.1.3 that I not had with 4.0.20

try this query SELECT bytes, bytes_priv, bytes_bus, hits, hits_priv, hits_bus, bytes - ( bytes_priv + bytes_bus ), hits - (hits_priv + hits_bus) FROM url_cat_copy WHERE (bytesround(bytes_priv+bytes_bus,0)) or (hitsround(hits_priv + hits_bus,0)) i think its got something to do with the decimal

Re: special order

that will work.. or if you can guarantee that it always prefixed with '#' you can try select id from mydata order by if(left(id,1)='#',concat('z',id),id) or if you didnt sure.. you can try the similiar way.. select id from mydata order by if(left(id,1)'A',concat('z',id),id) just make sure that

Function to multiply multiple row values

Select sum(x) would return 10 right.. Now I need a function .. Say fx() so that when I issued Select fx(x) ... It would return 24 which is 1x2x3x4 Is there any function like that in mysql?? I know I can do this with stored procedure.. But I'm using 4.1.3 Please help TIA -- Leonardus

Re: Function to multiply multiple row values

x --- 1 2 3 4 Select sum(x) would return 10 right.. Now I need a function .. Say fx() so that when I issued Select fx(x) ... It would return 24 which is 1x2x3x4 I assume that the function that yielded 24 was fx(4), not fx(x). In high school math, which was a