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 61 to 90 of 1379 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

MySQL Enterprise Backup 3.10.0-What's New
Employee +0 Vote Up -0Vote Down

MySQL Enterprise Backup team is proud to announce the new release of MySQL Enterprise Backup (MEB) 3.10.0.

Security of backups and usability of backup tools form an important factor in taking successful backups. DBAs prefer to have tools that would help them in backup and restore without much overhead and also to help keep their backups protected. So in this release of MEB we have enhanced usability and added provision to take secured backups. In addition to this we have also provided enhancements to compressed backup.

Product New Features

MEB 3.10.0 is a major release with the following valuable features.

Feature

Benefit

  [Read more...]
MySQL Enterprise Backup 3.10.0 – What’s New
Employee_Team +0 Vote Up -0Vote Down

MySQL Enterprise Backup team is proud to announce the new release of MySQL Enterprise Backup (MEB) 3.10.0.

Security of backups and usability of backup tools form an important factor in taking successful backups. DBAs prefer to have tools that would help them in backup and restore without much overhead and also to help keep their backups protected. So in this release of MEB we have enhanced usability and added provision to take secured backups. In addition to this we have also provided enhancements to compressed backup.

Product New Features

MEB 3.10.0 is a major release with the following valuable features.

Feature

Benefit

Improved Compressed Backup

  [Read more...]
How To - Guide to exporting data from Excel to a new MySQL table
Employee +0 Vote Up -0Vote Down

There may be times when you need to create a new table in MySQL and feed it with data from another database, the Internet or from combined data sources. MS Excel is commonly used as the bridge between those data sources and a target MySQL database because of the simplicity it offers to organize the information to then just dump it into a new MySQL table. Although the last bit sounds trivial, it may actually be a cumbersome step, creating ODBC connections within Excel through Microsoft Query may not help since these are normally created to extract data from MySQL into Excel, not the opposite. What if you could do this in a few clicks from within Excel after making your data ready for export to a MySQL database?

With MySQL for Excel you can do this and this guide will teach you how easy it is.

MySQL for Excel Main Features Video
Employee +2 Vote Up -0Vote Down

We are proud to announce our first MySQL for Excel video is now available at the MySQL youtube channel.

Please give it an eye and get to know about the main features of MySQL for Excel (Import, Export, Append and Edit).

To view the video on youtube click over the image shown in below:


We always look forward to hear what new features you will like to see on future versions of MySQL for Excel so we encourage you to please visit our forum and let us know. Also, follow us at:

  • Facebook -

  [Read more...]
Connector/NET 6.8.3 is available as official MySQL Nuget packages
Employee +2 Vote Up -0Vote Down

Dear MySQL users,

We are proud to announce that we have made the open source version of our Connector/NET 6.8.3 is available as official MySQL Nuget packages.

Currently we have 3 nuget packages which contain:

  • MySQL Connector/NET Core
  • MySQL Connector/NET for Entity Framework 6
  • MySQL Connector/NET Web providers

Oracle’s Mats Kindahl to weave MySQL Fabric into Percona Live session
+2 Vote Up -0Vote Down

Mats Kindahl of Oracle is lead developer of MySQL Fabric

MySQL Fabric is an integrated framework for managing farms of MySQL servers with support for both high-availability and sharding. Its development has been spearheaded by Mats Kindahl, senior principal software developer in MySQL at Oracle.

Mats is leading the MySQL Scaling and High-Availability effort covering the newly released MySQL Fabric and the MySQL Applier for Hadoop. He is also the architect and implementer of several features (mostly replication features), including the row-based replication available in 5.1 and the binary log group commit available in MySQL 5.6. Before starting MySQL he earned a doctoral degree in the area of automated

  [Read more...]
Add User Defined Types
+0 Vote Up -0Vote Down

Somebody asked me if there was a cheaper alternative to using the Embarcadero Data Architect (a data modeling tool). I said sure, you can use the MySQL Workbench. My friend laughed and said, it’s to model Oracle databases and they use different data types. I broke the news to him that he can create his own user defined types and use MySQL Workbench to model problems for the Oracle Database 11g.

For example, you can launch the MySQL Workbench, and click on the Model menu option, and in the menu window click on the User Defined Types choice, as shown in the following:

Choosing the User Defined Type option, launches the following

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

This week we released MySQL (http://www.mysql.com" target="_blank) Connector/Python v1.1.6 has been released with a fix for the Django backend. If you  wonder (or not?) where Connector/Python v1.1.5, it got released a few weeks ago. Yes, PyPi has been updated! Don’t forget to use –allow-external using newest pip.

Some useful links:

  [Read more...]
Oracle’s Morgan Tocker opens up about MySQL development, MySQL 5.7
+4 Vote Up -0Vote Down

Today’s post features an interview with Morgan Tocker, MySQL community manager at Oracle. Morgan is an old friend of Percona, having worked here as director of MySQL training from 2009 to 2011. He’s also done stints at MySQL, Sun Microsystems and InPowered. You can follow his adventures at his blog, “Master MySQL.”  You can also connect with him face-to-face at the Percona Live MySQL Conference and Expo this April 1-4 in Santa Clara, Calif.  Use the promotional code “SeeMeSpeak” on the

  [Read more...]
Why Aren't All Data Immutable?
+0 Vote Up -0Vote Down
Over the last few years there has been an increasing interest in immutable data management. This is a big change from the traditional update-in-place approach many database systems use today, where new values delete old values, which are then lost. With immutable data you record everything, generally using methods that append data from successive transactions rather than replacing them.  In some DBMS types you can access the older values, while in others the system transparently uses the old values to solve useful problems like implementing eventual consistency.

Baron Schwartz recently pointed out that it can be hard to get decent transaction processing performance based on append-only methods like append-only B-trees.  This is not a very strong argument

  [Read more...]
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 new features (1.2.0): Auto refresh Import Data, Export Data and Append Data dialogs
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 […]
Previous 30 Newer Entries Showing entries 61 to 90 of 1379 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.