Web Application VS Windows Application
-
but now when i do this it cause mysql to stop
-
@IT-ADMIN said:
@scottalanmiller said:
@IT-ADMIN said:
i copied windows mysql BD into ubuntu mysql, i was out of my mind when i do that
Well databases should not just be copied around. But that it is Windows and Linux is not a factor.
but i used to do this in windows, i copy the folder and paste and boom, it works,
That's fine, but that doesn't imply what you concluded from it. Did you check that you were running MyISAM and not InnoDB? Did you verify the permissions? Did you verify the version numbers match?
-
@scottalanmiller i mean RAM and CPU, because i do not have standby server right now, i planned to grab a normal computer and install ubuntu in it, that's all
-
@scottalanmiller said:
@IT-ADMIN said:
@scottalanmiller said:
@IT-ADMIN said:
i copied windows mysql BD into ubuntu mysql, i was out of my mind when i do that
Well databases should not just be copied around. But that it is Windows and Linux is not a factor.
but i used to do this in windows, i copy the folder and paste and boom, it works,
That's fine, but that doesn't imply what you concluded from it. Did you check that you were running MyISAM and not InnoDB? Did you verify the permissions? Did you verify the version numbers match?
lol, it is OK i will not check anything, i will keep myself away from that server and just install a new version of ubuntu in another computer
-
@IT-ADMIN said:
@scottalanmiller i mean RAM and CPU, because i do not have standby server right now, i planned to grab a normal computer and install ubuntu in it, that's all
But you should always be a VM, period. No exceptions. RAM and CPU do not grow much when you split the workload up. We are only talking about like 1GB total here, right? For two VMs? 2GB at maximum?
-
@IT-ADMIN said:
@scottalanmiller said:
@IT-ADMIN said:
@scottalanmiller said:
@IT-ADMIN said:
i copied windows mysql BD into ubuntu mysql, i was out of my mind when i do that
Well databases should not just be copied around. But that it is Windows and Linux is not a factor.
but i used to do this in windows, i copy the folder and paste and boom, it works,
That's fine, but that doesn't imply what you concluded from it. Did you check that you were running MyISAM and not InnoDB? Did you verify the permissions? Did you verify the version numbers match?
lol, it is OK i will not check anything, i will keep myself away from that server and just install a new version of ubuntu in another computer
But you still should not have the takeaway that Windows and Linux have some compatibility concern. That's completely the wrong impression to get. That would be a MySQL problem, it has nothing to do with the OS.
-
Ok, so i will grab a 4 RAM GB, install a hypervisor on it (it will take almost 1 GB) and the rest is devided btw the 2 VM, one apache 1.5 GB RAM and one for Mysql 1.5 GB RAM, is it fine now ???
-
@IT-ADMIN said:
Ok, so i will grab a 4 RAM GB, install a hypervisor on it (it will take almost 1 GB) and the rest is devided btw the 2 VM, one apache 1.5 GB RAM and one for Mysql 1.5 GB RAM, is it fine now ???
What hypervisor are you running that needs 1GB of RAM? I think my XenServer host uses like 200-300MB.
-
@scottalanmiller ah ok, thanks at least i realized that i was not stupid lol,
-
@IT-ADMIN said:
Ok, so i will grab a 4 RAM GB, install a hypervisor on it (it will take almost 1 GB)
What hypervisor is grabbing so much RAM?
-
@coliver no dear, i already tried XenSever, it consume about 700 MB,
-
@IT-ADMIN said:
... and the rest is devided btw the 2 VM, one apache 1.5 GB RAM and one for Mysql 1.5 GB RAM, is it fine now ???
That's plenty, yes. Far more than we use for that stuff.
-
@IT-ADMIN said:
@coliver no dear, i already tried XenSever, it consume about 700 MB,
Are you sure about that? How did you determine that it was using so much? I've never seen it grab that much.
-
what makes apache not playing well with mysql if they are on the same server ??
-
-
it takes 1 GB
-
I don't know much about XenServer, but I know you can limit the amount of memory assigned to the Hypervisor (physical host) itself... Not sure where to do that though.
-
-
Ya mine's using close to 2GB
-
anyway it is another discussion about hypervisors we made it 6 months ago,
why it is recomended to make apache and mysql in seperate servers ??
