mysql-bin maintenance

Hi, In the master database, there are plenty of mysql-bin.X. It occupied almost all the disk space. As I know, the files should be removed by issuing reset master. Below are my questions. -Do I need to stop replication before issuing reset master? If yes, do I need to rebuild the replication

ot: callablestatement

HI , I am using java to call store procedure as following. However, the program hangs when it reaches the line 30 below. Any clue to make it works? ... 30: CallableStatement cs = myConn.prepareCall({ call proc1() }); 31: cs.execute(); ... -- MySQL General Mailing List For list archives: http:/

Re: 2 cursors in a store procedure

wrote: > > At 10:57 AM +0800 2/11/08, Rilawich Ango wrote: > >HI all, > > > > How can a store procedure to contain 2 cursors? Any advise? > > > >ango > > > >create procedure a() > >begin > > declare ... > > declare c1 c

2 cursors in a store procedure

HI all, How can a store procedure to contain 2 cursors? Any advise? ango create procedure a() begin declare ... declare c1 cursor for select ... declare contine handler for not found set x=1; declare c2 cursor for select ... declare contine handler for not found set y=1; -- M

question on replication

Hi all, Most of the web site and document talk about master to slave or master to slaves setting. Is it possible to do masters to slave replication? Say I have 2 masters, one has a database call d1 and other one has a database call d2. I want to replicate both d1 and d2 to a slave. Is it poss

database replication question

Hi, As I know, master will replicate all database to the slave in default. If I want to replicate only specified database, we can use parameter in master. binlog-do-db=databasename I found that we can also use parameters to replicate database even table in slave. replicate-do-db=db_name (repli

master and slave in same machine

Hi, I tried to set a replication as below. S1(master) ---> S2 (slave), (master) --> S3 (slave) I have set S1 and S2 (slave) without problem. However, there is a problem in S2 as a master. I found the the position in "show master status" also keep as 98 but I am sure the replication from S2 to S1

innodb error

Recently, I got the following error. I found the solution to solve the problem by increasing the log file size. However, I want to know why this error will happen. I can't find the explanation for that error. Anyone can give me some information about the error? 070321 16:38:41 InnoDB: Starte

Re: 2 ways replication

replication? Any comparison about database replication? On 2/14/07, Rilawich Ango <[EMAIL PROTECTED]> wrote: Thanks for the links. It seems helpful for me. I will read it then. BTW, does anyone implement multi-master replication successfully? I have read a lot of document and they all

Re: 2 ways replication

icky. Look > for the "Dual master" section in chapter 7 of the High Performance MySQL > book: > http://dev.mysql.com/books/hpmysql-excerpts/ch07.html > > If you need more than 2 masters, then all bets are off.. > > > Atle > > > On Mon, 12 Feb 2007, Rilawich A

2 ways replication

Hi all, I know it is an old question and I have read from the mysql website about the topic. Until now, mysql still doesn't support 2 ways replication, quoted from mysql website. As I have multiple location and each location will have a DB. Most of all need to read and write to the database.