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

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

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?

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]

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 =

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

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-size

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