MySQL Clustering and Security

By | July 5, 2005 | Open Source

2
  • Print
  • Print

I wrote briefly about securing MySQL last week and Andrew-J2000 suggested he was looking for a bit more depth into the clustering side of the scenario. I have recommended some additional links here for night-table reading to study up on some case studies, documentation and other miscellany involved with clustering MySQL.

When it comes to MySQL – one of the best sources remains the vendor. MySQL AB has developed alot of credibility based on its extensive documentation and depth of community participants in extending tips and techniques. There are numerous links out to further resources including training.

There were some nice links here on O’Reilly. Also, a PDF presentation by Brad Fitzpatrick on Live Journal’s monstrous MySQL implementation which should help.

Finally there is also a very nice How To which includes configuration and security tips by Alex Davies.

Written By:

Blane Warrene

Blane is a writer and researcher focusing on Apple and Open Source technologies. Prior to this, he helped found a commercial software and consulting venture, and worked in the financial services sector as a director of technology and in varying technical roles. Blane maintains Open Sourcery: SitePoint's Open Source Blog.

Website
>> More Posts By Blane Warrene

 

{ 2 comments }

bwarrene July 6, 2005 at 5:14 pm

As far as use of dmz’s – I always recommend using three dmzs:

One for web servers, one for application servers and the most restricted for database servers. This layering method for larger implementations allows for tighter control on security and downplays the security issue of holding databases in primary memory. However – this does boost the level of hardware one must invest in. Being that only larger projects go to this level of network divisions – the budget usually supports beefier hardware requirements.

I will look through my research on replication and see what I have.

Andrew-J2000 July 5, 2005 at 9:00 pm

Hi Blane,

I should have included replication in that sentence too. Whilst, I have been looking at the benefits of clustering the current environment, I am a little wary of aspects such as

Comments on this entry are closed.