Planet MySQL

Log Buffer #320, A Carnival of the Vanities for DBAs

+0

-1

posted by Marco tusa (Pythian) on Fri 17 May 2013 12:23 UTC
Tags:

(edit) mysql, Oracle, Log Buffer, SQL Server

The red carpet has been laid down at this Log Buffer Edition, and you can witness and cheer the cat-walking blog posts from Oracle, SQL Server and MySQL. Every one of them is chic, elegant, sensual in its own right. Enjoy.
Oracle:

Create colored heat maps in SQL*Plus with Kyle Hailey.

Here’s a quick and dirty script to create a procedure (in the SYS schema – so be careful) to check the Hakan Factor for an object.

Connor has a good post about default null for collection parameter.

This is yet another blogpost on

+0

-0

posted by Oracle MySQL Group on Mon 13 May 2013 07:15 UTC
Tags:

(edit) mysql, Oracle, Training, university, mysql training

The MySQL for Beginners course is your first step to getting started on the MySQL Database.

This four-day, live, instructor-led course is your chance to learn about this powerful relational database management system - MySQL is the most popular open source database in the world.

You can take this course as a:

Training-on-Demand: Follow this class at your own pace through streaming delivery of lecture material and booking time to perform exercises.
Live-virtual event: Participate in this class from your own desk - no travel required. Choose from a selection of events on the schedule to suit different time zones.
In-class event: Travel to

+1

-0

posted by Marco tusa (Pythian) on Fri 10 May 2013 12:52 UTC
Tags:

(edit) mysql, Oracle, Log Buffer, SQL Server

This week again, the Log Buffer Edition covers the exciting and ever-evolving galaxies of Oracle, MySQL and SQL Server.

Oracle:

When does an Oracle process know it’s on Exadata?

MobaXterm 6.3 has been released. You can find the download and changelog in the usual place.

A new major release (version 3.0) of Randolf’s XPLAN_ASH tool is available for download.

Important !! Clustering Factor Calculation Improvement

[Read more...]

MySQL is Better Than Ever for the Web

+1

-0

posted by Oracle MySQL Group on Mon 06 May 2013 07:33 UTC
Tags:

(edit) mysql, PHP, Oracle, Training, university, mysql training

Whether you are a developer who wants to use MySQL and PHP to build and maintain websites or if you want to learn how MySQL and PHP can be used for the rapid prototyping and development of dynamic websites, the MySQL and PHP - Developing Dynamic Web Applications training course is for you.

This four day, live, instructor-led course is available as a:

Live-virtual event: You can take this course from your desk - no travel required. Choose from a selection of events already on the schedule.
In-class event: Travel to an education center to take this course. Below is a selection of of the events already on the schedule.

+0

-0

posted by Marco tusa (Pythian) on Fri 03 May 2013 11:50 UTC
Tags:

(edit) mysql, Oracle, Log Buffer, SQL Server

News and views are an integral part of our modern daily life. When it comes to the information-hungry roles such as database professionals, such need becomes more pressing. Log Buffer is one way to keep abreast of news and views from the world of Oracle, SQL Server, and MySQL.

Oracle:

There is a significant update SLOB 2, Kevin Closson informs.

Charles Hooper is grouping Data Sets by Week Number of the Month.

Chris Antognini has shared a script that is used to demo ITL deadlocks.

As

[Read more...]

MEB : The journey so far 2010-2013

+4

-0

posted by Hema Sridharan on Fri 03 May 2013 11:32 UTC
Tags:

(edit) mysql, Oracle, enterprise, Backup, database, mysql;, administration;, backup;, dba;, enterprise;, meb;

MySQL Enterprise Backup (MEB) was born 3 years ago as a newly branded avatar of InnoDB Hot backup. Wanted to share what has gone on so far, how we at Oracle think about backup, the milestones that we have achieved and the road ahead. The idea for this blog came to me after looking at Mikael's latest blog. While Mikael talks about MySQL, I want to talk about MEB.

When we started with InnoDB Hot backup the first challenge was to have it adhere to the development, quality and release processes for MySQL. This meant creating a quality plan, getting it into the development trees of MySQL and ensuring that each piece of new code went through architecture and code review. Though the initial implementer and architect of Hot backup continues to work with the MEB team, there

[Read more...]

5 years of MySQL

+2

-1

posted by Henrik Ingo on Wed 01 May 2013 10:03 UTC
Tags:

(edit) mysql, Oracle, Open Source, community, Percona, mariadb, mongodb, skysql

5 years of MySQL

People often write a blog post when they reach some nice anniversary since they joined MySQL community. Well, for those old enough it usually means when they joined MySQL AB as employee. For me this was January 2008. Because I didn't remember the month correctly, I haven't blogged anything then, but decided to save it for a better opportunity - now.

TL;DR Starting this week I will be working for 10gen, selling MongoDB to the Nordics. This blog post is really long - even then it doesn't contain the most interesting stories, I'm not sure if they can ever be published. Sorry for the length, but remember you don't need to read all at once. This is my last MySQL post so save some of it for cold winter days!

2008 - Sun acquisition

Oracle at Percona Live!

Yes, Oracle was at Percona Live 2013 and it was for the best.
I invite you to watch this

+0

-0

posted by Reggie Burnett on Tue 30 Apr 2013 19:12 UTC
Tags:

(edit) mysql, Oracle, Windows, c#, memcached, .NET, migrations, framework, spatial, ado.net, Load-balancing, connector-net, entity, ef5, store-apps, windows-runtime, winrt

MySQL Connector/Net 6.7.2, a new version of the all-managed .NET driver for MySQL has been released. This is the first beta release intended to introduce users to the new features in the release. This release is feature complete, it should be stable enough for users to understand the new features and how we expect them to work. As is the case with all non-GA releases, it should not be used in any production environment. It is appropriate for use with MySQL server versions 5.0-5.7.

Tungsten University: Replicate Between MySQL And Oracle

+0

-0

posted by Petri Virsunen of team blog Continuent Team Blog on Mon 29 Apr 2013 18:38 UTC
Tags:

(edit) mysql, Oracle, Replication, Continuent Tungsten, Tungsten replicator, database replication, Tungsten University

Oracle is the most powerful DBMS in the world. However, Oracle's expensive and complex replication makes it difficult to build highly available applications or move data in real-time to data warehouses and popular databases like MySQL. In this webinar you will learn how Continuent Tungsten solves problems with Oracle replication at a fraction of the cost of other solutions and with less

Percona Live MySQL Conference 2013 wrap-up

+2

-0

posted by MySQL Performance Blog on Mon 29 Apr 2013 10:00 UTC
Tags:

(edit) mysql, Oracle, Brian Aker, matt aslett, Peter Zaitsev, continuent, Robert Hodges, Amazon Web Services, Tomas Ulin, percona live, Events and Announcements, 451 Research, HP Cloud Services, Percona Live MySQL Conference & Expo 2013, Simone Brunozzi

The Percona Live MySQL Conference & Expo 2013 was April 22-25 in Santa Clara, California. This was Percona’s second year organizing the conference and we were very pleased with the event and the feedback (check the #perconalive hashtag for a sampling of the great comments such as this from Tom Krouper or this from John Goulah or this from Jeremy Tinley or this from SF MySQL Meetup).

+2

-0

posted by Luca Olivari on Mon 29 Apr 2013 05:50 UTC
Tags:

(edit) mysql, Technology, Oracle, Databases, opensource, cloud, mobile, omidniteo, 10gen, big data, NoSQL, mongodb, luca olivari

Those who are familiar with me know I've a dream.

5 years ago I decided to leave a systems integrator where I was doing great. Why? I wanted to be in a company with the same growth prospects that Oracle had in the 80s. I dreamed to be in the Oracle of 30 years ago and, as time travel wasn't affordable, I decided to join MySQL AB to help expand the business in Europe, the Middle East and Africa.
A few years later my dream came true, but in a slightly different sense. Sun acquired MySQL and was later swallowed by

[Read more...]

MySQL for Excel 1.1.1 GA has been released

+1

-0

posted by Reggie Burnett on Fri 26 Apr 2013 21:05 UTC
Tags:

(edit) mysql, Oracle, Excel, Office

The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.1.1 GA, the latest addition to the MySQL Installer for Windows.

MySQL for Excel enables you to directly work with a MySQL database from within Microsoft Excel so you can easily do tasks such as:

Importing MySQL Data into Excel
Exporting Excel data directly into MySQL to a new or existing table
Editing MySQL data directly within Excel

Version 1.1.1 is a maintenance release containing a handful of bug fixes.

You can download it from our official Downloads page at http://dev.mysql.com/downloads/installer/.

Log Buffer #317, A Carnival of the Vanities for DBAs

+1

-0

posted by Marco tusa (Pythian) on Fri 26 Apr 2013 12:06 UTC
Tags:

(edit) mysql, Oracle, Log Buffer, SQL Server

Reminders are an inevitable part of our personal and professional lives. Keep reminding of oneself about goals, priorities, and milestones is key to stay on top of things. This Log Buffer Edition is a reminder about all those not-to-be-missed blogs out there.

Oracle:

One of the developers was performing a delete using a nested subquery, which was throwing out ORA-00600 errors. The ORA-00600 Lookup Tool on MOS suggested it was caused by a bug, Tim Hall reports.

The healthcare sector has a clear opportunity to modernize care delivery by adopting new data interchange standards and EHR systems. Kyle opines.

[Read more...]

Driving MySQL Innovation

+7

-1

posted by Oracle MySQL Group on Thu 25 Apr 2013 13:04 UTC
Tags:

(edit) mysql, Oracle

Oracle's VP of MySQL Engineering Tomas Ulin delivered on Tuesday a keynote entitled "Driving MySQL Innovation for Next Generation Applications" at the Percona Live Conference.

If you haven't seen it yet, we highly encourage you to watch it.

Tomas covers:

Oracle's Investment in MySQL
MySQL 5.6
Trends and Product Directions

He makes it very clear that Oracle:

Invests in MySQL like Never Before
Drives MySQL Innovation
Makes MySQL Better for Next Generation Web, Cloud and Big Data

+1

-2

posted by Colin Charles on Wed 24 Apr 2013 12:42 UTC
Tags:

(edit) mysql, Oracle, hadoop, mariadb, monty program, skysql, MySQL Cluster 7.3, MySQL 5.7

Continuing on from yesterday, the biggest news that I’ve noted in the past 24 hours:

The commitment from Oracle’s MySQL team to release a new GA about once every 24 months, with a Developer Milestone Release (DMR), with “GA quality” every 4-6 months. Tomas Ulin announced MySQL 5.7 DMR1 (milestone 11) [download, release notes, manual]. He also announced MySQL Cluster 7.3 DMR2 [download,

+0

-0

posted by The Pythian Group on Fri 19 Apr 2013 12:36 UTC
Tags:

(edit) mysql, Oracle, Log Buffer, SQL Server

Just as information has become an integral part of technology, blogging has become an inseparable part of technology too. Database technologies are no exception and blogging in that arena is booming. This Log Buffer Edition is booming with some bombastic blog posts.

Oracle:

Arup Nanda asks. Application Design is the only Reason for Deadlocks? Think Again.

It’s time that businesses took a good, hard look at the way they manage their cloned database environments, Kyle Opines.

Randolf touches the interesting topic of ASM AU Size And LMT

+0

-0

posted by Reggie Burnett on Wed 17 Apr 2013 15:01 UTC
Tags:

(edit) Oracle, data, spatial, connector-net

Spatial data is being more used and needed at a larger number of applications. This type of data is not always easy to be managed or queried. And sometimes calculations need to be done in the application code instead of doing them at the server. Recently we added a new class to manage spatial data with Connector/Net, so our users can have the option to handle spatial data operations at their application code.

The state of the MySQL ecosystem

+1

-2

posted by Matt Aslett on Mon 15 Apr 2013 16:03 UTC
Tags:

(edit) mysql, Oracle, Percona, Data Management, mariadb, MariaDB Foundation

I’ll be on a whistle-stop tour of California next week, including two presentations at the Percona Live MySQL Conference and Expo.

On day one at 1:20pm I’ll be presenting CAP Theorem: Two out of three ain’t right, in which I will be challenging the popular ‘two out of three’ explanation of CAP Theorem, examining the evidence from a variety of experts, including Dr Eric Brewer.

Then on day three at 9:00am I’m very honoured to be providing a keynote presentation, The State of the MySQL Ecosystem.

Here’s an overview of the presentation:

It

+1

-0

posted by MySQL Performance Blog on Mon 15 Apr 2013 13:00 UTC
Tags:

(edit) mysql, Oracle, cloud computing, HP, continuent, Amazon Web Services, percona live, Events and Announcements, Insight for DBAs, Insight for Developers, Percona Software, Percona Toolkit, XtraDB Cluster, Percona XtraDB Cluster, Percona Server 5.6

The Percona Live MySQL Conference and Expo begins next Monday and runs April 22-25, 2013. Attendees will see great keynotes from leaders in the industry including representatives from Oracle, Amazon Web Services, HP, Continuent, and Percona. They can also participate in thought provoking Birds of a Feather sessions on Tuesday night and the Wednesday night Community Networking Reception will be fun and entertaining with the presentation of the Community Awards and the Lightning Talks.

If you

+1

-0

posted by Oracle MySQL Group on Sun 14 Apr 2013 21:44 UTC
Tags:

(edit) mysql, Oracle, performance, Training, mysql training, pt

MySQL, the most popular open source database brings you great performance. You can see the performance details in http://dimitrik.free.fr/blog/. To help you get the most from MySQL's performance, take the MySQL for Performance Tuning course.

This four day instructor-led training course covers:

Performance Tuning Basic
Performance Tuning Tools
MySQL Server Tuning
MySQL Query Cache
Storage Engines
Schema Design and Performance
Performance Tuning Extras

This course is available in three delivery types:

+0

-0

posted by Reggie Burnett on Fri 12 Apr 2013 18:42 UTC
Tags:

(edit) mysql, Oracle, Windows, c#, memcached, .NET, migrations, framework, spatial, ado.net, Load-balancing, connector-net, entity, ef5

MySQL Connector/Net 6.7.1, a new version of the all-managed .NET driver for MySQL has been released. This is the second of two alpha releases intended to introduce users to the new features in the release. This release is not feature complete and there are significant limitations but it should be stable enough for users to understand the new features and how we expect them to work. As is the case with all non-GA releases, it should not be used in any production environment. It is appropriate for use with MySQL server versions 5.0-5.6

Log Buffer #315, A Carnival of the Vanities for DBAs

+0

-0

posted by The Pythian Group on Fri 12 Apr 2013 12:51 UTC
Tags:

(edit) mysql, Oracle, Log Buffer, SQL Server

Like in love there is no precondition, there are no limits held when it comes to the labor of love called as blogging. Lovingly this Log Buffer edition brings you some more roses from database arena.

Oracle:

Marco Vigelini shares as how to duplicate a production database on a different server mantaining the same SID and directory structures with ‘duplicate’ RMAN command and how to resynchronize a duplicated remote database using RMAN backups.

+2

-0

posted by Oracle MySQL Group on Sun 07 Apr 2013 23:46 UTC
Tags:

(edit) mysql, PHP, Oracle, Java, Training, Developer, mysql training

Get the most out of your MySQL environment by learning to develop your new applications cost-effectively using MySQL with different languages such as Java and PHP.

The MySQL for Developers course is a 5 day, live, instructor-led course where you learn to:

Use MySQL tools to connect to databases.
Examine database structure and contents.
Generate database structure diagrams.
Execute complex queries and stored routines.
Manipulate numeric, text, spatial and temporal data.
Execute complex subqueries and joins.

You can take this course as a:

Live-Virtual Event: Take this course from your own desk - no travel required. Choose from one of the many events

+0

-0

posted by The Pythian Group on Fri 05 Apr 2013 12:26 UTC
Tags:

(edit) mysql, Oracle, Log Buffer, SQL Server

It is an industry norm, supported by analyst researches that blogs are the best informal medium to share the information. This unique medium provides readers with increased leverage in negotiating the hard turns in their technological lives. Log Buffer makes that leverage more powerful.

Oracle:

Alan Gardner is deploying Cloudera Impala on EC2 with Example Live Demo.

If you want to follow the real news and insight into the online learning revolution, then e-Literate has always been the blog to follow.

Tuula Fai wants to do things, and when he cannot he reverts to a little help.

+1

-0

posted by Oracle MySQL Group on Tue 02 Apr 2013 12:09 UTC
Tags:

(edit) mysql, Oracle, database, Training, DBA, administrator, mysql training

MySQL for Database Administrators is the foundation of the authentic MySQL Curriculum. By taking this live 5-day instructor-led course, you find out how MySQL enhancements increase performance, scalability, reliability and manageability of your Web, Cloud and embedded application requirements.

You will learn to:

Setup the server and databases
Maintain and secure data
Configure for performance and high availability
Explore real-world problems and discover best practices

You can take this course as a:

Live Virtual Event:

+1

-0

posted by Hema Sridharan on Thu 28 Mar 2013 14:15 UTC
Tags:

(edit) mysql, Oracle, community, group, bangalore, user, 5.6, forum

We had a great kickoff to the Bangalore MySQL User camp on 22 March 2013 at the Oracle Kalyani Magnum Office.

There were 17 attendees from the MySQL community besides more than 15 MySQL engineers who attended the meet. Of these 3 community members were from groups inside Oracle. There was a mix of new and veteran MySQL users. The MySQL India teams gave a brief introduction about themselves, followed by a quick overdrew of MySQL and how it is different from other databases. The presentation about 5.6 features was presented last and the one that was most liked. There was a great networking over juice and Donuts after the meeting. There were lots of questions by the community on technical details of 5.6 features. Everyone interacted and there was help offered for ensuring that the next meeting on 19th June 2013 is an even greater success.

Thanks

+0

-0

posted by The Pythian Group on Thu 28 Mar 2013 12:33 UTC
Tags:

(edit) mysql, Oracle, Log Buffer, SQL Server

The answers to the questions like whether to patch now or wait a little? What quirks are there in that stunning new features? What are the limitations of that fancy index type, any working examples of a particular add-on, are best found in the blogs. This Log Buffer Edition provides you a window to those blogs out there.

Oracle:

Scott Wesley is dishing out the reasons you should upgrade your APEX environment.

In case you haven’t already noticed, PeopleTools 9.2 is out and available for download!

Since two thirds of sensitive data in most organizations resides in databases, consolidation onto private clouds represent an opportunity to improve

+1

-0

posted by Oracle MySQL Group on Wed 27 Mar 2013 08:53 UTC
Tags:

(edit) mysql, Oracle, Training, mysql training

The MySQL for Beginners course is your first step towards mastering the MySQL database. This 4-day class gives you a solid understanding and practical experience of using relational databases, SQL and the MySQL Server and tools.

You can take this instructor-led class as following:

Training-on-Demand: Start training within 24 hours of registration and follow the class at your own pace through streaming video and booking time to do lab exercises at your convenience.
Live-Virtual Class: Attend a live event from your own desk - no travel required. Choose from the many events already on the schedule, suiting different timezones. Delivery is currently scheduled in English and German.
In-Class: Travel to an education center.

+1

-0

posted by Reggie Burnett on Sun 24 Mar 2013 01:18 UTC
Tags:

(edit) mysql, Oracle, Windows, c#, .NET, framework, ado.net, connector-net, entity, intellisense, ef, ef43, visual-studio-integration

MySQL Connector/Net 6.5.6, a new maintenance release of our 6.5 series, has been released. This release is GA quality and is appropriate for use in production environments. Please note that 6.6 is our latest driver series and is the recommended product for development. It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloads and mirror sites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)

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

5 years of MySQL

2008 - Sun acquisition

Oracle at Percona Live!