Planet MySQL

+2

-0

posted by Oracle MySQL Group on Mon 08 Oct 2012 07:35 UTC
Tags:

(edit) mysql, Oracle, Replication, cluster, solaris, ha, drbd, vm

Data is the currency of today’s web, mobile, social, enterprise and cloud applications. Ensuring data is always available is a top priority for any organization – minutes of downtime will result in significant loss of revenue and reputation.

There is not a “one size fits all” approach to delivering High Availability (HA). Unique application attributes, business requirements, operational capabilities and legacy infrastructure can all influence HA technology selection. And then technology is only one element in delivering HA – “People and Processes” are just as critical as the technology itself.

For this reason, MySQL Enterprise Edition (http://www.mysql.com/products/enterprise/) is available supporting a range of HA solutions, fully certified and supported by Oracle. MySQL Enterprise HA

[Read more...]

CAOS Theory Podcast 2012.01.20

+0

-0

posted by The 451 Group on Fri 20 Jan 2012 20:24 UTC
Tags:

(edit) mysql, Oracle, Linux, podcast, opensource, solaris, caostheory, matt aslett, open-source, The 451 Group, the451group, OpenSolaris, Sun Microsystems, Systems Management, jay lyman, caos theory, cloudera, big data, Mergers and acquisitions, NoSQL, devops, M&A, newsql, Apache Hadoop

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)

MySQL 5.0 and 5.1 available on Solaris 11

+2

-0

posted by Sun Partner Technology on Wed 18 Jan 2012 01:34 UTC
Tags:

(edit) mysql, sun, solaris, 5.0, 5.1, download, 11, available, certified

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.

2012 to be year of Linux domination

+0

-1

posted by The 451 Group on Thu 05 Jan 2012 19:10 UTC
Tags:

(edit) Oracle, Windows, software, Linux, microsoft, ibm, suse, opensource, Apple, solaris, ip, Red Hat, patent, 451 group, 451caostheory, 451group, caostheory, open-source, The 451 Group, the451group, hpc, developers, os, jay lyman, jaylyman, servers, survey, android, partners, BSD, predictions, Hewlett-Packard, Azure, fud, supercomputing, SMBs, channel, 2012, high-end, mid-market, mobile devices, Top500

Previously, I’ve called out years for non-desktop Linux in 2008, Linux in both the low and high-ends of the market in 2009, ‘hidden’ Linux in 2010 and last year, cloud computing in 2011. For 2012, I see continued growth, prevalence, innovation and impact from Linux, thus leading to a 2012 that is dominated by Linux.

I expect to see nothing but continued strength for Linux and

+1

-1

posted by Sun Partner Technology on Fri 23 Dec 2011 09:06 UTC
Tags:

(edit) sap, sun, solaris, Kernel, netweaver, 11, abap

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).

Tuesday at Oracle Open World 2011 – Sun Family Reunion and MySQL Reception

+0

-0

posted by IOUG Blogs on Tue 04 Oct 2011 15:20 UTC
Tags:

(edit) mysql, solaris, IOUG General, George Trujillo

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 … Continue reading →

Join us at the OTN Sys Admin Day for Oracle Linux and Solaris on Sep. 22nd, Seattle (WA)

+3

-0

posted by Lenz Grimmer on Wed 14 Sep 2011 20:39 UTC
Tags:

(edit) mysql, Oracle, Linux, event, meeting, lvm, solaris, Free, administration, seminar

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

+1

-0

posted by Lenz Grimmer on Thu 28 Apr 2011 15:50 UTC
Tags:

(edit) mysql, Oracle, OSS, event, Development, solaris, administration

The folks at OTN have been very busy — among many others (both virtual and in RL), there are two upcoming developer/sysadmin days about MySQL and Solaris. Both will take place in California next month:

On Tuesday, May 03, 2011, 8:00am to 4:00 pm, there will be the OTN Developer Day for MySQL in the Oracle Santa Clara Agnews Campus Auditorium. It will cover application development with MySQL, performance tuning tips and managing MySQL environments.
On Tuesday, May 17, 2011, 8:00 am to 4:00 pm, the OTN's first

+8

-0

posted by Dimitri Kravtchuk on Fri 01 Apr 2011 19:00 UTC
Tags:

(edit) mysql, Oracle, solaris

Cannot give you all details yet and it's too early to say what the max performance we'll finally obtain, but currently we out-passed 100.000.000 (!) Read+Write transactions/sec on the latest MySQL 5.5 simply integrated on the Exadata X2-8 (full rack) instead of Oracle database!!! :-))

The result is so incredible.. - but we spent several days now to validate that workload is perfectly matching customer's requirement and really reproducing their production environment. The problem came from the performance issue they observed month to month and came in our Benchmark Center to test a new HW platform (and we're in competition here with HP and IBM, but they have already finished their testing

+3

-0

posted by Darren Cassar on Mon 21 Mar 2011 19:00 UTC
Tags:

(edit) mysql, Linux, authentication, solaris, password, user, root, Intermediate, Mac OS, skip-grant-tables, grants, pass, user.myd

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

[Read more...]

Oracle Solaris Cluster 3.3 available

+2

-2

posted by Sun Cluster Engineering on Fri 18 Mar 2011 20:08 UTC
Tags:

(edit) sun, cluster, solaris, recovery, disaster, availabiity, suncluster

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.

[Read more...]

Oracle Solaris Cluster 3.3 available

+0

-0

posted by Sun Cluster Engineering on Fri 18 Mar 2011 13:08 UTC
Tags:

(edit) Oracle, sun, cluster, solaris, recovery, disaster, availabiity, suncluster

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

[Read more...]

Oracle Solaris Cluster 3.3 available

+0

-0

posted by Sun Cluster Engineering on Fri 18 Mar 2011 13:08 UTC
Tags:

(edit) Oracle, sun, cluster, solaris, recovery, disaster, availabiity, suncluster, Oracle Solaris Cluster

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

[Read more...]

MariaDB makes it to Solaris 10 x86

+5

-0

posted by Darren Cassar on Fri 11 Feb 2011 18:21 UTC
Tags:

(edit) mysql, solaris, mariadb, monty porgram, mpab

Monty Program AB have recently released a tar.gz package of MariaDB for Solaris 10 x86, something I have been waiting on for a while. Thank you guys!

Download here — Note that this is a beta release so use with caution and not in prod unless you know what you are doing or nuts. If you have any issues MPAB can be contacted here.

[mysql@dc /mysql/mariadb-5.1.53-solaris10-i386 03:15:27]$  uname -a
SunOS dc 5.10 Generic_141415-08 i86pc i386 i86pc
[mysql@dc /mysql/mariadb-5.1.53-solaris10-i386 03:15:33]$  bin/mysql -uroot
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 5
Server version: 5.1.53-MariaDB-log Source distribution

This software comes with ABSOLUTELY

+0

-0

posted by Matt Reid on Thu 02 Sep 2010 20:24 UTC
Tags:

(edit) mysql, Windows, Uncategorized, Linux, solaris, Benchmarking, mysql server, BSD

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.

Now What? (wrt OpenSolaris and your database)

+0

-0

posted by Robert Treat on Mon 16 Aug 2010 13:45 UTC
Tags:

(edit) mysql, postgres, solaris

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 [Read more...]

Easy MySQL: how to backup databases to a remote machine

+3

-1

posted by Matt Reid on Fri 13 Aug 2010 21:27 UTC
Tags:

(edit) mysql, Linux, solaris, Backups, Scripts, mysql server, mysqldump, bash, Scripting, ssh, scp

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]

Oracle legal move evokes many questions

+9

-3

posted by The 451 Group on Fri 13 Aug 2010 18:30 UTC
Tags:

(edit) mysql, Oracle, Java, software, Linux, microsoft, Development, open source software, Legal, Google, opensource, solaris, glassfish, Linux Foundation, 451 group, 451caostheory, 451group, caostheory, open-source, The 451 Group, the451group, developers, OpenOffice.org, jay lyman, jaylyman, android, lawsuit, software patents, court, law, oin, Open Invention Network, lawyers

There are many questions that arise out of Oracle’s copyright and patent infringement complaint against Google regarding its use of Java in Android. There are several things that make the suit significant to the entire industry: it centers not just on software copyright, but also software patents (an increasingly and hotly debated issue), the quickly-expanding smartphone market and open source software. The first question is: what is Oracle doing?

Many are speculating that this is simply an effort to further and more effectively monetize Java, a storied program language that has move more toward openness and survived several supposed death sentences as newer languages arrived. Still, with all of the open source parts — GlassFish application server, MySQL database, OpenOffice.org suite — is Java the most significant to Oracle? It may be, but regardless of what

[Read more...]

mysqldump each object separately

+3

-1

posted by Darren Cassar on Thu 12 Aug 2010 21:11 UTC
Tags:

(edit) mysql, Stored Procedures, Linux, solaris, mysqldump, os, dump, Mac OS

As a continuation to a previous blog post last week and inspired by Kedar I have created a small script to export tables, stored procedures, functions and views into their respective file. It works for multiple databases where you can specify a list of databases too and although things like events, triggers and such are still missing they are easily added.

It is especially useful to dump stored procedures separately since it is a lacking functionality in mysqldump.

I placed the script in mysql forge for anybody to use, provide feedback and possibly enhancements to it.

Determining I/O Throughput for a System

+3

-3

posted by Sheeri K. Cabral on Thu 29 Jul 2010 15:23 UTC
Tags:

(edit) mysql, Oracle, Conferences, Linux, benchmark, Group Blog Posts, solaris, Pythian, AIX, io, Kaleidoscope, odtug, kscope, hpux, io throughput, iops, metrics, zlinux

At Kscope this year, I attended a half day in-depth session entitled Data Warehousing Performance Best Practices, given by Maria Colgan of Oracle. In that session, there was a section on how to determine I/O throughput for a system, because in data warehousing I/O per second (iops) is less important than I/O throughput (how much actual data goes through, not just how many reads/writes).

The section contained an Oracle-specific in-database tool, and a standalone tool that can be used on many operating systems, regardless of whether or not a database exists:

If Oracle is installed, run DBMS_RESOURCE_MANAGER.CALIBRATE_IO:

SET SERVEROUTPUT ON
DECLARE

[Read more...]

Judgment day for open source at Oracle

+3

-0

posted by The 451 Group on Thu 15 Jul 2010 00:25 UTC
Tags:

(edit) mysql, Oracle, Java, software, Linux, OpenOffice, community, Development, opensource, solaris, glassfish, 451 group, 451caostheory, 451group, caostheory, open-source, The 451 Group, the451group, OpenSolaris, cloud computing, JasperSoft, Sun Microsystems, jay lyman, jaylyman, survey, cds, open source at Oracle, OpenSolaris CDs, RDMS

There are signals of continued problems and dysfunction — namely lack of support, organization and communication — in the OpenSolaris community. This follows on a deterioration of the OS leadership and support since Oracle bought Sun Microsystems, including the elimination of OpenSolaris CDs, one of the things that made the open source version of Solaris more like Linux.

We had speculated on the fate of Sun open source software under Oracle and while we acknowledged Oracle’s participation in, contribution and commitment to and opportunity from open source software, we

+4

-0

posted by Dimitri Kravtchuk on Thu 20 May 2010 12:33 UTC
Tags:

(edit) mysql, solaris, Tools/ dbSTRESS

Two weeks ago I was very lucky to meet in Paris Marc Allf (one of developers of MySQL Performance Schema) and get all details about Performance Schema directly from the source :-)

I would say I'm very excited about this feature giving so enormous potential to observe any activity inside of MySQL, as well by a great flexibility of the proposed solution! :-)

However, discussing with Marc and going over a day more and more in depth, I've got some remarks that I needed to group, summarize and then express (and vacation time helping here a lot ;-)) My points will not be about adding some new extensions, but rather fixing some core issues which I consider important (and, please, correct me if you're not agree, express your ideas, etc - it's one of the cases where a

[Read more...]

From Sun OpenSSO comes ForgeRock OpenAM

+2

-0

posted by The 451 Group on Thu 13 May 2010 15:58 UTC
Tags:

(edit) mysql, Oracle, Java, software, Linux, opensource, solaris, 451 group, 451caostheory, 451group, caostheory, open-source, The 451 Group, the451group, acquisition, Sun Microsystems, jay lyman, jaylyman, opensso, Identity Management, simon phipps, forgerock, Hermann Svoren, Lasse Andresen, OpenAM

We’ve long wondered what might happen to all of that open source software from Sun Microsystems now that it’s at Oracle? Obviously, some pieces continue to live at Oracle (Java, Solaris, MySQL), but there are a number of open source projects that Oracle has either neglected to talk about or have been overlooked, particularly as we focused on user reactions, implications and finally approval of Oracle’s acquisition of Sun.

One significant group of open source technologies from Sun is its OpenSSO single

+0

-3

posted by Matt Reid on Tue 27 Apr 2010 01:04 UTC
Tags:

(edit) mysql, Open Source, Linux, database, solaris, unix, OpenSolaris, mysql server, bash, cli, command line, solars

For all of those linux users out there that have moved over to, or tried out, Solaris10 or OpenSolaris because they heard the tales of how MySQL is faster on Solaris… or perhaps you wanted to learn how to use Sol10 for the great features of Zones or the ZFS filesystem? Regardless of why you’re on it you are probably wondering why Linux has colored output of filenames and directories but Solaris does not. The question of ‘why?’ isn’t important, but how to enable colors is. It’s very simple, and here’s how I fixed it. This is a result of digging through multiple semi-related links on Google.

Download all packages from SunFreeware.com

dependency: libintl-3.4.0-sol10-x86-local
dependency: libiconv-1.13.1-sol10-x86-local
dependency: gmp-4.2.1-sol10-x86-local
dependency: gcc-3.4.6-sol10-x86-local or

+0

-0

posted by Matt Reid on Mon 26 Apr 2010 20:24 UTC
Tags:

(edit) mysql, Linux, perl, database, configuration, Python, monitoring, solaris, Backups, mysql server, shell, Scripting, announcement, relational

Just a quick notice to let everyone know that there is a new version of Kontrollkit available. There are some required bug fixes to the formerly new python backup script and some Solaris compatible changes to the various my.cnf files. You can download the new version here: http://kontrollsoft.com/software-downloads, or here: http://code.google.com/p/kontrollkit/

CAOS Theory Podcast 2010.04.16

+0

-1

posted by The 451 Group on Fri 16 Apr 2010 19:10 UTC
Tags:

(edit) mysql, Oracle, Java, Linux, podcast, opensource, cloud, solaris, Red Hat, caostheory, open-source, The 451 Group, the451group, OpenSolaris, JBoss, Hyperic, cloud computing, VMWare, zenoss, investment, springsource, caos theory, venture capital, groundwork, tomcat, amqp, RabbitMQ, OpenNMS Group, rabbit technologies, enterprise messenging, messenging, private cloud, public cloud, VC funding

Topics for this podcast:

*The latest in VC funding for open source
*VMware’s SpringSource buys cloud messenger Rabbit
*Open source monitoring vendors’ key cloud partnershps
*Oracle moves ahead, back on MySQL, OpenSolaris

iTunes or direct download (25:38, 7MB)

Oracle reveals strategy for GlassFish, MySQL, OpenOffice, and Solaris

+1

-0

posted by InfoWorld on Wed 27 Jan 2010 21:40 UTC
Tags:

(edit) mysql, Oracle, Open Source, solaris, OpenOffice.org, Mergers and acquisitions

Earlier today Oracle executives, in an event spanning more than four hours, presented their strategy for integrating Sun's assets with Oracle. I'll just update readers on the section related to Sun's open source assets.

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

Top 20 Most Active Authors

Top 10 Most Active Team Blogs

Oracle MySQL Blogs

MySQL Links

Other Links

Planetarium