2-way replication

I set a 2-way replication with 2 servers One is accessed and used for both select and updates. The other one is backup set to work through a failover software.. if the first server is down. So the backup server can easily update the other server when it comes up again. Do you see any collision pos

CRASH AND ROLLBACK SIMULATION

Do you know how to test a crash and a rollback? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FW: Replication - Slave Backup to Master

Hi I set a 2-way replication on 2 servers. I made some test transactions and it is working. I can make the clients go to any of my servers and the replication is done in real time, or so. It looks great. What are the potential problems I could have? Suggestions? Do you have any experience? (usin

Replication - Slave Backup to Master

Hi there I have a question regarding replication. This is the situation: Mysql-Max4.0.16 192.168.0.10 master 192.168.0.11 slave I would like to use the slave as the backup server and use it in case the master goes down for any reason. I'm looking for a safe method to re-update the master when

PERL DBI DBD mysql / REMOTE ACCESS

I can login on console. I can telnet 192.168.1.20 3306 from a remote host but when I try to connect using perl DBI i get this error: DBI connect('database=test;hostname=192.168.1.20','root',...) failed: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) I added Host 192.168.1.10 u

guru needed - large configuration MySQL-Max InnoDB - 4.0.16

Hi there I was wondering I you can send your comments and remarks for this my.cnf file o.s. redhat9 tables < 20Mb mem: 8gb server dedicated to mysql max_connections=2000/3000 uses only innodb tables my.cnf [mysqld] port= 3306 socket = /var/lib/mysql/mysql.

RE: mysql max / another

Just wondering if things like number of contemporary user connected etc. are predefined in mysql-max, in order to handle many connections. Can I handle 3000++ users/clients? Pls help me with mysql max tunning. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsu

RE: mysql max

Hi do you mean that InnoDB have no table-size limit? Thanks. |-Original Message- |From: Tobias Asplund [mailto:[EMAIL PROTECTED] |Sent: Friday, October 17, 2003 6:04 PM |To: nm |Cc: [EMAIL PROTECTED] |Subject: Re: mysql max | | | |It depends on your filesystem's and OS's max

mysql max

Hi what's the max table size we can use with mysql-max version? Suggestions? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

FW: table size in mysql

Is it possible to MERGE innodb tables? Can't find docs on mysql.com In replication. I guess I can update the slave if the master is not responding, right? Shall I 'stop slave' before , in case the master is down? Also will this create problems when the master comes back and the slave copies upd