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 中文
Showing entries 1 to 30 of 1342 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

MySQL for Visual Studio 1.2.0 alpha has been released
Employee +0 Vote Up -0Vote Down
MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. The 1.2.0 version is an alpha release of this product that intents to introduce users to the new features in this version.
A/UX, NeXTSTEP, & OS X
+0 Vote Up -0Vote Down

One thing that gets tedious in the IT community and Oracle community is the penchant for Windows only solutions. While Microsoft does an excellent job in certain domains, I remain a loyal Apple customer. By the way, you can install Oracle Client software on Mac OS X and run SQL Developer against any Oracle Database server. You can even run MySQL Workbench and MySQL server natively on the Mac OS X platform, which creates a robust development platform and gives you more testing options with the MySQL monitor (the client software).

Notwithstanding, some Windows users appear to malign Apple and the Mac OS X on compatibility, but they don’t understand that it’s a derivative of the

  [Read more...]
SSL and MariaDB/MySQL
+1 Vote Up -0Vote Down

With the recent Heartbleed bug, people are clearly more interested in their MariaDB/MySQL running with SSL and if they have problems. First up, you should read the advisory notes: MariaDB, Percona Server (blog), and MySQL (blog).

Next, when you install MariaDB (or a variant) you are usually dynamically linked to the OpenSSL library that the system provides. Typically on startup

  [Read more...]
MySQL Enterprise Backup 3.10: Teasing compression.
Employee +0 Vote Up -0Vote Down

Ok, so I wanted to look into the new compression options of MEB 3.10.

And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.

An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.

So, these tests are solely about backup. I’ll do restore when I get some *more* time.

 

First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:

Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.

mysqlbackup --user=root --password=oracle
  [Read more...]
MySQL Enterprise Backup 3.10: Teasing compression.
Employee +0 Vote Up -0Vote Down

Ok, so I wanted to look into the new compression options of MEB 3.10.

And I would like to share my tests with you. Remember, they’re just this, tests, so please feel free to copy n paste and obtain your own results and conclusions, and should I say it, baselines, in order to compare future behaviour, on your own system.

An Oracle Linux 6.3 virtual machine with 3Gb RAM, 2 virtual threads, on a 1x quad core, windows laptop. Not pretty, but hey.

So, these tests are solely about backup. I’ll do restore when I get some *more* time.

 

First up, lets compare like with like, i.e. MEB version 3.9 & 3.10:

Let’s make this interesting, hence, want to use as much resources available as possible, read, write, process threads and number of buffers.

mysqlbackup --user=root --password=oracle
  [Read more...]
"Minute-to-win-it" Blue Studio by Beats - Heterogenous Replication Survey
+0 Vote Up -0Vote Down
Continuent would like to better understand the relationships and data flows that exist between different database systems that you are using to understand your replication and data integration needs better. In particular, we'd like to know about any heterogeneous data exchanges, including manual dump/load and automated process, and whether non-database sources, such as Twitter and Facebook,
MySQL for Excel new features (1.2.0): Edit Connections
Employee +1 Vote Up -0Vote Down

Welcome to another post of the MySQL for Excel team, this time we will talk about another cool feature you can find in our latest release to date (1.2.0) which can be downloaded directly from our MySQL Installer downloads page.

If you want to learn how you can easily edit connections directly from the main MySQL for Excel panel now please read this post.

If you would like to give us your feedback and propose new features you would like to see on future versions of MySQL for Excel we encourage you to please visit our forum and leave us a comment.
Thank you for your support!

Porting from Oracle to MySQL
+0 Vote Up -0Vote Down
A potential customer asked my about porting her application from Oracle Database to MySQL.

I always try to start with the "why" (a dear friend bought me this book, recommended: http://www.amazon.com/Start-Why-Leaders-Inspire-Everyone/dp/1591846447).

She said "cloud!". I said "OK!".

I conducted a short research, found many things in many places all over the place, brought them to a nice email I sent her back and then thought I'll post it here and make it public as it might be useful for us all. If you feel that I missed something, add comments, send feedback.

These are the leading tools to do the actual migration of the data structure, data export/import, sprocs, triggers, etc.:
  • MySQL Workbench has a migration feature: http://www.mysql.com/products/workbench/migrate/
  • MySQLYog can be used to migrate:









  •   [Read more...]
    MySQL Connector/NET 6.7.5 has been released
    Employee +0 Vote Up -0Vote Down
    Dear MySQL Users,
    MySQL Connector/NET 6.7.5, a new version of the all-managed .NET driver for MySQL has been released.  This is a Maintenance release. It is recommended for production environments.  It is appropriate for use with MySQL server versions 5.0-5.7.
    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.)
    Also Nuget packages are available:
    http://www.nuget.org/packages/MySql.Data/6.7.5



      [Read more...]
    Data Encryption with MySQL Enterprise Backup 3.10
    Employee_Team +0 Vote Up -0Vote Down

    Introduction

    MySQL Enterprise Backup (MEB) 3.10 introduces support for encrypted backups by allowing backup images, or single-file backups, to be encrypted. However, backups stored in multiple files in a backup directory can not be encrypted.

    Any MEB command that produces a backup image can be optionally requested to encrypt it. The encrypted backup image can be stored in a file or tape in the same way as an unencrypted backup image. Similarly, any MEB command that reads data from a backup image accepts also an encrypted backup image. This means that encrypted backups can be used in all the same situations as unencrypted backup images.

    MEB encrypts data with Advanced Encryption Standard (AES) algorithm in CBC mode with 256-bit keys. AES is a symmetric block cipher which means that the same key is used both for encryption and

      [Read more...]
    Connector/J 5.1.30 is out with Fabric support
    Employee +0 Vote Up -0Vote Down

    Today marks the release of several exciting pieces of software from Oracle. In addition to MySQL server 5.7.4 DMR, MySQL Fabric is out as a release candidate 1.4.2 and Connector/J 5.1.30 has full support. MySQL Fabric is a new way to implement high-availability and scale-out with MySQL server. It provides a way to group sets of servers into high-availability groups with automatic replication configuration. If scale-out is important, sharding can be defined in terms of these high-availability groups.

    To use Connector/J with Fabric, you only need to add the jar to your classpath. If you are still using Java 5, you will need to manually load the com.mysql.fabric.jdbc.FabricMySQLDriver class to register the driver. Fabric-aware connections are made with a JDBC URL of the form jdbc:mysql:fabric://host:port/db. Several connection properties are available to influence the behavior of

      [Read more...]
    Offline checksum validation for directory and Image backup using MySQL Enterprise Backup
    Employee_Team +0 Vote Up -0Vote Down
    Data integrity: ------------------- Data integrity refers to maintaining and assuring the accuracy and consistency of data over its entire life-cycle. Every organization whether it's small or large want to make sure their data is consistent and error free. Data might move to other media/ different storage system for performance, speed, scalability or any other business reasons. So we want to make sure data is not corrupt while migration/movement. Data integrity is a policy which enterprise can enforce to be confident about their own data.
    The overall intent of any data integrity technique is to ensure data is recorded exactly as  intended and upon retrieval later, ensure data is the same as it was when originally recorded.

    Objective:


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

    Monday 31 March 2014 proved to be a big day for MySQL with 5 announcements of products getting new releases: the next milestone release MySQL Server 5.7.4, MySQL Workbench 6.1 going GA and Connector/J 5.1.30 and MySQL Utilities 1.4.2 RC which include MySQL Fabric. That’s 4, the fifth being Connector/Python.

    Connector/Python v1.2.1 has been released as

      [Read more...]
    How To - Guide to editing MySQL data within Excel
    Employee +0 Vote Up -0Vote Down

    In previous posts we have talked about importing data from MySQL to Excel, exporting data from Excel to a new or to a existing MySQL table (via the Export Data or Append Data operations) which are common tasks to be performed against MySQL tables. In this post we will talk about possibly the coolest feature in MySQL for Excel which is the Edit Data operation which allows the retrieval of a MySQL table's data to an Excel worksheet so the data can be edited, deleted or inserted in new rows and those changes saved back to the MySQL database in a friendly and intuitive way, and more importantly, without the need of writing SQL queries making it accessible to any kind of user.

    You will learn in this guide how to do it and all the details about the Edit Data feature in MySQL for Excel.

    9 Reasons For Attending The Percona Live MySQL Conference & Expo 2014
    +0 Vote Up -0Vote Down
    March 28, 2014 By Severalnines

     

    Percona Live MySQL Conference & Expo - March 31st to April 4th

    The Severalnines Team Will Be Onsite at Booth 418 - Come Say Hello!

     

     

    If you’re still thinking about whether or not you should be attending the Percona Live MySQL Conference & Expo that starts on Monday 31st of March, here are 9 reasons (we are Severalnines after all) on why we’ll be there. May these help you positively in

      [Read more...]
    Faster and Space efficient Restore with MySQL Enterprise Backup
    Employee_Team +1 Vote Up -0Vote Down

    The new operation 'Copy-back-and-apply-log' introduced in MySQL Enterprise Backup 3.9.0 helps in faster restoration and helps in reducing the amount of space involved in restoring the backup contained in an image, because of elimination of the intermediate step of extraction of image contents. 

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

    The MySQL Windows Experience Team is proud to announce the release of MySQL for Excel version 1.2.1.

    MySQL for Excel 1.2.1 is a maintenance release for 1.2.x containing a handful of bug fixes and the following minor features:

    • When MySQL Workbench is not installed, MySQL connections are now automatically created for discovered MySQL services. If MySQL Workbench is later installed, these connections are not migrated over to MySQL Workbench as MySQL Workbench also creates connections for discovered MySQL services.

    You can download MySQL for Excel 1.2.1 from our official Downloads page at http://dev.mysql.com/downloads/windows/excel as a standalone MSI, and it will be available shortly in the MySQL Installer for Windows that can

      [Read more...]
    I'm speaking about MySQL tools on BGOUG's spring conference
    Employee +0 Vote Up -0Vote Down

    I will be speaking about MySQL at the Bulgarian Oracle Users Group's Spring Conference.

    In furthering my mission to increase the MySQL knowledge among my countrymen I will try to give the grand tour of all the modern MySQL administrative and development tools that the MySQL team provides.

    This will be the 3d BGOUG conference I'm speaking to. And I expect no less than the stellar organization and the great audience that I had the privilege to interact with during the previous 2 conferences.

    We had a lot of fun too ! Parties from the last 2 conferences are

      [Read more...]
    How To - Guide to appending data from Excel to an existing MySQL table
    Employee +0 Vote Up -0Vote Down

    Today we're going to talk about one of main features from MySQL for Excel. There may be times when you have a MySQL Database table that you want to add new rows to. In this blog post we're going to show you how you can do that from within Excel directly easily using the Append Excel Data to Table feature.

    Always remember MySQL for Excel can be downloaded and installed directly for free, from our MySQL Installer downloads (http://www.mysql.com/downloads/installer/) page.

    Your feedback is very important for us, please drop us a message and follow our social networks: Cheers!
    We're hiring!
    +1 Vote Up -0Vote Down
    Continuent, a leading provider of database clustering and replication software has five (5) new positions open: Build/Test Engineer Senior Database Availability and Clustering Engineer Senior Database Replication Engineer Data Replication Sales Engineer Clustering and Replication Test Development Engineer If you want to get in on the ground floor of a growing company in a challenging field
    MySQL NL Meetup March 18
    +0 Vote Up -0Vote Down
    The next MySQL User Group NL meetup is this Tuesday at the Oracle office in Utrecht.

    For more info go to the Event page @ Meetup.com
    HowTo: MySQL new toolbar inside the Visual Studio IDE
    Employee +2 Vote Up -1Vote Down
    MySQL for Visual Studio 1.1.4 was released including a new feature: MySQL Toolbar inside the Visual Studio environment. This post will cover the details on this new feature.
    MySQL for Visual Studio 1.1.4 is available for download
    Employee +0 Vote Up -0Vote Down
    MySQL for Visual Studio is a product including all of the Visual Studio integration previously available as part of Connector/Net. Today we're releasing the 1.1.4 Maintenance Release of this product. It is a version suitable for production environments, compatible with Connector/Net 6.8.3 or further versions and supports MySQL server versions 5.0 to 5.6.
    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

      [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...]
    Showing entries 1 to 30 of 1342 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.