Web Application VS Windows Application
-
@IT-ADMIN said:
i was stupid, i forget that windows mysql DB will not work on linux mysql DB, it was just a slip of mind
What do you mean? They are the same thing.
-
@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.
-
you told i must have 2 servers one for apache and one for mysql, but i do not think that the project is of that size that we have to dedicate 2 VM only for this project, i think one is enough
-
@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,
-
@IT-ADMIN said:
you told i must have 2 servers one for apache and one for mysql, but i do not think that the project is of that size that we have to dedicate 2 VM only for this project, i think one is enough
Why is "enough" a factor? VMs don't really work that way. Zero cost, really no footprint. I don't see "enough" being a word that applies here.
-
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 ??
-
