A, B, C, D are mysql Servers
On Dec 6, 2007 12:18 PM, ars k [EMAIL PROTECTED] wrote:
are A,B,C,D servers or separate mysql instances?
On Dec 6, 2007 10:18 AM, Krishna Chandra Prajapati [EMAIL PROTECTED]
wrote:
Does any body has tried this
On Dec 6, 2007 10:08 AM, Krishna Chandra
MySQL Proxy is good. It doesn't fit in some environments however.
Another option would be the QPP (Query Processing Programs) that I and a
co-worker have developed. They can be downloaded at
http://www.paragon-cs.com/queryprogs.
thanks
Keith
Michael Dykman wrote:
Have you considered:
You could also try http://hackmysql.com/mysqlsla
On Dec 6, 2007 9:23 AM, B. Keith Murphy [EMAIL PROTECTED] wrote:
MySQL Proxy is good. It doesn't fit in some environments however.
Another option would be the QPP (Query Processing Programs) that I and a
co-worker have developed. They can be
We have a master/master environment that has tables in innodb. We want to
setup a slave that will be used for reporting and some other stuff as well. We
want to use MyISAM as the engine on the slave'd server.
Since all of the table creations are also part of the replication, is it
possible
Hi Gary,
On Dec 6, 2007 10:56 AM, Gary W. Smith [EMAIL PROTECTED] wrote:
We have a master/master environment that has tables in innodb. We want to
setup a slave that will be used for reporting and some other stuff as well.
We want to use MyISAM as the engine on the slave'd server.
Since
When I run a Show slave status \G I get a message at the bottom that says
Error: No query specified
I don't recall ever seeing this before and can't find anything online about
it. Anyone know what it means?
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
DUH!!!
LOL, I'm an idiot..
Gonna go flush my head down the toilet now.
Thanks guys.
From: William Newton [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 1:29 PM
To: Jeff Mckeon; MySql
Subject: Re: Error: No query specified
I'm guessing you are adding a
Dear MySQL users,
MySQL Community Server 5.0.51, a new version of the popular Open Source
Database Management System, has been released. The release is now
available in source form (only) from our download pages at
http://dev.mysql.com/downloads/
and mirror sites.
Note that not all
No, I do not think this is possible.
-Original Message-
From: Krishna Chandra Prajapati [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 06, 2007 8:38 AM
To: ars k; MySql
Subject: Re: REPLICATION
A, B, C, D are mysql Servers
On Dec 6, 2007 12:18 PM, ars k [EMAIL
I'm guessing you are adding a semi-colon (;) to the end of the statement. Its
unnecessary with the \G
- Original Message
From: Jeff Mckeon [EMAIL PROTECTED]
To: MySql mysql@lists.mysql.com
Sent: Thursday, December 6, 2007 12:19:22 PM
Subject: Error: No query specified
When I run a
Are you sure you don't have a semicolon after the \G? That would do it.
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
-Original
You could convert all the tables on the slave to MyISAM after all the table
creates are done on the slave. Here are the six(6) steps to do this:
Step 1 : Make sure binary logging is turned off on the slave
Step 2: Copy the data over to the slave
mysqldump -hMasterIP -u... -p... givenDBName
Hey guys,
I have a big Problem. About 30 % of my databases just disappeared around
6pm today. I do not have any clue how this happened. Is can just guess
the time it happened from my munin graphs.
The only thing that might be a clue are the following files in my data
directory:
h1314631:~#
Hey,
Thanks for the very fast reply.
Of course I forgot that I'm running Linux Debian Etch with mysql 5.0.45
from backports.
We have a 20GB quota set for MySQL. Before the crash about 9GB where
used, now it's down to 5GB. I will unmount the disk and check the XFS
filesystem and report back
Hmm... mysqlsla is not bad
However, I was hoping for something to help dive into the SQL queries and
present their relation together in a single view of how the database and tables
are being used.
mysqlsla shows the unique queries being used. And I'd like to see from the other
end how the
Hi ,
Someone using typo3 try to update a field tx_templavoila.flex into a
table tt_content but get kicked out of typo3 without error message. The
user tried with PHPmyadmin but got the same result. First thought coming
to mind is the field is too small for the data being inserted but the
Does anyone know of a programming library/module (C or PERL or ?) to interface
with the MySQL binary logs?
Preferably a PERL module which wraps some C library to gain a PERL OO api
interface to manipulating MySQL Binary Logs.
If this does not exist, can someone point me at the API documentation
Hi ,
Someone using typo3 try to update a field tx_templavoila.flex into a
table tt_content but get kicked out of typo3 without error message. The
user tried with PHPmyadmin but got the same result. First thought coming
to mind is the field is too small for the data being inserted but the
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've been experimenting with mysql replication, specifically error
handling under varying error conditions. My tests are with 5.0.22 that
comes with CentOS 5.0.
My main concern is that I would like to lower the slave_net_timeout
setting, but don't
Have anyone out there any experience building, installing, and using
MySql on Leopard (PowerPC G4)
(MySql Community server 5.0.51) If so, I would be thankful for info on
possible problems.
--
Skinheads are so tired of immigration, that they are going to move to
Typo3 is a cms used to build web page and store its data into mysql. Never
used it myself but our clients do. It must be somewhat close to
dreamweaver and such. By kicked out i mean he get disconnected from typo3
and when he go back in the data is not inserted.
Éric Fournier
Technicien en
Ok, I ran xfs_check and the filesystem is all well. Does anybody else
have an idea?
Regards,
Samy
Samuel Vogel schrieb:
Hey,
Thanks for the very fast reply.
Of course I forgot that I'm running Linux Debian Etch with mysql
5.0.45 from backports.
We have a 20GB quota set for MySQL. Before
hi,
I wonder if mysql has something like ENUM() but instead ONLY ONE it
could be selected ANY COMBINATION of these offered solutioins?
If column is ENUM('a','b','c','d') I can select 'a' or 'b' or 'c' or
'd'. Clear.
Tough, I need SOMETHING('a','b','c','d') that I can select 'a' and 'b',
or
yes. just found it.
it's funny, I was looking for it last half hour and the second after I
sent the email - I found it.
:)
yes, yes... I know. RTFM
:D
thanks.
-afan
sol beach wrote:
SET Column type?
On Dec 6, 2007 2:01 PM, Afan Pasalic [EMAIL PROTECTED] wrote:
hi,
I wonder if mysql
Hi all,
I have a advanced servers 4 with 30 gb of ram please let me know the exact
details how much i have to configure and use the exact variables in the cnf
file and which one to be used.(innodb engine)
any my database size is upto 600gb how to take up the backup, using ibbackup my
system
You can set the default storage engine on each of the servers and then
don't declare it explicitly in any CREATE TABLE statements.
This seems like the most viable option. Since almost all of the remote
tables are created with INNODB it should work fine. I do have one table
that isn't but we
26 matches
Mail list logo