Web Application VS Windows Application
-
@IT-ADMIN said:
i have a problem right now, i change the permission of var/lib/mysql (chown user /var/lib/mysql) in order to give myself permision in this folder, before i do that i stop mysql service, when start it again it said job failed, what the hell is that ??
Don't do that! What did you change?
-
@IT-ADMIN said:
for this reason you told me to not play with other servers, i will seperate things so that i will not run into issues like this
That's one reason. Another is... even as a developer you should never want access to that folder. What were you trying to do?
-
i was stupid, i forget that windows mysql DB will not work on linux mysql DB, it was just a slip of mind
-
i copied windows mysql BD into ubuntu mysql, i was out of my mind when i do that
-
@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,
