- This topic is empty.
-
AuthorPosts
-
August 18, 2014 at 1:56 pm #179615
James Burton
ParticipantHello,
Does anyone on here use the RHEL/Centos software collections for mysql 5.5, httpd 2.4 and etc?
James
August 18, 2014 at 2:06 pm #179622Alen
ParticipantI use Ubuntu 14.04. Few people on here use Centos.
Anyways, I don’t think it matters what distro you’re running. Both are great for MySQL/Apache/Nginx etc.
August 18, 2014 at 2:14 pm #179626nixnerd
ParticipantAnyways, I don’t think it matters what distro you’re running. Both are great for MySQL/Apache/Nginx etc.
It makes absolutely no difference. Except for the fact that on some distros… you’ll only be able to use MariaDB instead of MySQL. Even that makes no difference.
August 18, 2014 at 2:28 pm #179630James Burton
ParticipantWhat is different between MYSQL and MariaDB?
August 18, 2014 at 2:31 pm #179631Alen
ParticipantJust think of it as MySQL replacement. Just little faster. Or slower.
I wouldn’t really pay too much attention. MySQL will do just fine 99.99% of the time for your needs.
I wouldn’t start complicating things.
August 18, 2014 at 2:39 pm #179632nixnerd
ParticipantYeah… I was just using that as an example. Don’t use MariaDB unless you have to. I use a distro that has dropped MySQL officially and now uses MariaDB. It’s exactly the same thing. Literally.
I was simply trying to illustrate that differences between distros are largely superficial and really just come down to their package manager and release schedule. That’s pretty much it.
August 19, 2014 at 5:24 am #179807James Burton
ParticipantThank you for your posts @Joe_Temp and @AlenAbdula.
I currently use RHEL 7, Centos 6.5 and Debian 7.6 to run my websites.
James
August 19, 2014 at 6:37 am #179810Alen
ParticipantI run Ubuntu on DigitalOcean and manage it using Forge and SSH.
August 19, 2014 at 8:33 am #179814chrisburton
ParticipantDon’t use MariaDB unless you have to. – @Joe_Temp
I use MariaDB and have had no issues.
It’s exactly the same thing. Literally.
Not exactly. It is a replacement to MySQL
August 19, 2014 at 8:51 am #179816__
ParticipantDon’t use MariaDB unless you have to.
There’s probably two sides to this advice. If you are confused by things like installing databases, or have a lot of other stuff to worry about at the moment, don’t worry about switching to maria.
If nothing is stopping you, however, I would highly recommend switching.
It’s exactly the same thing. Literally.
It is a “drop-in compatible” replacement, but it does have differences. Changes are mostly internal (performance), and the API for each is identical (to the point that clients written for mysql -like PDO and MySQLi- don’t realize it’s not mysql).
Until 5.5, everything is feature-compatible with the same numbered version of MySQL as well. There is now a version 10 branch where features start to diverge, and, if you decide to switch and aren’t held back by your codebase, I highly recommend. For example, it adds fulltext indexing to InnoDB (so, now there’s an engine that supports foreign keys and fulltext!) and allows CURRENT_TIMESTAMP as a default value for DATETIME columns. Lots of other little fixes like that.
August 19, 2014 at 9:14 am #179822James Burton
Participant@traq and @chrisburton,
I’ll give MariaDB a try and see if it’s better to switch over.
I know RHEL/Centos 7 is moving from MySQL to MariaDB.
James
August 19, 2014 at 9:19 am #179823nixnerd
ParticipantI don’t do near enough database work to notice the difference. All I know is the setup commands were exactly the same.
If they say it’s great… I guess use it. Makes me feel awesome for having it installed :)
August 19, 2014 at 9:34 am #179825James Burton
Participant@Joe_Temp, @Traq, @chrisburton,
I currently use this system config and I would like to know if it’s good config.
Software
Apache httpd
Apache Tomcat
MySQL (thinking about moving to MariaDB if test are completed)
PHP
VPN for SSH
IPTables for Firewall
SELinuxJames
August 19, 2014 at 9:37 am #179826chrisburton
ParticipantIf you’re familiar with C++, you should take a look at HHVM.
As far as server stuff, I’m the wrong person to ask.
August 19, 2014 at 10:07 am #179830nixnerd
ParticipantIs it a GOOD config? I don’t know. Does it meet your needs? If so, then it’s good.
I personally don’t use Apache… but that’s a personal preference. I find Nginx easier to configure and that works for me.
VPN for SSH? Ok. Seems legit. I don’t use one but I can see why you would.
I don’t know ANYTHING about SELinux other than it was developed by the NSA. Ha ha ha.
-
AuthorPosts
- The forum ‘Other’ is closed to new topics and replies.