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 1379 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

Continuent Delivers Real-Time Data to Cloudera | Business Wire
+0 Vote Up -0Vote Down
SAN JOSE, CA– May 6, 2014 – Continuent, Inc., a leading provider of open source database clustering and replication solutions, today announced that their recently announced Tungsten Replicator 3.0 solution has been certified by Cloudera, the leader in enterprise analytic data management powered by Apache Hadoop™. Continuent Tungsten Replicator 3.0 enables organizations to quickly and easily 
Eventual consistency of NoSQL marketing
+0 Vote Up -0Vote Down
Yesterday I learnt an important lesson about an important difference between NoSQL and MySQL, at least when it comes to the marketing and hype.

I saw a tweet from around marketing of one of NoSQL leaders:

Most people apparently would just conclude from the tweet's text, however I actually clicked the link, and couldn't believe eyes:

I guess that in NoSQL, when it comes to the integrity of data as well as hype - it is eventually consistent...



Setup & operate Tungsten webinar series
+1 Vote Up -0Vote Down
Don't miss your opportunity to learn about Continuent Tungsten via our free "Setup & Operate" webcast series. These free webcasts include live presentations and interactive Q&A.Webcast OverviewsSetup & Operate Tungsten ReplicatorMay 15th, 10:00 am PDTTungsten Replicator is an innovative and reliable tool that can solve your most complex replication problems. We will introduce Replicator
MySQL Connector/NET 6.9.0 alpha has been released
Employee +0 Vote Up -0Vote Down

Dear MySQL users,

MySQL Connector/Net 6.9.0 a new version of the all-managed .NET driver for MySQL has been released. This is an alpha release for 6.9.x and is not recommended for production environments.

The 6.9 version of MySQL Connector/NET brings the following new features:


     * MySQL Personalization Provider.
     * SiteMap Web Provider.
     * Simple Membership Web Provider.

Enjoy and thanks for the support!
On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

Toad Freeware Page
+0 Vote Up -0Vote Down

While I posted how to install Toad for MySQL Freeware five years ago, I’m always surprised how few people know about it there and consistently updated and improved. You can download Toad for MySQL Freeware or Toad Freeware for Oracle, SQL Server, Sybase, or IBM DB2 at this web site.

You can also download Toad Data Modeler Freeware Edition. Just two notes, while Toad for Oracle Freeware is an MSI file, Toad for MySQL Freeware is a zip file and limited to only a Windows install.

Cloning a slave using Mysql Enterprise Backup on a GTID enabled server
Employee +0 Vote Up -0Vote Down

MySQL 5.6 introduced a new feature called GTID (Global Transaction IDentifier) support in Replication. For every transaction that is committed on to the server, a GTID of the format :

server_uuid:transaction_id is written into the master's binary log.

This offers the following advantages:

  • Very helpful to set up a slave and create a replication setup.

  • User need not worry about fetching the master's binlog filename and position in the “CHANGE MASTER TO” command which is used to synchronise the slave with the master.

  • Applying GTIDs on slaves ensures consistency – since GTIDs are unique, it cannot be applied more than once on the server.

For a gtid enabled server, the following properties

  [Read more...]
What's new on MySQL for Visual Studio 1.2.0 alpha, part one
Employee +2 Vote Up -0Vote Down
MySQL for Visual Studio 1.2.0 was just released the last week. In this post we will make a quick introduction on what's coming up in this new version. 
MySQL for Visual Studio 1.2.0 alpha has been released
Employee +1 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,
Editing MySQL connections within MySQL for Excel
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 since version 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 +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 +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 +1 Vote Up -0Vote Down

    A typical backup cycle with MySQL Enterprise Backup had always involved 3 steps:

    1. backup (to directory)

    2. apply-log (prepare the backup)

    3. copy-back (restore)

    In case of directory, the 'apply-log' is done on the backup directory which does not involve any additional space.

    But in case of image, the image has to be extracted, before doing 'apply-log'. This involves additional space for extraction of image and the steps involved are:

    1. backup-to-image

    2. Extract

    3. apply-log

    4. copy-back

    How about, combining the 3 steps – extract, apply-log and copy-back, so that the image is extracted directly on the target directory (which is the datadir of a server instance) and then apply-log is performed on the extracted contents. This way, the need for additional space

      [Read more...]
    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 the main features in 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.
    Previous 30 Newer Entries Showing entries 31 to 60 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.