Hey, it’s Olly Connelly here at guvnr.com, if you want to drop me an email. Today, we’re going to continue with this intended series set up on manage VPS 4 Newbies VPS Bible. This is part eight and we’re going to install PHP MySQL and we’re going to find tune PHP get it running nice and fast with xcache.
If you want all the details, the best thing to do is to get on my site but you can get all the detail here and you're going to need it too because for example there's a whole bunch of stuff that you’re going to want to copy and paste, it’s going to make life a lot easier for you when you’re configuring these various things. But this video, if you’ve got any queries, it will help you a little bit. You can stop it, pause it, you'll be able to put it in high depth quality so that you can see exactly what I'm typing as I go along. So, without further due what we’re going to do first of all is we're going to install this package called Build Essential which we're going to need because it basically allows us to do things down the road and so it wants password.
Okay, so that’s done. Now, we’re going to install PHP 5. Totally good, iMagic PHP extension use to create and modify images can be a bit of a problem to install so we’ll install it separately. What we need to do first is install half and then we’re going to use up get to install this extension.
Okay, well actually we just go to that, well now we're going to install it and just press Enter to continue. Okay, we need to make a little bit on adjustment so the iMagic installation in the PHP, any file. So, we’re just going to get into that file and we’re just going to add align right at the end, it’s quite a long file that will do and controlling else in that file we should change, so that you can see on the resource limits you can see them the memory limit is set at 16.Well, you may want to increase that. It really depends on what you're going to be using it for. If you refer to my company notes at my site, you'll see a whole bunch of examples and what have you and which we hopefully help you so have a look at that. I'm going to set that at 48 meg for pretty typical WordPress installation and once you’ve done that what we're going to do is go right to the end and we’re going to obtain a whole bunch of data here regarding this excellent module facility called xcache.
Now, that speeds up sites and blogs by improving your PHP performance. It sometimes dramatically but to enable it, we go to open PHP any file and you can find that here on my site so you click on that logo there and then just copy the whole of that. And if you right click on your mouse, it will automatically paste. That’s the way it works Linux. And then in here, we’ve got a couple of values that we need to change and this is going to depend on you system, I mean if you’re like me you're running a Linux 360 that particular plan and you can use exactly what I've got on my website without any configuration changes. Otherwise, it’s likely that you're going to have to change three values if I can find those and we want to change some they called xcache size, now I've got mine set 64 meg, if you got more RAM you can probably increase the value. But I would have recommended asking you a VPS forum for how you should set that. Xcache size that easy that is going to be set at whatever the value was do you put for xchache size.
Now, the third value is here xcache count and that relates to the number of processors that you have in your box. And something else you can do, I'm just going to save that, is you can type in this command here. Again, you can find them on my site and that will tell you how many processors you’ve got running on your machine. So that’s done with PHP5, we’re now going to install MySQL server and secure that installation.
Up above the box from box so just add and confirm MySQL password for the MySQL user root. We’re just going to show it up a little bit more security and pop in your password and remove anonymous users, yes you want to do that. And just allow logging remotely you want to do that, you want to remove this test database, you don’t need that and yeah you do want to read all the privilege tables. Okay, so that’s great just your password and a bunch of yeses. All your MSQL installation should now be secured.
One last thing today, I'm going to install subversion. If you have a popular platform quite pairing or completely pairing your site to this simple machine forum—WordPress, anything like that, subversion is mighty handy tool, it’s a version control system. Basically, it will keep platforms up to date if you have a simple command and so I use it for example upgrade not only WordPress but also all of my plug in at key—and I talk more about that in another place in the series if you suspect you need it that’s the command you want.
And there you go, we are all done today. And okay, well look, I hope that was handy. If you want to do us a favor, rate this video, help other people see all that, subscribe to the channel and you can get regular updates and leave a comment, we’d appreciate any question you’ve got. And at guvnr.com, you can subscribe by email or by RSS to my feed. Check out the series index. There's a whole bunch of different stuff for a way wider web. Okay, I hope that’s been handy and thanks for watching. Bye.
Transcription by:
Scribe4you Transcription Services