Well I'm not entirely sure how you mean.
Running several mysql several servers against the same datadirectory (the physical files) is not recommended.
And if you say "network drives" what are you referring to here? Some sort of NAS? If it is then you should also avoid it for performance reasons. Mounting a volume over a network is much slower than running it off an internal ...
Thread: Mysql database splitting over network drives  |
|||||||||||||
|
Started 1 month ago by big JME
ok then i currently have 2 systems for my mysql server, one as a master and one as a slave. if the master goes down then the slave instantly takes its place on the network however storing the database between the 2 without telling all commands to run on both servers would be a pain therefore i though of the idea of having a shared network drive that connects to both systems and then ...
|
|
||||||||||||
|
|||||||||||||
Other posts in this thread:
sr replied 1 month ago
Size: 3,031 bytes
Customize: 
big JME replied 1 month ago
the reason for this is we have a mysql database set up for our systems however we need no downtime as the servers are used all day. which is why when a server needs upgrading then without having downtime i could unplug the main one needimng upgrade, upgrade it whie the slave server takes its place and then once upgraded you can simply connect the upgraded server to the network and ...
Size: 1,549 bytes
Customize:
sr replied 1 month ago
Quote: Originally Posted by big JME
therefore like you suggested i would like to have 2 mysql front end servers set up one on the master and one on the slave and then the mysql database tables stored on the network drives
OK, your main goal is uptime.
Cons with the NAS/SAN solution:
You don't provide any redundancy for the data storage. So what do you...
Size: 3,713 bytes
Customize:
big JME replied 1 month ago
ok get what yours saying so what would ou suggest for having the database sybnc on both systems at the same time? tell the mysql command to run twice one for each server so they are identical and a longer run time of what? im no expert on this as im to be honest a n00b to setting up cluster even though i have an IT professional helping me set up and run the servers the idea of the ...
Size: 1,011 bytes
Customize:
big JME replied 1 month ago
also a very quick off topic i have the following query running on my system
PHP Code:
mysql_query ( "SELECT * FROM 1users order by Points DESC LIMIT 20" );
however i have now found that a Point value of 1020 is shown below 155, any ideas how to get it to show the proper order so that 1020 is higher then 155? ...
Size: 1,996 bytes
Customize:
sr replied 1 month ago
Quote: Originally Posted by big JME
however 1095 is higher then 870 so it should shoow 1095 at the top and not last it is almsot like the request is only reading the first 2 characters of the number. any ideas? this question is stupid i know but i can not figure out why its not working
Your problem is that the Points column is a string column like CHAR or ...
Size: 1,712 bytes
Customize:
big JME replied 1 month ago
ok now i feel ashamed that i couldnt figure that out
Size: 222 bytes
Customize:
sr replied 1 month ago
Quote: Originally Posted by big JME ok get what yours saying so what would ou suggest for having the database sybnc on both systems at the same time? tell the mysql command to run twice one for each server so they are identical and a longer run time of what? im no expert on this as im to be honest a n00b to setting up cluster even though i have an IT professional ...
Size: 5,155 bytes
Customize:
big JME replied 1 month ago
yeh my server atm has had constant connection for 165 days without powering off lol, so what would you use for storing the db on both servers in terms of a software or settings? as currently i have 2 small computers with 1 internet conenction each so i cant link them together but could send the quary to the slave over the network to its network ip couldnt it? never ever done this before...
Size: 463 bytes
Customize:
sr replied 1 month ago
Quote: Originally Posted by big JME so what would you use for storing the db on both servers in terms of a software or settings? as currently i have 2 small computers with 1 internet conenction each so i cant link them together but could send the quary to the slave over the network to its network ip couldnt it? never ever done this before so i have no clue
You...
Size: 1,365 bytes
Customize:
|
Top contributing authorsRelated threads on "Dev Shed Forums - Open Source web development":Related threads on other sites: |
||||||||||||
Thread profile page for "Mysql database splitting over network drives" on http://www.devshed.com.
This report page is a snippet summary view from a single thread "Mysql database splitting over network drives", located on the Message Board at http://www.devshed.com.
This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity
Home |
About Us |
Submit Your Site |
Update Your Site |
Get Search For Your Site |
Partners |
Contact |
Search Plugin |
Blog |
 |
Last Searches | Top Searches |
Designated brands and trademarks are property of their respective owners.
Use of this website constitutes acceptance of BoardReader's User Agreement and Privacy Policy.