Old Posts:
09.04
10.04
11.04
12.04
01.05
02.05
03.05
04.05
05.05
06.05
07.05
08.05
09.05
10.05
11.05
12.05
01.06
02.06
03.06
04.06
05.06
06.06
07.06
08.06
09.06
10.06
11.06
12.06
01.07
02.07
03.07
04.07
05.07
06.07
08.07
09.07
10.07
11.07
12.07
01.08
02.08
03.08
04.08
05.08
06.08
07.08
08.08
09.08
10.08
11.08
12.08
01.09
02.09
03.09
04.09
05.09
06.09
07.09
08.09
09.09
10.09
11.09
12.09
01.10
02.10
03.10
04.10
05.10
06.10
07.10
08.10
09.10
10.10
11.10
12.10
01.11
02.11
03.11
04.11
05.11
07.11
08.11
09.11
10.11
11.11
12.11
01.12
02.12
03.12
04.12
05.12
06.12
07.12
08.12
09.12
10.12
11.12
12.12
01.13
02.13
03.13
04.13
05.13
06.13
07.13
08.13
09.13
10.13
11.13
12.13
01.14
02.14
03.14
04.14
05.14
06.14
07.14
09.14
10.14
11.14
12.14
01.15
02.15
03.15
04.15
06.15
09.15
12.15
01.16
03.16
04.16
05.16
06.16
07.16
08.16
09.16
12.16
01.17
02.17
03.17
04.17
06.17
07.17
08.17
09.17
10.17
12.17
01.18
02.18
03.18
04.18
05.18
06.18
07.18
08.18
09.18
11.18
12.18
01.19
02.19
05.19
06.19
08.19
10.19
11.19
05.20
10.20
11.20
12.20
09.21
11.21
12.22
Thursday, February 26, 2009
Accessing MySQL Database(s) with JDBC
A new technical article entitled "Using MySQL With Java Technology", has been posted on java.sun.com at:
http://java.sun.com/developer/technicalArticles/mysql_java/index.htmlThis article explains the essential steps involved in manipulating the data in a MySQL database from a Java application. MySQL Connector/J JDBC driver was used in the example code to show the database connectivity, data manipulation steps. Application developers who are new to Java programming language [but not to MySQL database] are the target audience of this article.
Stay tuned for the next article in this series "Using MySQL with PHP" ..
_______________
Technorati Tags:
Java |
JDBC |
MySQL |
Connector/J
Tuesday, February 24, 2009
Sun Blueprint : MySQL in Solaris Containers
While the costs of managing a data center are becoming a major concern with the increased number of under-utilized servers, customers are actively looking for solutions to consolidate their workloads to:
- improve server utilization
- improve data center space utilization
- reduce power and cooling requirements
- lower capital and operating expenditures
- reduce carbon footprint, ..
To cater those customers, Sun offers several virtualization technologies such as Logical Domains, Solaris Containers, xVM at free of cost for SPARC and x86/x64 platforms.
In order to help our customers who are planning for the consolidation of their MySQL databases on systems running Solaris 10, we put together a document with a bunch of installation steps and the best practices to run MySQL inside a Solaris Container. Although the document was focused on the Solaris Containers technology, majority of the tuning tips including the ZFS tips are applicable to all MySQL instances running [on Solaris] under different virtualization technologies.
You can access the blueprint document at the following location:
Running MySQL Database in Solaris ContainersThe blueprint document briefly explains the MySQL server & Solaris Containers technology, introduces different options to install MySQL server on Solaris 10, shows the steps involved in installing and running Solaris Zones & MySQL, and finally provides few best practices to run MySQL optimally inside a Solaris Container.
Feel free to leave a comment if you notice any incorrect information, or if you have generic suggestions to improve documents like these.
AcknowledgmentsMany thanks to Prashant Srinivasan, John David Duncan and Margaret B. for their help in different phases of this blueprint.
_______________
Technorati Tags:
Sun |
Solaris |
OpenSolaris |
MySql |
Virtualization |
Containers |
Zones |
Best Practices |
Consolidation
Sunday, February 22, 2009
PeopleSoft HRMS 8.9 Self-Service Benchmark on M3000 & T5120 Servers
Sun published the PeopleSoft HRMS 8.9 Self-Service benchmark results today. The benchmark was conducted on 3 x Sun SPARC Enterprise M3000 and 1 x Sun SPARC Enterprise T5120 servers. Click on the following link for the full report with the benchmark results.
PeopleSoft HRMS 8.9 SELF-SERVICE Using ORACLE on Sun SPARC Enterprise M3000 and Enterprise T5120 ServersAdmittedly it is Sun's first PeopleSoft benchmark after a hiatus of over five years. However I am glad that we came up with a very nice cost effective solution in our comeback effort to the PeopleSoft applications' benchmarking.
Some of the notes and highlights from this competitive benchmark are as follows.
- The benchmark measured the average search and save transaction response times at a peak load of 4,000 concurrent users.
- 4,000 users is the limitation of the benchmark kit. All vendors using this benchmark kit are bound to this limitation. Hence it is easy to compare the performance as the throughput achieved by each vendor will be the same. In comparing the benchmark results from workloads like these, lower average [transaction response times, CPU, memory utilizations] and the hardware in use (lesser the better), usually indicate better performance.
- IBM and Sun are the only vendors who published benchmark results with PeopleSoft HRMS 8.9 Self-Service benchmark kit.
- Sun's benchmark results are superior relative to IBM's best published result on a combination of z990 2084-C24 and eServer pSeries p690 servers. While I leave the price comparisons to the reader1, I'd like to show the performance numbers extracted from the benchmark reports published by Sun and IBM. All the following data/information is available in the benchmark reports. Feel free to draw your own conclusions.
Average Transaction Response Times
Vendor | Single User Search (sec) | 4,000 Users Search (sec) | Single User Save (sec) | 4,000 Users Save (sec) |
Sun | 0.78 | 0.77 | 0.71 | 0.74 |
IBM | 0.78 | 1.35 |
0.65 | 1.01 |
Average CPU Utilizations
Vendor | Web Server CPU% | App Server1 CPU% | App Server2 CPU% | DB Server CPU% |
Sun | 23.10 |
66.92 | 67.85 | 27.45 |
IBM | 45.81 | 59.70 | N/A |
40.66 |
Average Memory Utilizations
Vendor | Web Server GB | App Server1 GB | App Server2 GB | DB Server GB |
Sun | 4.15 |
3.67 | 3.72 | 5.54 |
IBM | 5.00 | 15.70 | N/A | 0.3 (Huh!?) |
Hardware Configuration
Vendor: Sun Microsystems
Topology Diagram
Tier | Server Model | Server Count | Processor |
Processor Speed | Processor Count | #Cores per Processor | Memory |
Web | T5120 | 1 |
UltraSPARC-T2 | 1.2 GHz |
1 | 4 | 8 GB |
App | M3000 |
2 | SPARC64-VII | 2.52 GHz | 1 | 4 | 8 GB |
DB | M3000 |
1 | SPARC64-VII | 2.52 GHz | 1 | 4 | 8 GB |
2 x Sun Storage J4200 arrays were used to host the database. Total disk space: ~1.34 Terabytes. Consumed only 120 GB disk space -- 115 GB for data on one array; and 5 GB for redo logs on the other array.
Vendor: IBM
Tier | Server Model | Server Count | Processor |
Processor Speed | Processor Count | #Cores per Processor | Memory |
Web | p690 (7040-681) | 1 | POWER4 | 1.9 GHz |
4 | NA (?) | 12 GB |
App | p690 (7040-681) |
1 | POWER4 | 1.9 GHz | 12 | NA (?) | 32 GB |
DB | zSeries 990, model 2084-C24 | 1 | z990 Gen1 | ??? | 6 |
NA (?) | 32 GB |
1 x IBM TotalStorage DS8300 Enterprise Storage Server, 2107-922 ws used to host the database. Total disk space: ~9 Terabytes.
- The combination of Sun SPARC Enterprise M3000 and T5120 servers consumed 1030 Watts on the average in a 7RU space in achieving 4,000 concurrent users. That is, in the case of similarly configured workloads, M3000/T5120 support 3.88 users per watt of the power consumed; and 571 users per rack unit.
Just like our prior
Siebel and
Oracle E-Business Suite Payroll 11i benchmarks, Sun collaborated with Oracle Corporation in executing this benchmark. And we sincerely thank our peers at Oracle Corporation for all their help and support over the past few months in executing this benchmark.
___________
I'm planning to post some of the tuning tips to run PeopleSoft optimally on Solaris 10. Stay tuned ..
(
Originally posted on blogs.sun.com at:
http://blogs.sun.com/mandalika/entry/peoplesoft_hrms_8_9_self)
________________
Technorati Tags:
Solaris |
sun |
oracle |
peoplesoft |
hrms |
benchmark |
m3000 |
t51201: It is relatively hard to obtain IBM's server list prices. On the other hand, it is very easy to find the list prices of Sun servers' from
http://store.sun.com
Wednesday, February 11, 2009
Mounting Windows' NTFS on [Open]Solaris x86/x64
The steps outlined in this blog post are derived from the
Miscellaneous filesystem support for OpenSolaris on x86 web page. I just added few examples to illustrate the steps to mount a partition with NTFS filesystem that exists on the external hard drive (in this case, it is a Seagate FreeAgent external hard drive).
Step-by-Step instructions to mount NTFS filesystem on [Open]Solaris- Install the packages : FSWpart and FSWfsmisc.
- Find the logical device name for the NTFS partition.
-l
option of the rmformat
command lists all removable devices along with their device names.
# rmformat -l
Looking for devices...
1. Logical Node: /dev/rdsk/c1t0d0p0
Physical Node: /pci@0,0/pci-ide@1f,1/ide@1/sd@0,0
Connected Device: MATSHITA UJDA750 DVD/CDRW 1.60
Device Type: DVD Reader
Bus: IDE
Size:
Label:
Access permissions:
2. Logical Node: /dev/rdsk/c2t0d0p0
Physical Node: /pci@0,0/pci1179,1@1d,7/storage@1/disk@0,0
Connected Device: Seagate FreeAgentDesktop 100F
Device Type: Removable
Bus: USB
Size: 953.9 GB
Label:
Access permissions:
- Identify the NTFS partition on the external disk with the help of
fdisk
# fdisk /dev/rdsk/c2t0d0p0
Total disk size is 60800 cylinders
Cylinder size is 32130 (512 byte) blocks
Cylinders
Partition Status Type Start End Length %
========= ====== ============ ===== === ====== ===
1 IFS: NTFS 0 60800 60801 100
SELECT ONE OF THE FOLLOWING:
1. Create a partition
2. Specify the active partition
3. Delete a partition
4. Change between Solaris and Solaris2 Partition IDs
5. Exit (update disk configuration and exit)
6. Cancel (exit without updating disk configuration)
Enter Selection: 6
#
In this example, partition #1 i.e., c2t0d0p1 has the NTFS filesystem.
- Mount the NTFS partition just like mounting an UFS filesystem using the
mount
command. Use the argument ntfs
to the command line option -F
. Since the filesystem was mounted in a slightly different way than the conventional way, use /usr/bin/xlsmounts
to see the detailed mount table information.
# mount -F ntfs /dev/dsk/c2t0d0p1 /mnt
# /usr/bin/xlsmounts
PHYSICAL DEVICE LOGICAL DEVICE FS PID ADDR Mounted on
/dev/dsk/c2t0d0p1 /dev/dsk/c2t0d0p1 ntfs 6755 127.0.0.1:/ /mnt
# ls /mnt
expForSun.dmp MySQL5.1 RECYCLER
medium-64-bit $RECYCLE.BIN System Volume Information
Notice the 127.0.0.1:/
under ADDR
column in the output of xlsmounts
. NTFS mount uses userland NFSv2 server to access the filesystems on raw partitions. That is why the mount was shown as NFS client mounted from 127.0.0.1:/
- To unmount the NTFS filesystem, use
/usr/bin/xumount
. Solaris standard umount
command unmounts the filesystem but does not terminate the background NFS server process.
# /usr/bin/xumount /mnt
- OR -
# /usr/bin/xumount /dev/dsk/c2t0d0p1
Check the
Miscellaneous filesystem support for OpenSolaris on x86 page and Moinak Ghosh's blog post
Mount and Access NTFS and Ext2FS from Solaris x86 for the rest of the fine details.
(
Originally posted on blogs.sun.com at:
http://blogs.sun.com/mandalika/entry/mounting_windows_ntfs_on_open)
_______________
Technorati Tags:
Solaris |
OpenSolaris |
NTFS
Sunday, February 08, 2009
Workaround to "eject of cdrom /dev/dsk/cxtxdxsx failed" Error on SXCE b106
SymptomOn Solaris Express Community Edition build 106,
eject(1)
fails intermittently (esp. when inserted the blank media) with the error:
eject of cdrom /dev/dsk/cxtxdxsx failed
.
# cat /etc/release
Solaris Express Community Edition snv_106 X86
Copyright 2009 Sun Microsystems, Inc. All Rights Reserved.
Use is subject to license terms.
Assembled 13 January 2009
# eject
eject of cdrom /dev/dsk/c1t0d0s2 failed: A security policy in place prevents this sender
from sending this message to this recipient, see message bus configuration file (rejected
message had interface "org.freedesktop.Hal.Device.Storage" member "Eject" error name
"(unset)" destination "org.freedesktop.Hal")
SolutionUpgrade to snv_107. Meanwhile check the bug #
6791982.
Workaround- Edit /etc/dbus-1/system.d/hal.conf.
Add the following line to the <policy context="default">
section.
<allow send_interface="org.freedesktop.Hal.Device.Storage"/>
- Restart the D-Bus message bus system service.
svcadm restart svc:/system/dbus:default
On a totally unrelated note, to see all the existing SMF services with a simple description, run:
svcs -o FMRI,DESC
- Finally try to eject the CD/DVD disk by typing the
eject
command.
(Originally posted on blogs.sun.com at:
http://blogs.sun.com/mandalika/entry/sxce_snv_106_workaround_to)_______________
Technorati Tags:
Solaris |
OpenSolaris |
troubleshooting
2004-2019 |
|
|