Hi,
I am setting up a replication with 1 master and multiple slave. My question
is can i use the same user (from master) for setting up replication on
multiple slaves. Is there any advantage for replication by creating
different user for different slave.
Thanks Regards,
--
Krishna Chandra
I think we can use the same replication account for all the slaves, as
having a user for each slave will be a maintenance headache.
On 4/9/08, Krishna Chandra Prajapati [EMAIL PROTECTED] wrote:
Hi,
I am setting up a replication with 1 master and multiple slave. My
question
is can i use the
[EMAIL PROTECTED] wrote:
Does this sound about right? Anybody see any road hazards? If not, and
this line of thinking is reasonable, should the DB with the older records
also be replicated so that when a new old records table needs to be
created, I don't have to repeat everything on the
It depends how public your database is. If you ever need to shut off
one client then you might use separate users. Otherwise it's just
annoying complexity, use a single user.
Remember to use a different 'server-id' for each client!
Ben
Krishna Chandra Prajapati wrote:
Hi,
I am setting
Is it possible to get the count() for forums, threads and messages
extrapolating from the following query? Thanx for helping a newb.
select
sf_conferences.id,
sf_conferences.name
from
((#variables.tableprefix#conferences
left JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
We have just moved to a new web server where we are running mysql version:
5.0.45
On the old machine, when we gave the following command:
update table1 set passwd = password('xx') where user_name=xx;
and then gave the following command,
SELECT user_name FROM alon_protein_passwd WHERE
We have just moved to a new web server where we are running mysql
version: 5.0.45
On the old machine, when we gave the following command:
update table1 set passwd = password('xx') where user_name=xx;
Here you're updating 'table1'...
and then gave the following command,
SELECT user_name
Thanks for the answer but that's not it. It was my typo. I am really updating
and selecting from the same table.
--
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934-3036
On 4/9/2008 at 1:54 PM, in message
[EMAIL PROTECTED], Edward Kay
[EMAIL PROTECTED]
Thanks for the answer but that's not it. It was my typo. I am really
updating and selecting from the same table.
Perhaps not it either, but strings should be in single quotes, not double
quotes.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
On Wednesday 09 April 2008 13:02:57 [EMAIL PROTECTED] wrote:
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please click on
the following link:
http://lists.mysql.com/s/mysql/47fca2617dc97f36/nsabbi=tiscali.it
This confirmation serves two purposes.
On Wednesday 09 April 2008 13:03:39 [EMAIL PROTECTED] wrote:
To confirm that you would like
[EMAIL PROTECTED]
added to the mysql mailing list, please click on
the following link:
http://lists.mysql.com/s/mysql/47fca28b736fbf40/Nicola.Sabbi=poste.
it
This confirmation serves two
Thanks for the email but that didn't help. I gave the commands again using
only single quotes and I still get no results.
On the old machine we were running MySQL 4.0.15a. Is there any difference
with the password function in these 2 versions?
--
Malka Cymbalista
Webmaster, Weizmann
Thanks for the email but that didn't help. I gave the commands again using
only single quotes and I still get no results.
On the old machine we were running MySQL 4.0.15a. Is there any difference
with the password function in these 2 versions?
Could be, I remember MySQL 4.1 having a new
Thanks. So how does one use the password function in MySQL 5?
--
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934-3036
On 4/9/2008 at 2:57 PM, in message [EMAIL PROTECTED],
Martijn Tonies [EMAIL PROTECTED] wrote:
Thanks for the email but that didn't help.
Hi,
I installed Mysql 5.0.45 on Solaris 10 01/08 configured to run
the datadir on a ZFS filesystem on a Raid1 pool.
Both myisam and innodb tables are on the same filesystem.
Innodb is configured to run with a buffer_pool_size=256M,
with doublewrite set to OFF and with file_per_table to Off.
The
Thanks. So how does one use the password function in MySQL 5?
Most probably just the same, but your MySQL 4 password hashes are
incompatible
with MySQL 5 password hashes.
A search on password in the MySQL docs returns quite some stuff, see:
PS, the document I send you also mentions:
To change the password but create a short hash, use the OLD_PASSWORD()
function instead:
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote:
We have just moved to a new web server where we are running mysql
version: 5.0.45
On the old machine, when we gave the following command:
update table1 set passwd = password('xx') where user_name=xx;
and then gave the following command,
SELECT
Hi All,
show engine innodb status gives the following information. I am not able to
draw conclusion.
SEMAPHORES
--
OS WAIT ARRAY INFO: reservation count 97641, signal count 97303
--Thread 1140881760 has waited at log0log.c line 1986 for 0.00 seconds the
semaphore:
S-lock on RW-latch at
Thanks to Martin and Paul for their answers.
--
Malka Cymbalista
Webmaster, Weizmann Institute of Science
[EMAIL PROTECTED]
08-934-3036
On 4/9/2008 at 3:54 PM, in message [EMAIL PROTECTED], Paul
DuBois [EMAIL PROTECTED] wrote:
At 1:13 PM +0300 4/9/08, Malka Cymbalista wrote:
We have just
Hi I think you would do this :
SELECT
sf_conferences.id,
sf_conferences.name,
count(*) AS `count`
FROM
((
LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
LEFT sf_threads ON sf_forums.id = sf_threads.forumidfk)
LEFT JOIN sf_messages ON sf_threads.id = sf_messages.threadidfk
Thank You Richard! Merci beaucoup.
wConti
Richard-175 wrote:
Hi I think you would do this :
SELECT
sf_conferences.id,
sf_conferences.name,
count(*) AS `count`
FROM
((
LEFT JOIN sf_forums ON sf_conferences.id=sf_forums.conferenceidfk)
LEFT sf_threads ON sf_forums.id =
On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi [EMAIL PROTECTED] wrote:
The problem I have is that importing the same 7 MB sql dump
takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
Is autocommit turned off?
http://dev.mysql.com/doc/refman/5.0/en/innodb-tuning.html
When importing
Il Wednesday 09 April 2008 19:40:32 Rob Wultsch ha scritto:
On Wed, Apr 9, 2008 at 5:51 AM, Nico Sabbi [EMAIL PROTECTED] wrote:
The problem I have is that importing the same 7 MB sql dump
takes 9 seconds if engine=Myisam and 98 when engine is Innodb.
Is autocommit turned off?
24 matches
Mail list logo