Re: does mysql support master to master replication

I had seen a discussion here as well, but honestly did not test it. It may be of help. http://www.linkedin.com/groupItem?view=&srchtype=discussedNews&gid=72881&item=60056153&type=member&trk=eml-anet_dig-b_pd-ttl-cn On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote: > Hi, Folks: > > Does mysql su

Re: does mysql support master to master replication

MySQL, to my knowledge, supports only Master to Slave replication- as well as Master-slave-slave replication. http://dev.mysql.com/doc/refman/5.0/en/replication.html On Wed, Aug 3, 2011 at 1:10 AM, Angela liu wrote: > Hi, Folks: > > Does mysql support master to master replication, or master to

Re: does mysql support master to master replication

I have been using the M-M replication over years. But we only write to one node at any time. When this node is unusable, we write to another node. On Wed, Aug 3, 2011 at 1:10 PM, Angela liu wrote: > Hi, Folks: > > Does mysql support master to master replication, or master to slave > replication

does mysql support master to master replication

Hi, Folks: Does mysql support master to master replication, or master to slave replication on;y?  I did not find the answer in MySQL manual, but found some discussion over the internet. Does anybody know?  if so, anybody has implemented master to master replication in production? Thanks Ange

RE: Which is better

Hard to tell. It depends on the cardinality of tables' id (I assume the IDs are not unique in each of the tables). David. -Original Message- From: Shawn Green (MySQL) [mailto:shawn.l.gr...@oracle.com] Sent: Tuesday, August 02, 2011 2:47 PM To: Adarsh Sharma Cc: mysql@lists.mysql.com Subje

Re: Which is better

On 8/2/2011 02:41, Adarsh Sharma wrote: Dear all, Just want to know which join is better for querying data faster. I have 2 tables A ( 70 GB ) & B ( 7 MB ) A has 10 columns & B has 3 columns.Indexes exist on both tables's ids. select p.* from table A p, B q where p.id=q.id or select p.* fro

Too many aliases

2011/08/02 12:11 +0530, Adarsh Sharma select p.* from table A p, B q where p.id=q.id or select p.* from table B q , A p where q.id=p.id Why do people constantly change table names for queries, although, as here, it gain them nothing? It often makes for less clarity (for which

Re: Which is better

is optimizer depend on size of table? not sure On Mon, Aug 1, 2011 at 11:48 PM, Shafi AHMED wrote: > I hope the former better. > Test with query plan output, though > > Best Rgs, > Shafi AHMED > > > -Original Message- > From: Adarsh Sharma [mailto:adarsh.sha...@orkash.com] > Sent: Tuesday

Re: about the config file

correct, dash (“-”) and underscore (“_”) may be used interchangeably. http://dev.mysql.com/doc/refman/5.1/en/command-line-options.html On Tue, Aug 2, 2011 at 4:34 AM, Andrew Moore wrote: > Hey! > > I asked this one a long time ago. They are interchangeable in most cases. I > can recall there was

Re: results from a total of always amount to a multiple of 3

2011/08/01 09:48 +0700, HaidarPesebe Exactly what you are saying Mr. Sándor. I tried adding a recordamount of debt then becomes a multiple of 4. Well I'm really confused. Are there any who can help? how to call the databaseby entering on the right? What do you want from the jo

Re: about the config file

Hey! I asked this one a long time ago. They are interchangeable in most cases. I can recall there was one or two options (pid-file and log-error...I think?!) that were funky with the '_' but I can't be sure that's still an issue. Try them out and don't worry too much about the aesthetics of the f

Re: about the config file

yes. On Tue, Aug 2, 2011 at 3:48 PM, Feng He wrote: > Hello, > > In mysql's config file my.cnf, are the variable names with "_" and "-" the > same? > for example, > > log_error = ... > log-error = ... > > Thanks. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mys