MySQL Clustering and Security

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.


Category: open source Time: 2005-07-05 Views: 2

Related post

  • MySQL Clustering and replication 2010-08-26

    I want to setup a MySQL cluster setup of two servers (M1-M2). I also want to setup MySQL replication between two servers (M1-M3). Is it possible to setup both clustering and replication as above. Is it a good idea to have a setup like this ? I want t

  • MySQL - connection and security 2010-04-14

    I was wondering if someone could tell me if there is any potential security breeches that could occur by connecting to a sql database that does not reside at 'localhost' i.e. via ip address? --------------Solutions------------- Any data contained in

  • No luck mysql clustering and load balancer with Fedora Core 4 2014-08-30

    First, thanks for the tutorial. I have followed the tutorial with exact server configuration. I`m using fedora core 4 inside vmware, at two physical location, 2 vmware each. The clustering works only if i set my firewall setting off , this is not goo

  • Live Syncing Data Between PostgreSQL and MySQL clusters 2016-07-21

    I have a unique situation to solve. My company is switching over to an app that runs on a Postgres backend. The app is replacing a current set of apps that run on a MySQL cluster. However, our initial deployment will only replace some of the apps tha

  • What's the difference between MySQL Fabric and MySQL Cluster 2014-10-11

    I'm new to the MySQL world and was confused by the two. Don't they both provide high availability and sharding? Also, how does WebScaleSQL compare? --------------Solutions------------- These 3 things have nothing to do one with each other. I will giv

  • Mysql Encryption and Key managment 2010-04-30

    I am developing a local intranet system in PHP/MySQL to manage our client data. It seems that the best practice would be to encrypt the sensitive data on the MYSQL server as it is being entered. I am not clear, though, on what would be the best way t

  • MySQL config and optimization 2011-07-10

    Here is the info for my server Giga Dedicated 6-Core: Intel Core i7 (6 x 3,20GHz) 24 GB RAM 160 GB SSD + 2000 GB HDD I have CentOS 5.6 (64bit) installed and Plesk Panel 10 Apache version is 2.2.19 MySQL version is 5.5 PHP 5.3.6 I was interested in op

  • 'mysql' user and group creation, ownership settings 2011-11-30

    I know what the linux command chown does, I used it to change the ownership or group of a file. If there is a MySQL installation on a Ubuntu machine, I saw some people doing the following thing: sudo chown mysql:mysql /data/tmp I get confused, I know

  • Is MySQL Clustering a viable option for a DB expecting 5TB of data in 5 years? 2012-08-23

    We plan to implement MySQL Clustering.The database should support 5 years of data and expected data/year is 1TB. When we created a test enviornment with the DB size as 200GB, NDB Cluster took more than 2 hours to restart. Is MySQL Clustering a viable

  • How can I access Ubuntu Server using MySQL Workbench and FileZilla? 2012-09-02

    How can I access Ubuntu Server using MySQL Workbench and FileZilla so that I can work on database and files from local Windows PC? --------------Solutions------------- For filezilla, you need to setup an FTP server.

  • syncing specific tables between two already-replicating MySQL clusters 2013-04-03

    I have a circularly replicating MySQL cluster, and a newer cluster of Percona XtraDB instances that we're in the process of moving to. During the move, we're running some projects on the old cluster and other projects on the new cluster. I'd like to

  • Is the connection from PHP to a different MySQL server 100% secure? 2013-04-04

    I tried to find this information but was not able to. How is working the connection from PHP to MySQL server. As the password is sored plain, is it also sent plain to MySQL if it is stored on a different server? Is there any way for a "man-in-the-mid

  • Did US and UK spy agencies defeat privacy and security on the internet? 2013-09-05

    This question is meant as a canonical question in regard to the US and UK spy agencies compromising end nodes and encryption between nodes to spy on people they suspect to be terrorists. However, this has the side effect of significantly elevating th

  • Is it best practice to update mysql , php and apache on linux regularly to current version? 2013-10-19

    I have a VPS unmanaged and have installed CentOS 6.3, mysql 5.1.69, php 5.3.3 and apache 2.2.15 No formal or otherwise education in computer programming so trying to follow as many documented guidelines as I can to close any obvious security holes. I

  • Installing PowerDNS (With MySQL Backend) And Poweradmin On Ubuntu 8.10 2013-12-08

    Installing PowerDNS (With MySQL Backend) And Poweradmin On Ubuntu 8.10 Version 1.0 Author: Falko Timme This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDNS on an Ubuntu 8.10

  • When installing mysql in linux, why do we create a mysql group and user? 2014-03-28

    When installing mysql in linux, why do we create a mysql group and user ? The installation step tells to create a user and to change the ownership of mysql folder to mysql. --------------Solutions------------- Every process under linux runs under spe

  • Creating MySQL database and user without password 2014-05-10

    I am building a set of bash scripts which basically prepare apache virtual hosts, git repositories and other stuff on a cloud server. So far so good, everything is working, but a big problem occurred: MySQL database and users creation. The current sc

  • Installing PowerDNS (With MySQL Backend) And Poweradmin On Fedora 12 2014-06-03

    Installing PowerDNS (With MySQL Backend) And Poweradmin On Fedora 12 Version 1.0 Author: Falko Timme Follow me on Twitter This article shows how you can install the PowerDNS nameserver (with MySQL backend) and the Poweradmin control panel for PowerDN

  • How to update MySQL Server, MySQL Client and phpMyAdmin to the latest stable versions on my local machine running on 64-bit Ubuntu 12.04 LTS? 2014-12-13

    I'm using 64-bit Ubuntu 12.04 LTS on my machine. I've already installed LAMP server on my machine. I'm using following Apache HTTP Server version. I got following information after I type following command into my machine's terminal : apachectl -V Se

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development


Front-end development


development tools

Open Platform

Javascript development

.NET development

cloud computing


Copyright (C), All Rights Reserved.

processed in 2.089 (s). 13 q(s)