I have no idea how to do this so please forgive my not trying before i ask. I would like to create a system that will allow user to vote, count and tell who won. i can do all that is stated. now i would like to add the functionality of having two database where one will be a real time back-up of the other. i do not know if its possible to have two "insert" statements, one inserting to one database and one the other. plan to use html for my interphace, mysql for the database and php to link the two. please help. titles of which books would be highly appreciated.
liphoso
0
Light Poster
Recommended Answers
Jump to PostGoogle for "mysql replication" or "mysql master slave". If that functionality is not sufficient then code your own database abstraction layer in PHP so that each query which is not a SELECT statement is mirrored on a separate connection to the 2nd server.
All 2 Replies
smantscheff
265
Veteran Poster
Google for "mysql replication" or "mysql master slave". If that functionality is not sufficient then code your own database abstraction layer in PHP so that each query which is not a SELECT statement is mirrored on a separate connection to the 2nd server.
fobos
19
Posting Whiz in Training
If you want to insert data into 2 tables in the same database, then use UNION. If you have 2 databases, but same table name, 1) make sure you have the same fields, 2) use 2 connections for each database.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.