/usr/sfw/bin/gtar sjsws-7_0u5-solaris-sparc.tar.gz
# select to install in /opt/webserver7
# Run setup and follow the prompts
./setup
Note: Doing the install select an admin only node blog1a/b – blog2a/b, on blog-wadmin install the full install web & admin node.
Download & Install from sunfreeware.com all needed packages
PHP 5.2.1 installation and configuration
Install Sun coolstack 1.3.1
The packages below where used in the dev environment, in production we used the Webstack 1.5 bundle and installed amp on the blogs and mysql on the blogdb.
Sun coolstack Package list
Package list
CSKruntime_1.3.1_sparc.pkg
CSKlibsbundle_1.3.1_sparc.pkg
CSKperl_1.3.1_sparc.pkg
CSKamp_1.3.1_sparc.pkg
CSKmemcached_1.3.1_sparc.pkg
CSKmysql_1.3.1_sparc.pkg
Modify and add to the php.ini
Change and add this values to the php.ini and restart the webserver
The php.ini located in /etc/opt/webstack/php/5.2/php.ini
# Change the value to 256M
memory_limit = '''256M'''
# take off the semicolon from this extensions
extension=mbstring.so
extension=gd.so
; Compiled and by eli on 5/22/09
extension=imagick.so
# Add this at the bottom
;;;;;;;;;;;;;;;;;;;
; Module Settings ;
;;;;;;;;;;;;;;;;;;;
[Date]
; Defines the default timezone used by the date functions
date.timezone = America/New_York
;date.default_latitude = 31.7667
;date.default_longitude = 35.2333
;date.sunrise_zenith = 90.583333
;date.sunset_zenith = 90.583333
post_max_size = 10M
upload_max_filesize = 10M
cgi.fix_pathinfo = Off
;session.bug_compat_42 = Off
;session.bug_compat_warn = Off
;magic_quotes_gpc = Off
;fastcgi.logging = true
How to install Imagick
Download & Install from sunfreeware.com all needed packages
Add the following to the [mysqld] section of my.cnf making the appropriate changes and restart mysqld:
Click bellow for a copy of the file
Click here to see a copy of the blogdb1a my.cnf file
Click here to see a copy of the blogdb2a my.cnf file
# Add by eli
log-bin = blogdb1a-bin
binlog-do-db=blogdb1
binlog-ignore-db=mysql
server-id = 10
auto_increment_increment = 10
auto_increment_offset = 1
master-host = blogdb2a
master-user = replica
master-password = password
master-connect-retry = 10
expire_logs_days = 10
max_binlog_size = 500M
relay-log = /logdb1a/relay-bin
# let's do these too, just in case
relay-log-index = /logdb1a/relay-bin.index
relay-log-info-file = /logdb1a/relay-bin.info
# relay log restrictions
#relay-log-space-limit=15G
skip-innodb_doublewrite
Master 2 my.cnf
Add the following to the [mysqld] section of my.cnf making the appropriate changes and restart mysqld
# Add by eli
log-bin = blogdb2a-bin
binlog-do-db=blogdb1
binlog-ignore-db=mysql
server-id = 20
auto_increment_increment = 10
auto_increment_offset = 2
master-host = blogdb1a
master-user = replica
master-password = password
master-connect-retry = 10
expire_logs_days = 10
max_binlog_size = 500M
relay-log = /logdb2a/relay-bin
# let's do these too, just in case
relay-log-index = /logdb2a/relay-bin.index
relay-log-info-file = /logdb2a/relay-bin.info
# relay log restrictions
#relay-log-space-limit=15G
skip-innodb_doublewrite
Create the MySql database
gtar -zvxf webstack-all-1.5-b09-solaris-i586.tar.gz
./install mysql
# Note: if the install script failles just install the pkg manual and re-run the mysql install
pkgadd -d sun-wsbase.pkg
cd /opt/webstack/mysql/5.0/bin/64
./mysql_install_db
chown -R mysql:mysql /var/opt/webstack/mysql
# Start the MySql database
/opt/webstack/mysql/5.0/bin/64/mysqld_safe &
# Set the MySql root password and grant access rights (both Master1/Master2)
/opt/webstack/mysql/5.0/bin/64/mysqladmin -u root password 'password'
# Master 1
/opt/webstack/mysql/5.0/bin/64/mysqladmin -u root -h blogdb2a password 'password'
# Master 2
/opt/webstack/mysql/5.0/bin/64/mysqladmin -u root -h blogdb1a password 'password'
# Harden the DataBase (remove anon access etc..)
/opt/webstack/mysql/5.1/bin/64/mysql_secure_installation
Note: To configure MySQL For Solaris SMF Click here, This will provide with auto start-up self heeling dependency & more.
Create Replication Accounts
Create Replication Accounts
On both master servers run the following query as root:
mysql> CREATE USER 'replica'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT REPLICATION SLAVE ON *.* TO 'replica'@'%' IDENTIFIED BY 'password';
Start Replication & Dump/Load Existing Data
Start Replication & Dump/Load Existing Data
On Master 1 Prevent writing
Prevent writing to the database.
mysql> FLUSH TABLES WITH READ LOCK;
mysql> SHOW MASTER STATUS\G
*************************** 1. ROW ***************************
File: master1-bin.000001
POSITION: 254
Binlog_Do_DB:
Binlog_Ignore_DB:
1 ROW IN SET (0.20 sec)
Make note of the position and file name. You must have these later. From a terminal you now need to dump the database for loading onto the slaves.
bash> mysqldump -A -u root -p > master1.sql
On Master 2 Load the data from Master 1
Load the data from Master 1 onto Master 2.
bash> mysql -h master2.yourdomain.com -u root -p < master1.sql
Enable Master 2 as a slave
Enable Master 2 as a slave to Master 1 (refer to master 1's show master status above for MASTER_LOG* values)
Master-Master Setup is complete
If all you wanted was a master-master setup then you are finished. Any query executed on master 1 will also be executed on master 2.
Adding Slaves to your Master-Master
On Each Slave Follow this Procedure
Add the following to the [mysqld] section of my.cnf changing the server-id and master settings as appropriate and restart mysqld:
# this slave's server-id
server-id=11
# replicate from master 2
master-host=master2.yourdomain.com
master-port=3306
master-user=replica
master-password=replic8
master-connect-retry=10
Load the data dump from Master 1, if needed:
bash> mysql -h slave11.yourdomain.com -u root -p < master1.sql
Start Replication from Master 2 to each slave (refer to master 2's show master status above for MASTER_LOG* values)
Master-Master-Slave Setup is Complete
Congratulations, you are done with the server configuration! You may verify this by inserting or updating records on Master 1 and then verifying that the change is made on Master 1 and all of your slaves.
To Test replecation
on master1
mysql> USE blogdb1;
CREATE a test TABLE
mysql> CREATE TABLE recipes(ingredient VARCHAR(32), quantity VARCHAR(32), mtype VARCHAR(32), address VARCHAR(64));
mysql> INSERT INTO recipes(ingredient, quantity, address) VALUES('12345678', '5', 'North America');
on master2
mysql> SELECT * FROM recipes;
Do the same the other way around.
Mysql account info
mysql root pass: password
replecation user: replica
replecation password: password
drupal user : drupaluser
drupaluser password: password
Grant database access for the drupal blog user
Create a drupal user and grant access
mysql> CREATE USER 'drupaluser'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT ALL ON *.* TO 'drupaluser'@'blog1a.domain.com' IDENTIFIED BY 'password';
mysql> GRANT ALL ON *.* TO 'drupaluser'@'blog1b.domain.com' IDENTIFIED BY 'password';
mysql> GRANT ALL ON *.* TO 'drupaluser'@'blog2a.domain.com' IDENTIFIED BY 'password';
mysql> GRANT ALL ON *.* TO 'drupaluser'@'blog2b.domain.com' IDENTIFIED BY 'password';
mysql> GRANT ALL ON *.* TO 'drupaluser'@'10.20.16.151' IDENTIFIED BY 'password';
mysql> GRANT ALL ON *.* TO 'drupaluser'@'10.20.16.152' IDENTIFIED BY 'password';
mysql> GRANT ALL ON *.* TO 'drupaluser'@'10.20.16.153' IDENTIFIED BY 'password';
mysql> GRANT ALL ON *.* TO 'drupaluser'@'10.20.16.154' IDENTIFIED BY 'password';
FLUSH privileges;
Update the MySQL database with the latest drupal data
cd /opt/webstack/php/5.2/samples/scripts
./configure-sun-webserver
drupal zone configuration
The fowling blog zone configuration was used (just chnage the blog server name,path etc...)
create -b
set zonepath=/zones/blog1a
set autoboot=true
set scheduling-class=FSS
set ip-type=shared
add fs
set dir=/blog-data
set special=zones/blog-data
set type=lofs
end
add net
set address=10.10.254.130
set physical=igb0
end
MySQL zone configuration
create -b
set zonepath=/zones/blogdb1a
set autoboot=true
set scheduling-class=FSS
set ip-type=shared
add net
set address=10.10.254.132
set physical=igb0
end
add dataset
set name=zones/db1a
end
add dataset
set name=zones/logdb1a
end
Create and setup the ZFS file systems used by the blog & blogdb
For the blog drupal store create a zfs file system called zones/blog-data
zfs create -o mountpoint=/blog-data zones/blog-data
on the zone:
zonecfg -z [zonename]
add fs
set dir=/blog-data
set special=zones/blog-data
set type=lofs
end
commit
For the MySQL database create two file systems
zfs create -o recordsize=16 zones/db1a
zfs create zones/logdb1a
Add the data-set to the zone
zonecfg -z blogdb1aadd dataset
set name=zones/db1a
end
add dataset
set name=zones/logdb1a
end
commit
OS tuning
Tuning for the blog servers
Add to /etc/system
** limit ZFS cache to 4GB
set zfs:zfs_arc_max = 10737418240
** 256M pages
set max_uheap_lpsize=0x10000000
*
* Web Server Tuning
set rlim_fd_max=500000
set rlim_fd_cur=500000
** OS tuning
set ip_squeue_soft_ring=1
set ip:ip_soft_rings_cnt=8
set autoup=900
set sq_max_size=0
set consistent_coloring=2
set ip:ip_squeue_bind=0
set ip:ip_squeue_fanout=1
set ip:ip_squeue_enter=3
set ip:ip_squeue_worker_wait=0
set segmap_percent=6
set bufhwm=32768
set maxphys=1048576
set maxpgio=128
set ufs:smallfile=6000000
*For ipge driver
set ipge:ipge_tx_ring_size=2048
set ipge:ipge_tx_syncq=1
set ipge:ipge_srv_fifo_depth=16000
set ipge:ipge_reclaim_pending=32
set ipge:ipge_bcopy_thresh=512
set ipge:ipge_dvma_thresh=1
set pcie:pcie_aer_ce_mask=0x1
create /etc/init.d/NetTune.sh
cd /etc/rc2.d
ln -s /etc/init.d/NetTune.sh S70NetTune
#!/bin/bash
# ** Web Server tuning **
ndd -set /dev/tcp tcp_max_buf 4194304
ndd -set /dev/tcp tcp_cwnd_max 2097152
ndd -set /dev/tcp tcp_recv_hiwat 400000
ndd -set /dev/tcp tcp_xmit_hiwat 400000
ndd -set /dev/tcp tcp_conn_req_max_q 16384
ndd -set /dev/tcp tcp_conn_req_max_q0 16384
ndd -set /dev/tcp tcp_naglim_def 1
ndd -set /dev/tcp tcp_smallest_anon_port 2048
# ** make sure that all the network interfaces were not going to the same core
# * http://docs.sun.com/app/docs/doc/819-2635/abygx?a=view
allpsr=`/usr/sbin/psrinfo | grep -v off-line | awk '{ print $1 }'`
set $allpsr
numpsr=$#
while [ $numpsr -gt 0 ];
do
shift
numpsr=`expr $numpsr - 1`
tmp=1
while [ $tmp -ne 4 ];
do
/usr/sbin/psradm -i $1
shift
numpsr=`expr $numpsr - 1`
tmp=`expr $tmp + 1`
done
done
Tuning for the MySQL databse
Add to /etc/system
** limit ZFS cache to 10GB
set zfs:zfs_arc_max = 10737418240
** 256M pages
set max_uheap_lpsize=0x10000000
** Disable ZFS Prefetch needed for MySQL DB
set zfs:zfs_prefetch_disable = 1
** Disable ZFS cache flushes
*set zfs:zfs_nocacheflush = 1
** OS tuning
set ip_squeue_soft_ring=1
set ip:ip_soft_rings_cnt=8
set autoup=900
set sq_max_size=0
set consistent_coloring=2
set ip:ip_squeue_bind=0
set ip:ip_squeue_fanout=1
set ip:ip_squeue_enter=3
set ip:ip_squeue_worker_wait=0
create /etc/init.d/NetTune.sh
cd /etc/rc2.d
ln -s /etc/init.d/NetTune.sh S70NetTune
This link is needed to fix memcached looking for an older library
cd /usr/local/lib
ln -s libevent-1.2a.so.1.0.3 libevent-1.2.so.1
Mysql Backup scripts
Download the pytohn setup tools from http://pypi.python.org/pypi/setuptools
Download MySQL-python from sourcefourge
Download gcc & libiconv from www.sunfreeware.com
CREATE USER 'backupusr'@'localhost' IDENTIFIED BY 'password';
GRANT ALL ON *.* TO 'backupusr'@'blogdb1a.domain.com' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, CREATE, DROP, reload, shutdown, ALTER, super, LOCK TABLES, replication client ON *.* TO 'backupusr'@'blogdb2a.domain.com' IDENTIFIED BY 'password';
GRANT SELECT, INSERT, UPDATE, CREATE, DROP, reload, shutdown, ALTER, super, LOCK TABLES, replication client ON *.* TO 'backupusr'@'10.20.22.153' IDENTIFIED BY 'password';
FLUSH privileges;
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish, through the settings link in the bottom of the page. ACCEPT
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
