Results 1 to 6 of 6
Thread: mySQL expert needed
-
01-10-2008, 12:34 PM #1Junior Guru
- Join Date
- Aug 2002
- Posts
- 183
mySQL expert needed
Hello,
We are running two servers. Both run mysql
1 x db server, 1x db + httpd
We want to setup a slave config with the db server as the master server and the other as the slave. The second server also has its own set of dbs.
Since the DB server has large DBs, we want a good strategy to back them up on the slave server or any other idea you propose. We are looking for someone to do the most effective job without any downtime. Please reply with your thoughts, capabilities and quotes.
Thanks
-
01-10-2008, 12:40 PM #2Web Hosting Master
- Join Date
- Oct 2002
- Location
- Manchester, UK
- Posts
- 1,179
Hi Allwin,
You are welcome to contact me if you're still looking for someone.
Out of interest, you mention that databases also run on the slave server. I presume you don't want these ones slaved?
Cheers
-
01-10-2008, 12:41 PM #3Junior Guru Wannabe
- Join Date
- Mar 2005
- Location
- Europe
- Posts
- 74
Hi.
Our team ( remsys.net ) may setup replication for you, with minimal downtime ( less than 1 min, while mysql restarts ) .
As about backups, mysqlhotcopy could be a good solution for huge databases.
Please contact me in PM if you are interested.
Thanks.
-
01-10-2008, 12:57 PM #4Junior Guru
- Join Date
- Aug 2002
- Posts
- 183
-
01-11-2008, 03:05 AM #5Web Hosting Master
- Join Date
- Oct 2004
- Location
- USA
- Posts
- 834
what you are looking for is mysql slave replucation where Mysql MAster slave creates a log file and it records any database changes. The slave server is monitoring that log file with tis own log to see what it has done and hasnt done. But i am not sure if it can be setup to be select of databases. IT would probaly be easier for a 2nd server so you dont interfere with the other databases in the event of a crash
VT BankCard
Payment Processing Solutions and Merchant Services
Specializing in WebHosting and High Risk Merchants.
-
01-11-2008, 07:19 AM #6Web Hosting Master
- Join Date
- Oct 2002
- Location
- Manchester, UK
- Posts
- 1,179