Sharing MySQL DB with muliple OS

aktar · 09-11-2007, 07:33 PM

I was just wondering how bloody efficient it would be if the same data can utilised by MySQL on Windows and on Linux.

I haven't tried it yet because.. well I dont know where the data is stored in Linux.
The other thing thats going through my mind is whether or not MySQL uses the exact same storage method on both systems, ie is it portable?

can anyone shed any light on this matter?

bryantrv · 09-11-2007, 07:43 PM

I don't know about Windows, but AFAIK (take it with a grain of salt), a MySql server doesn't care who gets the info- just like a web server or ftp server, so a Windows MySql application would be given the server name or IP address, port, username and password (etc.) and wouldn't know it was talking to a Linux or Windows server.

aktar · 09-12-2007, 12:11 PM

Quote:

Originally Posted by bryantrv

I don't know about Windows, but AFAIK (take it with a grain of salt), a MySql server doesn't care who gets the info- just like a web server or ftp server, so a Windows MySql application would be given the server name or IP address, port, username and password (etc.) and wouldn't know it was talking to a Linux or Windows server.

It wouldn't surprise me at all. But what I really want to know is if the same data can be shared by Mysql running on two different systems.

The reason I ask is because I'm running dual boot with XP and Debian. And I do my web stuff on both, so when I add data into the DB in using, say Debian, I want the same data to be available for extraction on XP

bryantrv · 09-12-2007, 12:39 PM

Ah- so you want to use 2 different MySql servers to access the same database (though not at the same time)?
Good question

I would bet it would be fine, but until I tried it for a while (or got an authoritative answer), I wouldn't want to try it with mission critical data

.

farslayer · 09-12-2007, 02:06 PM

Might want to be aware of the differences between MySQL on Windows and Linux when designing your initial database structure..
http://dev.mysql.com/doc/refman/5.0/...s-vs-unix.html

one issue may be the installation layouts between windows and Linux..
http://dev.mysql.com/doc/refman/5.0/...n-layouts.html

it appears though that the databases themselves are identical under windows and Linux so that's half the battle..
http://dev.mysql.com/doc/refman/5.0/en/moving.html

aktar · 09-13-2007, 11:08 AM

Quote:

Originally Posted by farslayer

Might want to be aware of the differences between MySQL on Windows and Linux when designing your initial database structure..
http://dev.mysql.com/doc/refman/5.0/...s-vs-unix.html

one issue may be the installation layouts between windows and Linux..
http://dev.mysql.com/doc/refman/5.0/...n-layouts.html

it appears though that the databases themselves are identical under windows and Linux so that's half the battle..
http://dev.mysql.com/doc/refman/5.0/en/moving.html

Thanks farslayer for your bit of research, very much appriciated, Ok the next thing I need to know is where the data is stored under Linux

Get ready for this, I sence a big breakthrough

farslayer · 09-13-2007, 12:48 PM

The 2nd link, the one about the layouts, answers that question. it shows the file and data location for Linux and Windows installs........

aktar · 09-14-2007, 04:02 PM

Yes guys, it is possible to share MySQL data between two systems.
However I've only managed to share MyISM databases, but no luck with InnoDB, mysql just doesnt recognise it on Linux.

I wonder if I missed anything; I've changed the file names to lowe case as suggested by the documentation but mysql isnt having any it

Any ideas?