PlanetMysql.ru — информация о СУБД MySQL

Topics for this podcast:

*Hadoop v1.0 and year ahead
*Oracle-Cloudera deal for more Hadoop
*Oracle’s ‘Sun spot’ with Solaris
*Open Source M&A outlook for 2012
*Our new MySQL/NoSQL/NewSQL survey

iTunes or direct download (28:49, 4.9MB)

PlanetMySQL Voting: Vote UP / Vote DOWN

The installation through the Solaris repository is as simple as typing:

$ pkg install mysql-50

to obtain MySQL 5.0.91 (status Jan 18, 2012) or click on this link to launch the interactive installer.

$ pkg install mysql-51

to obtain MySQL 5.1.37 (status Jan. 18, 2012) or click on this link to launch the interactive installer.

PlanetMySQL Voting: Vote UP / Vote DOWN

The SAP ABAP components for

• SAP Netweaver 7.0 
• SAP ERP 6.0 (including Enhancement Package 2 and 3) 
• SAP CRM 5.0 
• SAP CRM 2007(6.0) 
• SAP SCM 5.0 (liveCache Server 7.6 is not supported) 
• SAP SCM 5.1 (liveCache Server 7.7 is supported) 
• SAP SRM 5.0

using one of the two databases

• Oracle 11.2.0.3
• MaxDB 7.8.2.26 

with SAP Kernel 7.20_ext are supported on Solaris 11. The details are documented in the SAP note 1643799 (access for SAP customers only).

PlanetMySQL Voting: Vote UP / Vote DOWN

Lots of great energy, events, presentations and receptions going on at Oracle Open World. Two very key receptions are happening Tuesday night. The Solaris Family Reunion reception and the MySQL reception.

The Solaris reunion reception info is: http://smartos.eventbrite.com/

The MySQL Reception will be at SF Marriott Marquis – Foothill G, 55 Fourth Street, at 7:00pm.

Talked to a number of ex Sun and MySQL dolphins who will be at these events. It’s great that OOW provides the environment for so many great reunions.  A lot of key people from the great days at Sun and MySQL will be there.

PlanetMySQL Voting: Vote UP / Vote DOWN

Last week we concluded our first Oracle Technology Network Sys Admin Day in Sacramento (CA). Well, it was actually the second Sys Admin Day, but the first one that had two parallel tracks of sessions about both Oracle Linux and Oracle Solaris.

I helped preparing for the event by creating the Linux lab handbook as well as the VirtualBox appliance of Oracle Linux 6.1 that was used for the exercises. Unfortunately I could not be there in person, but it would have been pointless for me to go on an intercontinental flight just for one day.

From the feedback we've received so far, the attendees really enjoyed the event and were positively surprised about the depth and quality of the practical hands-on lab sessions.

If you've missed the first one and happen to live somewhere in the Seattle area, you have another chance to attend OTN sysadmin day: we'll be hosting another one on Thursday, September 22nd at The Westin Seattle (1900 5th Ave., Seattle, WA 98101). Again, attendance is free, all you need to bring is your own laptop with VirtualBox installed. We'll provide the rest. Space is limited — you can review the agenda and register here!

PlanetMySQL Voting: Vote UP / Vote DOWN

Three ways to recover a root user password:

The order of solutions here under gets more creative on the way down :)

1. obviously, before starting messing around check my.cnf or scripts for passwords entries, then try home directories for password files
2. secondly – can you restart mysql? if yes, restart with –skip-grant-tables, log into mysql, change your password and restart without –skip-grant-tables
3. third option – (on linux / unix ONLY)
If you haven’t found the password anywhere and can’t afford to restart your mysql.

cd data/mysql
cp -rp user.MYD bck_user.MYD_`date +%Y%m%d`
cp -rp user.MYD /tmp/user.MYD
vi /tmp/user.MYD #(edit the hashed passwords next to root*)
cp -rp /tmp/user.MYD user.MYD
sudo kill -HUP `pidof mysqld`

Note that the latter method of recovering a root password CAN be easily used maliciously leaving no trace! The only way to avoid such an attack is to make the data directory ONLY readable and writable by the user used to start/stop mysql (don’t user *nix root user to own mysql since that opens another can of worms … it’s a whole other blog post).

PlanetMySQL Voting: Vote UP / Vote DOWN

On September 8, 2010 Oracle announced the availability of Oracle Solaris Cluster 3.3

Oracle Solaris Cluster 3.3, built on the solid foundation of Oracle Solaris, offers the 
most extensive Oracle enterprise High Availability and Disaster Recovery solutions for the 
largest portfolio of mission-critical applications.

Integrated and thoroughly tested with Oracle's Sun servers, storage, connectivity 
solutions and Solaris 10 features, Oracle Solaris Cluster is now qualified with Solaris 
Trusted Extensions, supports Infiniband for general networking or storage usage, and can 
be deployed with Oracle Unified Storage in Campus Cluster configurations. It extends its 
applications support to new Oracle applications such as Oracle Business Intelligence, 
PeopleSoft, TimesTen, and MySQL Cluster.

The single, integrated HA and DR solution enables multi-tier deployments in virtualized 
environments. In this release, Oracle Solaris Containers clusters supports even more 
configurations including additional applications (Oracle WebLogic Server, Siebel CRM, and 
more) and integration with Oracle Solaris Cluster Geographic Edition.


Benefits:

    * Delivers unrivaled High Availability on Oracle Solaris OS for much faster failure 
detection and recovery

    * Enables cost-savings without performance compromise by integrating seamlessly with 
Oracle Solaris Containers for applications and databases consolidation

    * Out of the box support for a wide selection of applications

    * Certified with a broad range of storage arrays from Oracle and third parties on 
SPARC and x86 platforms


New features:

-------------

Availability:

- Active Monitoring of Storage Resources

- Flexible load distribution of application services



Virtualization:

- Extended Oracle Solaris Containers cluster support:

* NAS, GFS, RDSV1

* More applications : Oracle WebLogic Server, OBIEE, MySQL cluster,

 PeopleSoft, TimesTen



Hardware Integration:

- InfiniBand on public network and as storage connectivity



Application Integration

- New agents: Oracle Business Intelligence Enterprise Edition,

 PeopleSoft Enterprise, MySQL cluster, TimesTen

- Updates on Oracle E-Business Suite, WebLogic Server, MySQL, SAP

- Oracle 11gR2 database and RAC support


Disaster Recovery

- Containers cluster  with Geographic Edition

- Sun Unified Storage 7xxxx in campus cluster


Security

- Solaris Trusted Extensions



Ease of use

- Wizards for ASM configurations set-up

- GUI and CLI performance improvements

- Power Management User interface

- Node rename



Compatibility information

--------------------------

Supported Solaris release: Solaris 10 10/09, Solaris 10 9/10



Media Kit and downloads

-----------------------------------

Software is available through

- OTN (for evaluation and tests)

http://www.oracle.com/technetwork/server-storage/solaris-cluster/downloads/index.html


- e-delivery (for production use - requires purchase of commercial license)

http://edelivery.oracle.com

Select Product Pack:  Oracle Solaris

From results pick:  Oracle Solaris Cluster 3.3 Media Pack


Documentation

---------------------

* Oracle Solaris Cluster 3.3 Documentation Center:

http://www.oracle.com/technetwork/documentation/solaris-cluster-33-192999.html


* Release Notes Information:

http://wikis.sun.com/display/SunCluster/Release+Notes+Information

The Release Notes documents on this site are regularly updated with new

documentation to support new features, hardware qualifications, bug

workarounds, and other late-breaking information. Check the Release

Notes or Release Notes Supplement for your release before installing the

cluster or performing any maintenance.



Web site

----------------

http://www.oracle.com/technetwork/server-storage/solaris-cluster/overview/index.html

PlanetMySQL Voting: Vote UP / Vote DOWN

So far the benchmarking script supports Linux, FreeBSD, and OSX. I’m installing virtual machines today to get ready for development on the next OS that the community wants to have supported. Vote today for your choice. Development will begin Friday 2010-09-03.

Note: There is a poll embedded within this post, please visit the site to participate in this post's poll.
PlanetMySQL Voting: Vote UP / Vote DOWN

Last week's "announcement" of the death of OpenSolaris has steered a lot of questions my way about where people should go, and/or where OmniTI will go, now that OpenSolaris future looks non-existent. As one of the more open users of Solaris related technology, and running some beefy loads on top of it, it makes sense that people would be curious as to what we might be doing next. I would start with saying that as a company, we don't have an official policy on this yet, and probably won't. We evaluate each situation on a customer by customer basis, so what follows here is more my personal feelings on what people should do at this current point in time.

The one thing I have noticed from the people I have already spoken with is that there seem to be two major camps, an over simplification to be sure, but I break this down into the free software camp (those motivated by a desire to remain on open source, and/or support, free software as a primary driver of technology decisions), and those more interested in the technology than the ideals behind it. Depending on where you fall into that spectrum, you have different options available to you, and will likely reach very different conclusions.

Too Soon?

The first thing I have said to everyone is that it is honestly too soon to make any moves. Oracle is notorious for being poor communicators, and at this point I don't think we've seen enough official communication to really know what's going to happen. This doesn't mean you can't start planning though! We've been looking at some of the available options since before the Oracle/Sun merger was closed, so it doesn't hurt to start evaluating the options out there. However there's no need to rush in to things; it is possible that the announcement of OpenSolaris's death might be premature. I personally don't believe Solaris can't survive based on the model we've just seen laid out; there are too many people learning the gnu tool chain who won't be willing to invest big money into a tool that is hard for them to use. They need a low cost / free option for people to familiarize themselves on (and all the better if it installs gnu tools by default). There's an outside chance Oracle might come to this conclusion, which would give new life to OpenSolaris.

A more likely alternative to that theory is that some other group might pick up OpenSolaris maintenance and start pushing it forward. Certainly not an easy task, but there are already several different distribution of OpenSolaris available, so the userland level management has the resources, we mostly would need to figure out how to handle the more core technologies that have been maintained by Sun. I think this might also be possible, as there are numerous companies already heavily invested in OpenSolaris technology, and there are Solaris internals hackers looking to move out of Oracle, it's not an impossible leap to think we might see something worked out. And if Oracle continuous to make technology available via the CDDL (which most of the current signs seem to indicate), this could work out. I would say that this might not resemble the OpenSolaris as it is now, but could definitely be an option for current users who'd like to remain on the OpenSolaris platform.

Other Options?

Of course, you might not want to put all your eggs in that basket. So what other options do we have? Well, that mostly depends on what you're getting out of OpenSolaris now, and what you want out of your OS going forward. For many people, I suspect that Solaris 11 Express might be a suitable replacement, especially for those running mixed OpenSolaris / Solaris environments. Migrating up to full Solaris 11 will also cover most of your technology needs, so depending on pricing I suspect people may find that a cheaper alternative to migrating to a new platform. Of course, if you want to stick with a free software solution, this won't really be an option.

FreeBSD seems to be the most obvious alternative platform. If you're currently taking advantage of dtrace, zfs, and zones, FreeBSD gives you options to cover all three. It won't be the same; the dtrace and zfs implementations are pretty close aiui, but for zones you'll probably have to use either Jails or OpenVS, neither of which am I a fan of. I think you'd also find a larger overlap in system utilities (tar, find, grep, etc..) between FreeBSD and Solaris, so for people (and scripts) making the transition, this might be an easier move. The big question here is probably hardware support; if you can't get FreeBSD running on your hardware, that's likely to be a show stopper, unless you can work out a new hardware purchase in the transition

So, if you don't want to go closed Solaris, and FreeBSD isn't an option, that probably leaves you on Linux. People sometimes think I don't like Linux; I'm actually very comfortable on it. My first "unix" was Linux, and we run some extremely demanding systems on Linux and it has performed well in those cases. However if you're trying to do deep introspection, systemtap is a poor man's dtrace. And if you are relying on zfs, you'll have a hard time finding a suitable replacement amongst the current Linux options. Personally I am most comfortable on ext3, but I tend to give up on file system snapshots, which is a painful submission if you have to make it. XFS is probably the next most common option, and generally I've no bones about using it if you want to avoid ext3. Of the three "advanced" replacements; ext4, btrfs, and zfs on linux; I think ext4 is probably your best bet, but only because zfs is too new for any serious database systems, and if you are moving off OpenSolaris to get away from Oracle, "butter" seems like an odd choice.

And so...

I think it's wise to keep things in perspective. There are some cases where you want to be a technology leader (we've been running Postgres 9 for months on some systems), but generally speaking when it comes to picking the operating system and filesystem for your database, it's best to tread lightly. Now is a fine time to start evaluating your options; at least figure out what features are critical to your enterprise that you'll need to replace (and don't just think about database, you might be relying on crossbow for something, or who knows what else). We'll certainly be watching the current options available, and I suspect diversifying a little, over the next 6 months, as we wait for the picture to clear up where we can. We're not in a hurry (after all, we do have the source code of what we're running now), and I don't see much reason for others to be either.
PlanetMySQL Voting: Vote UP / Vote DOWN

Here’s a simple answer to a simple question. “How do I run a backup of MySQL to another machine without writing to the local server’s filesystem?” – this is especially useful if you are running out of space on the local server and cannot write a temporary file to the filesystem during backups.

Method one – this writes a remote file.
mysqldump [options] [db_name|--all-databases]| gzip -c | ssh user@host.com "cat > /path/to/new/file.sql.gz"

Method two – this writes directly into a remote mysql server
mysqldump [options] [db_name|--all-databases]| mysql --host=[remote host] –user=root –password=[pass] [db_name]

PlanetMySQL Voting: Vote UP / Vote DOWN