RE: More database replication
Anyone have any ideas about this? Thanks, Richard -Original Message- From: Richard Bewley [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 02, 2003 7:10 PM To: [EMAIL PROTECTED] Subject: More database replication Hi, I have a "mission critical" database, that I want to be redundant, so I'm using, as discussed in another thread, the Cisco LocalDirector, two mysql machines, and db replication. mySQL version 4.0.16, compiled from source. Should I make both servers both master and slave, or will this cause problems? Would it be better, to make one primary server master, and just have a slave as a "failover" db server for the LocalDirector to send traffic to only if the primary is down? Also, the problem I've come across is, I have gotten replication setup correctly, and it works, but only when I type mysql> LOAD DATA FROM MASTER; I'd rather have it automatically be replicating rather than have to run that command every time, or rather than having a cron job do it, which I see as messy at best. Any suggestions? Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
More database replication
Hi, I have a "mission critical" database, that I want to be redundant, so I'm using, as discussed in another thread, the Cisco LocalDirector, two mysql machines, and db replication. mySQL version 4.0.16, compiled from source. Should I make both servers both master and slave, or will this cause problems? Would it be better, to make one primary server master, and just have a slave as a "failover" db server for the LocalDirector to send traffic to only if the primary is down? Also, the problem I've come across is, I have gotten replication setup correctly, and it works, but only when I type mysql> LOAD DATA FROM MASTER; I'd rather have it automatically be replicating rather than have to run that command every time, or rather than having a cron job do it, which I see as messy at best. Any suggestions? Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DB Replication
Hi, I did manage to get two-way replication to work properly, but I have to type: mysql> load data from slave; This is the only way it replicates the data. Is there a way to have it replicate back and forth in real time? Thanks, Richard -Original Message- From: Richard Bewley [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:33 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: RE: Database replication Ok, but the slave would also replicate to the master? Is anyone using this type of setup? Thanks, Richard -Original Message- From: Chuck Gadd [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:34 PM To: Richard Bewley Subject: Re: Database replication Richard Bewley wrote: > Hi, > > I'm working on setting up db replication, and I have a question. If I have > a master server, which will replicate to a slave, what about vice versa? It works, but there is no conflict resolution built in. If both servers update the same record, it will cause problems. I believe you would also have problems if both servers added records to a table with an autoincrement field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Database replication
Ok, but the slave would also replicate to the master? Is anyone using this type of setup? Thanks, Richard -Original Message- From: Chuck Gadd [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 6:34 PM To: Richard Bewley Subject: Re: Database replication Richard Bewley wrote: > Hi, > > I'm working on setting up db replication, and I have a question. If I have > a master server, which will replicate to a slave, what about vice versa? It works, but there is no conflict resolution built in. If both servers update the same record, it will cause problems. I believe you would also have problems if both servers added records to a table with an autoincrement field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Images in a table
Yes, you can insert the binary into a table. Richard -Original Message- From: Zenzo [mailto:[EMAIL PROTECTED] Sent: Saturday, November 29, 2003 1:42 PM To: MySQL List Subject: Images in a table How can I insert images in a table if I can do it with MySQL? __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database replication
Hi, I'm working on setting up db replication, and I have a question. If I have a master server, which will replicate to a slave, what about vice versa? What I'm thinking I want to do, is load balance between two database servers (our mail authentication database) using the Cisco LocalDiretor. My concern is, if db0 replicates to db1, what if the LD directs the connection to db1, and it tries to write to the database. Will those changes be done on db0 also? What would be the best way to go about doing this? Thanks, Richard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
FW: How To Learn php and mysql.
The best way to learn is by taking a script (I used a message board written in php/mysql) and hacking it, then running it on your webserver, breaking it, and fixing it again. Just make tiny changes at first, play with logic, then work on bigger things. As for a book, I recommend the one on PHP and mySQL web development by Luke Willing and Laura Thompson. Good luck! Richard -Original Message- From: Braulio Lumbreras [mailto:[EMAIL PROTECTED] Sent: Monday, November 24, 2003 9:48 PM To: [EMAIL PROTECTED] Subject: How To Learn php and mysql. What is the best way to learn php and mysql? What book is recommended for self study of both ? Braulio -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mySQL with a quad processor system
Hi, I'm setting up a machine that will have a rather heavy load on it, with mysql that has 4 processors. It's running RedHat Linux 9.0, with a kernel with SMP to support the multiple processors. Is there anything special I need to do with mySQL to get it to take advantage of the multiple CPU's? Thanks, Richard
