Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 1339 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

Hot Off The Press: MySQL February Newsletter
Employee_Team +6 Vote Up -1Vote Down

The MySQL February Newsletter is available! Find out the latest news on MySQL products and MySQL Connect 2014, and read the technical tips written by MySQL experts at Oracle and in the community. Below are the highlights in this edition:

  • Start Preparing for MySQL Connect 2014 Call for Papers
  • New GA Release: MySQL for Visual Studio
  • Blog: State of the UNION
  • Blog: New MySQL Web Installer -- Have You Tried It Yet?
  • Blog: MySQL Workbench: Frequent Crashes on Mac OS X? This Might Be The Fix
  • Event: MySQL Seminars Are Coming to a City Near You

You can read it online or

  [Read more...]
HowTo Video: Exporting your database using MySQL for Visual Studio
Employee +2 Vote Up -0Vote Down
MySQL for Visual Studio 1.1.3 introduced a new feature: MySQL Data Export tool. This tool allows the users to create a dump of an existing MySQL database. This video shows a quick tutorial on how to use this tool for creating MySQL exporting script inside Visual Studio.
Mac Mini to the rescue
+0 Vote Up -0Vote Down

In teaching, I had a problem because my students have different base operating systems, like Windows 7, Windows 8, Linux, and Mac OS X. I needed a teaching and lecture platform that would let me teach it all (not to mention support their environments). That meant it had to virtualize any of the following with a portable device:

  • Windows 7 or 8 hosting natively an Oracle Database 11g XE, 11g, or 12c and MySQL Database 5.6
  • Windows 7 or 8 hosting a Fedora or Oracle Unbreakable Linux VM (3 or 4 GB) with Oracle Database 11g XE, 11g, or 12c and MySQL Database 5.6
  • Mac OS X hosting a Fedora or Oracle Unbreakable Linux VM (3 or 4 GB) with Oracle Database 11g XE,
  [Read more...]
Guide to create a tunneled SSH connection in MySQL for Excel
Employee +1 Vote Up -0Vote Down

This is the second part of two series of blog posts to setup a SSH connection on Windows from scratch. The first part can be found here.
This article describes in step by step fashion a guide on how to create and configure a SSH Tunnel with port forwarding to a remote MySQL server running FreeSSHd on Windows using Putty locally.

MySQL for Excel 1.2.0 has been released
Employee +1 Vote Up -1Vote Down

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

MySQL for Excel is an application plug-in enabling data analysts to very easily access and manipulate MySQL data within Microsoft Excel. It 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

MySQL for Excel is installed using the MySQL Installer for Windows. You can download MySQL Installer from our official Downloads page at http://dev.mysql.com/downloads/installer/.

Replicate from Oracle to Oracle, Oracle to MySQL, and Oracle to Analytics
+0 Vote Up -0Vote Down
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-on-demand 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 and Expo 2014: Things I’m looking forward to
+2 Vote Up -0Vote Down

The Percona Live MySQL Conference and Expo 2014 is just two months away. I’m very excited about this year’s event which continues our tradition of open technical discussions and inviting all parties to the table.

We have a great amount of technical talks from Oracle – I’m especially excited about future-focused talks shedding some light about what to expect in MySQL 5.7 and beyond. This content is best covered by developers actually designing the system and writing the code. We also have great coverage of MySQL

  [Read more...]
MariaDB CONNECT Storage Engine as an ETL (or ELT) ?
+5 Vote Up -1Vote Down

The MariaDB CONNECT Storage Engine allows to access heterogeneous data sources. In my previous post I show you how to use the MariaDB CONNECT Storage Engine to access an Oracle database. This is quite easy through the CONNECT Storage Engine ODBC table type.

For most architectures where heterogeneous databases are involved an ETL (Extract-Transform-Load) is [...]

Guide to install and configure SSH in a MySQL server on Windows
Employee +3 Vote Up -0Vote Down

This article describes in step by step fashion a guide on how to install and configure a SSH server in a MySQL server running on Windows using FreeSSHd. 

MySQL is a Great Fit for Cloud-Based Deployments
Employee_Team +1 Vote Up -0Vote Down

MySQL's architecture and features make the database a great fit for cloud based deployments. If you are interested in using MySQL to deliver web-based applications and scale out, read the white paper MySQL, An Ideal Choice in the Cloud (http://www.mysql.com/why-mysql/white-papers/mysql-an-ideal-choice-for-the-cloud/).

As a first step to using the MySQL database, take the MySQL for Beginners course. In this 4-day course, you learn to use the MySQL Server and tools while developing a knowledge of relational databases. You can take this course through the following delivery methods:

  • Training-on-Demand: Start training within 24 hours of registering and train at your own pace.
  • Live-Virtual Event:
  [Read more...]
MySQL for Visual Studio 1.1.3 GA has been released
Employee +2 Vote Up -0Vote Down
MySQL for Visual Studio is a new product including all of the Visual Studio integration previously available as part of Connector/Net.  The 1.1.3 version is now released as GA and is appropriate for use in production environments.  It is compatible with MySQL Server versions 5.0-5.7 and Visual Studio versions 2008 to 2013.
MySQL for Excel 1.2.0 Auto refresh new features
Employee +0 Vote Up -1Vote Down

This post is about one of the new features included in the latest MySQL for Excel release to date (1.2.0) which can be Installed directly from our MySQL Installer.

Since the first release you were allowed to Import and Append data from Excel to a MySQL database, and also to import data from the MySQL database to an Excel Worksheet.
All these windows handle small previews of the data you were working with, and some settings about how the data should be treated can be found by clicking the Advanced Options button on them.

The problem many users found was that sometimes when they changed these options, the small previews did not reflected the changes being made on them, and they had to close and reopen the windows to see if their changes were what they actually wanted or how the data was being treated with




  [Read more...]
MySQL Support is Hiring!
Employee +3 Vote Up -0Vote Down

My old team here at Oracle looking for talented, experienced MySQL experts to join the amazing MySQL Support Team.  I was lucky enough to join this great group of people over seven years ago, and while my responsibilities have shifted to other areas with the MySQL team at Oracle, I still join the team’s chat channel daily (where they’ve revoked my vowel and address me as “t*dd” to highlight my treachery in leaving the team).   I don’t know that it’s possible to find a better group of colleagues to work with than can be found in the MySQL Support Team.

The work itself is exciting – if you like solving problems, this is an incredible job.  I’m not talking about finding and quoting applicable sections of the MySQL reference manual.  I’m talking about owning customer problems like they are your own, taking the time to

  [Read more...]
New MySQL web installer, Have you tried it yet?
Employee +0 Vote Up -0Vote Down

We recognize that the most important part to get you started is getting the products you want installed and well configured. That's why the installer team has been working really hard to enhance the user experience with MySQL products. We are proud to announce a newer, lighter version of the MySQL Installer is available for download at our website.

Have you tried the new MySQL Web Installer yet? Do it now!

It weights barely more than 1.5 MB in total but packs the ability to let you select any product from the MySQL family. The web installer will  handle the process of downloading, and installing what you need and will help you with configuration too.

Tungsten Replicator 2.2 Is Now Available
+0 Vote Up -0Vote Down
New Continuent Tungsten Replicator 2.2 is now available for download at www.continuent.com/software and http://code.google.com/p/tungsten-replicator/downloads/list.Tungsten Replicator is a high performance, open source, data replication engine for MySQL and Oracle, released under a GPL V2 license. Tungsten Replicator has all the features you expect from enterprise-class data replication products
It can be a bright 2014
+1 Vote Up -0Vote Down

In many parts of the MySQL world, whether you have users, developers or administrators of MySQL, the season holidays are for family, relax, prayers, travel, or they are simply a moment where you can enjoy what you like or care most about.

For me, this time is dedicated to my family, but also to deeper thoughts around the strategies to adopt in short and long term. My work nowadays, as the work of many others, is ruled by quick decisions, by the "time to market” - whatever “market" means in a specific context. Decisions must be made in meetings that are time-boxed in one hour or even less. In the end, you accumulate so much work and high priority tasks that you do not have enough time to prepare the topics adequately.

I thought I could summarise my thoughts for the past year and for the near future, from a technical and from a business perspective.






  [Read more...]
Excel PowerPivot & DAX
+0 Vote Up -0Vote Down

I’ve worked with every release of Microsoft Excel, and I know it takes effort to keep up to date with certain releases. Clearly, the Data Analysis eXpression (DAX) Language introduced in Excel 2010 went unnoticed by many, which was sad. DAX is truly a powerful extension to the analytical and modeling approaches in Microsoft Excel.

I’d like to recommend Microsoft Excel 2013 Building Data

  [Read more...]
MongoDB in 2013 -- A Year in Review
+0 Vote Up -1Vote Down
It's again that time of the year. Analysts are spending oceans of words to predict the future, companies are making plans for the next year and people are resting and enjoying the break with their families. To me, this is the perfect time to reflect on my choices, the direction I'm headed to and consider if I still love what I do.

At the beginning of the year I decided to join MongoDB (formerly 10gen). The more I think about it, the more I realize I've been wrong. Yes, it's been the worst decision in my life not to join MongoDB when I was first offered the opportunity years ago. At that time an

  [Read more...]
MongoDB in 2013 -- A Year in Review
+0 Vote Up -1Vote Down
It's again that time of the year. Analysts are spending oceans of words to predict the future, companies are making plans for the next year and people are resting and enjoying the break with their families. To me, this is the perfect time to reflect on my choices, the direction I'm headed to and consider if I still love what I do.

At the beginning of the year I decided to join MongoDB (formerly 10gen). The more I think about it, the more I realize I've been wrong. Yes, it's been the worst decision in my life not to join MongoDB when I was first offered the opportunity years ago. At that time an

  [Read more...]
Are SQL Databases Dead?
+1 Vote Up -0Vote Down
I like the image of this city of Mesa Verde. It’s fascinating to see how ancient cities were built, especially as an inhabitant of one of the worlds largest cities today, New York. I’m a long time relational database guy. I worked at scores of dot-coms in the 90′s as an old-guard Oracle DBA, and […]
MySQL Connector/Net 6.8.3 GA has been released
Employee +0 Vote Up -0Vote Down

Dear MySQL users,

MySQL Connector/Net 6.8.3, a new version of the all-managed .NET driver for MySQL has been released. This is a GA release for 6.8.x and can be used for production environments.

It is appropriate for use with MySQL server versions 5.0-5.6

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

The 6.8.3 version of MySQL Connector/Net has support for Entity Framework 6.0

The release is available to download at

  [Read more...]
MySQL Connector/Python v1.1.4 GA
Employee +0 Vote Up -0Vote Down

It has been a busy week for the Pythonic MySQL Team at Oracle: MySQL Utilities 1.3.6 and a brand new Utilities 1.4.1 Alpha has been release which includes Fabric. Yes, and of course, the one binding them all: Connector/Python v1.1.4 has been released as GA (General Available). Check out the Change History if you want to keep up with what is being added and changed.

New features found in v1.1:

  • Important: Connector/Python will not work with Python v2.4 or v2.5. Yes, I consider this a
  [Read more...]
MySQL Notifier 1.1.5 has been released
Employee +1 Vote Up -0Vote Down

The MySQL Windows Experience Team is proud to announce the release of MySQL Notifier version 1.1.5, the  latest addition to the MySQL Installer for Windows.

MySQL Notifier 1.1.5 introduces the following features:

 

  • The MySQL Utilities can now be opened from MySQL Notifier if installed separately from MySQL Workbench (it is no longer bundled with MySQL Workbench 6.x).
  • Added Workbench connections edition capability right from the Monitor MySQL Server Instance window of the MySQL Notifier (accessed through Actions > Manage Monitored Items… > Add… > MySQL Instance). Any of the listed MySQL Workbench connections can be right-clicked and a new “Edit Connection” context menu is available for users to edit the Workbench connection properties.
  • Changed the way the Workbench connections
  [Read more...]
MySQL Connector/Net 6.8.2 RC has been released
Employee +0 Vote Up -0Vote Down

Dear MySQL users,

MySQL Connector/Net 6.8.2, a new version of the all-managed .NET driver for MySQL has been released. This is a RC release for 6.8.x and it's not recommended for production environments.

It is appropriate for use with MySQL server versions 5.0-5.6

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

The 6.8.2 version of MySQL Connector/Net has support for Entity Framework 6.0

The release is available to download at

  [Read more...]
A sneak peek at the Percona Live MySQL Conference & Expo 2014
+2 Vote Up -0Vote Down

Percona founder and CEO Peter Zaitsev delivers the opening keynote at Percona Live 2013 in Santa Clara, Calif.

MySQL gurus from Oracle, Facebook, Google, LinkedIn, Twitter, Yelp (and more) have submitted papers and will speak at the third annual Percona Live MySQL Conference and Expo 2014 in sunny Santa Clara, California this coming April 1-4.

If you attended last April’s Percona Live MySQL Conference and Expo – and/or last month’s Percona Live London 2013 conference – then you understand the value of learning from some of the world’s best and brightest system

  [Read more...]
MariaDB CONNECT Storage Engine access to Oracle 11GR2
+1 Vote Up -0Vote Down

MariaDB CONNECT Storage Engine allows to access heterogeneous datasourses. This includes various file formats. But this also includes ODBC accessible datasources The CONNECT Storage Engine ODBC table type allows to access SQLite, Excel, SQL Server or Oracle databases. Some nice features of the ODBC CONNECT table type are: - Auto discovery of table structure. This [...]

5 great things about Markus Winand’s book SQL Performance Explained
+0 Vote Up -0Vote Down
Join 12,100 others and follow Sean Hull on twitter @hullsean. 1. Covers databases broadly You may not have noticed, but there’s a whole spectrum of relational databases on offer. Of course in the database world, most get infatuated with one, and that becomes their bread & butter before long. Their life, their passion, their devotion. […]
Log Buffer #348, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

With the holiday season fast approaching (or is it slow?), data bloggers have already adopted a festive mood, and this Log Buffer edition jubilantly captures and reflects that, and much more.

Oracle:

On December 4, 2013, Oracle will host a customer webcast to acquaint customers with the Oracle SuperCluster M6-32, Oracle’s most powerful engineered system for in-memory Oracle Database performance, Database-as-a-Service and application consolidation.

The ETL logic in BI Apps uses parameters in packages, interfaces, load plans, and knowledge modules (KM) to control the ETL behaviors.

  [Read more...]
how MySQL engineering broke the backups
+0 Vote Up -0Vote Down

MySQL has exceptional track of record by introducing minor fixes that cause major breakages. Though usually I could blame naiveté of engineers, who did not really ever have to deal with production implications, but lately I can start sensing various business implications against open-source offerings.

As an original author of mydumper I really cannot get out of my mind that 5.5 and 5.6 metadata locking changes are there to screw with anyone who is building a backup solution using stable snapshot views of MySQL (for example, mysqldump –single-transaction, the golden standard of backing things up in MySQL world).

As seen in a bug #71017 (palindrome!) filed by my esteemed colleague Eric, newly

  [Read more...]
MEB integration with Workbench
Employee_Team +0 Vote Up -0Vote Down
This blog talks about MySQL Enterprise Backup integration with Workbench and how the Workbench UI can be used to configure and operate MEB.
Previous 30 Newer Entries Showing entries 31 to 60 of 1339 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.