MySQL Reference Architectures for Massively Scalable Web Infrastructure

I Found this pdf informatics,

It list out definition of small, Medium, Large, Extra-large web architecture from MySQL prospective and give example of architecture as well

MySQL Reference Architectures for Massively Scalable Web Infrastructure

 

Release date: March 2013

 

We need register one oracle login to download the articles

MYSQL : Error message file 'usr/local/mysql/share/english/errmsg.sys'

MYSQL Lab setting error :
MYSQL : Error message file 'usr/local/mysql/share/english/errmsg.sys'

I setting MySQL lab to test replication.
Binary file place in /MySQL/master and /MySQL slave

few parameter in my.cnf been change
port=3306
socket=/tmp/mysqlmaster.sock
datadir=/MySQL/master/data

when I start master server, it hit error 

Google and found similar problem in the blog.
Toaster Gremlin
In the blog, the problem been solve with replace errmsg.sys with the latest MySQL version in /local/usr/MySQL/share/English folder

 

It give me hints!

Early I install mysqlcluster in /local/usr/MySQL folder for MySQL cluster lab setup.
When I start install MYSQL 5.5.30 into /MySQL/master folder, my.cnf didn't mention my basedir.

I suspect it get share information from /local/user/MySQL folder which is the default MySQL installation folder.

Table 2.5. MySQL Installation Layout for Generic Unix/Linux Binary Package

 

I add basedir parameter in my.cnf under mysqld session where /MySQL/master is MySQL binary file location

basedir=/MySQL/master

I start mysqld again with successful

 

Problem solve!



Renew ip in Sun Solaris (Virtual Server)

I attended MYSQL Cluster  training from Oracle and using Sun Solaris in Hyper-v for Lab purpose.

When I brought my computer to training center, I needed renew my IP so I can't connect to Sun Solaris in Hyper-v with Tightvnc viewer (I use this to solve Mouse trap problem in Sun Solaris at Hyper-V)

In window environment, I always run this
IPCONFIG /renew

In *inux version, I don't know how and always restart Virtual server to get the latest IP.

Do some search and come this
list ip of the network in my virtual pc
/sbin/ifconfig -a

net0 is my ip.

I run the below
 ifconfig net0 dhcp status
ifconfig net0 dhcp release
ifconfig net0 dhcp status

and then

ifconfig net0 dhcp primary
ifconfig net0 dhcp status
The IP is refresh.

I get the information from here and it work in my Virtual Server.