[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Multiple mySql servers with sync

Posted on 2006-11-10
2
Medium Priority
?
460 Views
Last Modified: 2006-11-18
I'm going to have a co-located server running linux/apache/mysql and a local server with the same setup. The local will not be attached to the WAN, and the co-located will be accessible through a webapp.

I'm planning on having a database that will hold user accounts with passwords. This will be used for the remote webapp, and also for a local software package. The problem is that if the remote server dies for some reason, or is in-accessible, the local software will have no database to check for credentials.

So I am planning on having a server on the local side that syncs with the remote mysql database, but I'm not quite sure of the best way to handle this. Should I be running queries on both simultaniously? Does mysql have a way of handling this type of redundancy? What's the most secure way? What's the fastest way?

Thanks
0
Comment
Question by:induced
2 Comments
 
LVL 17

Accepted Solution

by:
akshah123 earned 500 total points
ID: 17915927
>>>So I am planning on having a server on the local side that syncs with the remote mysql database, but I'm not quite sure of the best way to handle this. Should I be running queries on both simultaniously? Does mysql have a way of handling this type of redundancy? What's the most secure way? What's the fastest way?

You should look into replication for mysql servers.  http://dev.mysql.com/doc/refman/5.0/en/replication.html
Now, this is a secure and a reliable way of replicating the database over multiple servers.   Now, this is probably not the fastest way as it will requie you to have a good understanding of replication and will require some efforts to set it up.
0
 

Author Comment

by:induced
ID: 17920116
This is what I was looking for. Thanks
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month19 days, 7 hours left to enroll

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question