Posts Tagged mysql
Some MySQL Fun
Posted by Joe in Linux, Programming on November 29th, 2009
I’m currently writing an application which will be running from a MySQL backend, along with a good friend of mine. So we get to play with SVN, as well as MySQL. I’m wondering whether it would be worth setting up MySQL replication on one of the servers, as we have 2 to use if we need them. Possibly even 3.
If anybody has some good guides on how to set this up, it’d be great to hear from you, now I have my install set up to allow the test user to connect remotely, I’m looking for another mini-project to include in this larger one 
Also…if you notice any DB oddities on here, please forgive me
Programming Ideas
Posted by Joe in Programming on June 14th, 2009
So while this has nothing to do specifically with Ubuntu, it’s more a request to the community
I’ve recently dabbled with some PHP & MySQL on a test server running from my desktop, as I’ve been meaning to learn PHP for a while. I think it’s gone OK, I’ve learnt quite a bit, but it may help that I know some C (setting variables is very similar etc.). What this little PHP learning experience has done (other than taught me some php), is reignite my passion for programming.
I’ve always enjoyed programming, that doesn’t mean I’m fantastic at it, but I really do enjoy it, the only thing I really struggle for is ideas for programs/applications. What my request to you – the community – is, is whether you struggle for ideas as well, if not, then do you have any you’d like to suggest?
Moving Home?
I’m thinking of moving this blog over to joeb454.com
As some of you know, I recently bought a MacBook, and I realised I didn’t have a page up on my .com domain, so I decided to kill 2 birds with 1 stone, and had a play with iWeb ‘09. The end result isn’t bad, and moving the blog over to my VPS provider would mean 2 things:
1) I’d actually be using my VPS for something
2) I’d have a more fine grained control over my blog, because I would be hosting it myself. Currently this blog is hosted by wordpress.com
It could mean I’d need to upgrade my VPS package, because currently I only have 384 MB RAM on there. I guess it all depends on how much MySQL decides that it wants to take, though before upgrading I’d look into tweaking some MySQL settings to see if I can reduce the amount it needs.
Ultimately I’d like to do this just because of number 1 above. But also it would teach me some more about Apache, MySQL, possibly PHP. I may also look into changing the site at some point, possibly to a Drupal installation, but we’ll have to wait and see
Any thought’s on whether you think this would be a worthwhile move, or any recommendations you have on tweaking various settings on the server (it runs Ubuntu 8.04) would be fantastic!
