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 121 to 150 of 1387 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

MySQL Connector/Net 6.8.0 alpha has been released
Employee +1 Vote Up -0Vote Down

Dear MySQL users,

MySQL Connector/Net 6.8.0, a new version of the all-managed .NET driver for MySQL has been released. This is an alpha 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.0 version of MySQL Connector/Net has support for Entity Framework 6.0.

The release is available to download at http://dev.mysql.com/downloads/connector/net/#downloads

New MySQL features, related technologies at Percona Live London
+0 Vote Up -0Vote Down

The upcoming Percona Live London conference, November 11-12, features quite a number of talks about the latest MySQL features and related technologies. There will be a lots of talks about the new MySQL 5.6 features:

  [Read more...]
Log Buffer #342, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Naysayer within us keep on erecting new obstacles, especially when it comes to the creativity. Our database bloggers are winning this fight within and producing gems of blogs. This Log Buffer edition celebrates their victory.

Oracle:

Andy Baker is shrinking a Linux OEL 6 virtual Box image (vdi) hosted on Windows 7.

So what is Active GridLink for RAC? Ruma Sanyal tells us.

Curtis is installing Oracle Golden Gate 12c (12.1.2) along side Oracle Database 12c (12.1.0.1).

  [Read more...]
MySQL for Excel 1.1.3 has been released
Employee +2 Vote Up -0Vote Down

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

MySQL for Excel 1.1.3 is a maintenance release containing a handful of bug fixes and the following minor features:

  • Upon saving a Workbook containing Worksheets in Edit Mode, the user is asked if he wants to exit the Edit Mode on all Worksheets before their parent Workbook is saved so the Worksheets are saved unprotected, otherwise the Worksheets will remain protected and the users will be able to unprotect them later retrieving the passkeys from the application log after closing MySQL for Excel.
  • Added background coloring to the column names header row of an Import Data operation to have the same look as the one in an Edit Data
  [Read more...]
Log Buffer #341, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Extreme performance is the key to excellence. One example of it is the winning of 34th America Cup by Team Oracle USA, another example is the Pythian’s legendary love of  data, and this Log Buffer edition loves the blogs again, as it does weekly.

Oracle:

The 10 commandments of being a good DBA manager.

Oracle ADF Mobile #{row.index} is Not Supported After Installing Upgrade Patch

With Oracle Real Application Clusters the Oracle database can be configured to restart as each node in the cluster is

  [Read more...]
MySQL Tech Tour @Barcelona, 7th Nov.
Employee +0 Vote Up -0Vote Down

We’re on the move again. Come and join us on the 7th of November at the Oracle office in Barcelona. Find out more details about what was announced at MySQL Connect, as well as what’s next…

For more information about this event please visit the link below:

http://www.oracle.com/us/dm/29173-emeafm13045970mpp010-oem-2020763-es.html


MySQL Tech Tour @Barcelona, 7th Nov.
Employee +0 Vote Up -0Vote Down

We’re on the move again. Come and join us on the 7th of November at the Oracle office in Barcelona. Find out more details about what was announced at MySQL Connect, as well as what’s next…

For more information about this event please visit the link below:

http://www.oracle.com/us/dm/29173-emeafm13045970mpp010-oem-2020763-es.html


Get Started on the Leading Database for Web Applications and Cloud
Employee_Team +0 Vote Up -0Vote Down

MySQL is the leading database for web applications and the leading database for cloud. To facilitate your use of MySQL, start your learning by taking the MySQL for Beginners training course

This course covers topics permitting you to:

  • Describe MySQL GUI tools
  • Describe the features and benefits of MySQL
  • Explain the basics of relational databases
  • Design an effective database
  • Build a database and tables by using SQL
  • Modify or delete database entities
  • Query data with the SELECT command
  • Join data from multiple tables
  • Perform nested subqueries
  • Use built-in MySQL functions
  • Explain
  •   [Read more...]
    Log Buffer #340, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    Education is everything. Education can pull you out of poverty, it can propel you into upper echelons. Education can make you see what’s truly important in the life. Education can enable you to appreciate the people. Blogging is all about education. This Log Buffer brings education about database arena from the blogs.

    Oracle:

    Large CLOBs and attention to detail needed while reading Oracle Support notes.

    Here is a simple way to get SQL_ID of large and similar queries in Oracle.

    Robin Moffatt is sharing

      [Read more...]
    MySQL 5.7 multi-source replication
    +4 Vote Up -0Vote Down

    Recently Oracle announced several new features for the latest available development version of MySQL that is 5.7.2 at the time of writing this article. Most of them are performance and replication related that show us how incredible the new release will be.

    In this post I’m going to try to explain in some easy steps how the new multi-source replication works and how we can configure it for our own tests. It is important to mention that this is a development release, so it is not production ready. Therefore this post is intend to people that want to test the new feature and see how it works with their application, always in a staging environment.

    What is multi-source replication?

    First, we need to have clear that multi-master and multi-source replication are not the same. Multi-Master replication is the usual

      [Read more...]
    Oracle Speakers at Percona Live London 2013
    +2 Vote Up -0Vote Down

    I’m pleased to announce that speakers from Oracle will join the lineup at the Percona Live London 2013 MySQL conference which is November 11 & 12. Percona Live London 2013 features 4 keynotes, 30 breakout sessions, and 7 tutorials by leading MySQL users and technology providers. The full conference schedule is now on the Percona Live London MySQL

      [Read more...]
    Log Buffer #339, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    Tablogs are the blogs written, read, and managed on tablets. They are not only growing in numbers, but the volume of content is also immense. So much ease and so much power through touches ensure that you only spend time creating and learning. This Log Buffer edition appreciates that.

    Oracle:

    Michael Abbey is taking a quick look at table-level recovery with Database 12c including sample script and output.

    Jeremy Schneider has written a brief post to mention an undocumented resource manage limit.

    Here’s an important point JL learned from Maria Colgan’s “10 tips”

      [Read more...]
    Backing up full server instance using MySQL Enterprise Backup
    Employee +0 Vote Up -0Vote Down
    Introduction:

    MySQL Enterprise Backup(MEB) takes fast, consistent backups of MySQL server data, and helps in restoring the server to source server's data at the time of backup. But most of the times it is as much important to have same source server's state(server configuration like server global variables, plugins), as data. As backups become more frequent, server variables modified, plugins added or removed, it is very difficult to keep track of this changing server states for every backup. MEB 3.9.0 helps user in providing a complete backup so that the restored server can run with exactly the same state as that of the source server at the time of the backup.


      [Read more...]
    MEB & OSB slides for the the talk at Oracle open World
    Employee +0 Vote Up -0Vote Down

    Here are the slides for the talk given at Oracle Open world about MEB & OSB.

    MySQL Enterprise Backup: Introduction and Working with Oracle Secure Backup

    Slides for MEB talk at MySQL Connect
    Employee +0 Vote Up -0Vote Down

    Here are the slides for my talk at MySQL connect, 

    Backing up the MySQL Database.


    Forking MySQL/ for how long can forks keep up?
    +13 Vote Up -3Vote Down
    • Fact: MySQL 5.6 was released as GA in February 2013
    • Fact: MySQL 5.6 has been available with its complete set of features since September 2012
    • Fact: On September 21st, Oracle has released MySQL 5.7.2, which is the de facto major release after MySQL 5.6 (5.7.1 was just a token “we’re-still-in-business” release).
    • Fact: As of today, there is no GA-ready fork of MySQL 5.6.

    Percona Server is still in RC state, while MariaDB, with its runaway version 10, is still in alpha state. Of these releases, Percona Server seems the one in the better shape. Their problem was to adapt Percona Server to the enhanced codebase for 5.6, and the merging problems were bigger than the ones encountered in 5.1 and 5.5. Percona Server is a business oriented

      [Read more...]
    Oracle's MySQL Connect 2013 conference summary
    +3 Vote Up -0Vote Down
    Although, hosting the event on a weekend, which is an inconvenience to those who have family, and ignoring the fact that it's Oracle's third MySQL Connect event, I would have to say that this year's Oracle MySQL Connect conference was the best one yet. This past year, I have been mostly heads-down working at +LinkedIn so I haven't been paying close attention to what Oracle has been doing for +
    MySQL 5.7.2 : Good job Oracle! (Well, almost)
    +5 Vote Up -4Vote Down

    On September 21st, during the opening keynote at MySQL Connect 2013, Tomas Ulin disclosed the release of MySQL 5.7.2. This is a milestone release that includes several new features. Unlike the Previous one, which was just a point of pride, where Oracle was stating its continuous commitment to releasing new versions of MySQL. In MySQL 5.7.2, we see several new features:

    • First and foremost, performance. The announcement slides say MySQL 5.7.2 is 95% faster than MySQL 5.6 and 172% faster than MySQL 5.5. I don’t know yet in which circumstances these numbers hold true, but I am sure someone at Percona will soon prove or disprove the claim.
    • Performance Schema tables for several aspects:
      [Read more...]
    OL 4 MySQL: Extending my VM’s root f/s online
    Employee +0 Vote Up -0Vote Down

    Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).

    I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.

    Filesystem            Size  Used Avail Use% Mounted on
    /dev/mapper/vg_ol63uek01-LogVol01
                          7.1G  5.7G  1.1G  85% /

    As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.

    fdisk -l

    Will be able to identify the new & unused partition:

    [root@ol63uek01 ~]# fdisk -l
    Disk /dev/sda: 8589 MB, 8589934592 bytes
     255 heads, 63 sectors/track, 1044 cylinders
     Units = cylinders of
      [Read more...]
    OL 4 MySQL: Extending my VM’s root f/s online
    Employee +0 Vote Up -0Vote Down

    Ok, so after all the things that have been announced @MySQLConnect, I’ve got to play around with them. First stop: space (no.. not ‘the final frontier’).

    I need more space on my f/s to get installing. I was a bit of a scrooge when I created my Oracle Linux virtual machine, so now I’m paying the price.

    Filesystem            Size  Used Avail Use% Mounted on
    /dev/mapper/vg_ol63uek01-LogVol01
                          7.1G  5.7G  1.1G  85% /

    As I’m using Virtual Box, I’ve added a new SATA Controller vmdk of 10G, SATA Port 1 and then start it up.

    fdisk -l

    Will be able to identify the new & unused partition:

    [root@ol63uek01 ~]# fdisk -l
    Disk /dev/sda: 8589 MB, 8589934592 bytes
     255 heads, 63 sectors/track, 1044 cylinders
     Units = cylinders of
      [Read more...]
    MySQL Fabric support in Connector/Python
    Employee +0 Vote Up -0Vote Down

    MySQL Fabric was officially introduced during Tomas his keynote at MySQL Connect 2013. MySQL Fabric will help you managing lots of MySQL server supporting both high-availability and sharding. Just like Connector/J, MySQL Connector/Python v1.1.1 Alpha has support for MySQL Fabric on MySQL Labs. Note that the MySQL Fabric as well as support for it in Connector/Python is Alpha.

    When you download MySQL Connector/Python from MySQL Labs, you will also see a ZIP

      [Read more...]
    MySQL Connector/J with Fabric Support
    Employee +0 Vote Up -0Vote Down
    As Tomas announced in his keynote at MySQL Connect 2013, we are working on a brand new product called MySQL Fabric. Along with this release of MySQL Fabric, we are releasing Connector/J 5.1.26 with Fabric support on labs.mysql.com. This is an alpha-quality release that adds support for scalability features in MySQL Fabric. Sharding and read/write splitting are the initial features supported by Connector/J.
    In a setup involving read/write splitting or customized sharding, we generally have to duplicate knowledge of this configuration in the client applications. This is done in connection strings specified in configuration files or directly in code. With MySQL Fabric, we can express our system-wide configuration of database servers in a way that it can be accessed by client applications. In cases where this needs to change (and it always does..), the
      [Read more...]
    Log Buffer #338, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    Oracle OpenWorld 2013 is just days away, and Pythian is once again everywhere at OOW. Pythian’s famous Annual Oracle Bloggers Meetup — one of your top favorite events of OpenWorld, is once again here at OOW.

    Oracle:

    As this year is heading to a close, it will complete 21 years of partnership between Intel and Oracle.

    Have you started to pay closer attention to social, cloud, mobile, and/or big data technologies and trends?

    NetBeans IDE 7.4 RC 1, released today, has a long list of features, including

      [Read more...]
    Backing up selective innodb tables using MEB.
    Employee +0 Vote Up -0Vote Down

    MySQL 5.6 introduced the TTS(transportable table spaces) feature which enables moving a table from one server to another. This feature coupled with MEB 3.9 enables backing up a set of tables matching (regex specified with) the –include option.

    The backup of selective tables using transportable tablespaces feature of innodb is referred as tts/selective backup in the remainder of the section.

    The difference between a regular partial backup and with using tts is that the regular partial backups are stand alone and cannot be plugged into a another server where as the tts backups in contrast enables the tables to be plugged into another



      [Read more...]
    How to restore directly on a remote machine from the backup stream
    Employee +0 Vote Up -0Vote Down

    MySQL Enterprise Backup has been improved to support single step restore from the latest release 3.9.0. It enables you to restore the backup image to remote machine in single step. However, first you would have to create the backup image in local disk, copy the backup image to remote machine, and then restore in remote machine by running copy-back-and-apply-log command.

    This approach has two overheads:

        Serial execution: You have to wait for each step to finish before beginning the next (e.g. You must have to wait for backup-to-image operation to finish before beginning copy).  [Read more...]
    Skip Unused Pages with MySQL Enterprise Backup 3.9.0
    Employee +2 Vote Up -0Vote Down
    Disclaimer
    The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

    Introduction

    There are database usage patterns, where tables grow big at times and many rows are deleted from them later. InnoDB does never shrink a table space. In these cases we can end up with big data files, which contain a lot of unused pages. It is a waste of disk- and I/O- resources to back them up.

    Users have manifold requested that MySQL Enterprise Backup does not back up unused InnoDB data pages. Some want smaller backups, some want less I/O, some want shrinked table spaces.

    MySQL Enterprise Backup 3.9.0 can help with smaller backups. The effect on I/O is not that remarkable. InnoDB data files must be expanded to their original size when they are restored. Backup cannot accomplish a shrinkage of







      [Read more...]
    MySQL Enterprise Backup: PITR Partial Online Recovery
    Employee +3 Vote Up -0Vote Down

    Here’s a look at using MySQL Enterprise Backup in a specific example:

    Consider a Backup Policy

    – Full Backup of the environment. – Complemental Incremental backups & online BinLogs. And the Restore: – Logical Restore. – Online, Zero impact. – Partial, single database, group of tables.

    The Backup

    A working environment, with 4 databases, of which 2 will require restoration. Full backup with MySQL Enterprise Backup:
    mysqlbackup --user=root --socket=/tmp/mysql.sock \
      --backup-dir=/home/mysql/voju5/backup/ \
      --with-timestamp backup

    Test preparation

    Create 4 different databases, where the structure & content is the same.
    create database v5_1; use v5_1; create table `voju5` (
      `ID` int(7) NOT NULL AUTO_INCREMENT,
      `Name` char(20) NOT NULL DEFAULT '‘,
      [Read more...]
    MySQL Enterprise Backup: PITR Partial Online Recovery
    Employee +0 Vote Up -0Vote Down

    Here’s a look at using MySQL Enterprise Backup in a specific example:

    Consider a Backup Policy

    – Full Backup of the environment. – Complemental Incremental backups & online BinLogs. And the Restore: – Logical Restore. – Online, Zero impact. – Partial, single database, group of tables.

    The Backup

    A working environment, with 4 databases, of which 2 will require restoration. Full backup with MySQL Enterprise Backup:
    mysqlbackup --user=root --socket=/tmp/mysql.sock \
      --backup-dir=/home/mysql/voju5/backup/ \
      --with-timestamp backup

    Test preparation

    Create 4 different databases, where the structure & content is the same.
    create database v5_1; use v5_1; create table `voju5` (
      `ID` int(7) NOT NULL AUTO_INCREMENT,
      `Name` char(20) NOT NULL DEFAULT '‘,
      [Read more...]
    Inserting NULLs into NOT NULL columns in 5.6: refused by default
    Employee_Team +0 Vote Up -0Vote Down

    MySQL 5.6 ships with a default config file that sets the SQL mode to NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES . Here is what happens if you try to insert NULL values into a table with NOT NULL columns:

    mysql> create table safetyfirst(
        -> id int primary key not null auto_increment,
        -> country varchar(60) NOT NULL,
        -> product varchar(60) NOT NULL );
    Query OK, 0 rows affected (0.24 sec)
    
    mysql> insert into safetyfirst(country) values('Sweden');
    ERROR 1364 (HY000): Field 'product' doesn't have a default value

    If someone tells you that MySQL 5.6 by default allows you to do this, ask them to prove it using the default settings we use for new installations and check their claim by asking them for

      [Read more...]
    Log Buffer #337, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down

    The journey is old, but the milestones are new. It’s the same old quest for excellence. Innovative questions are being asked and answered in the blogs across the Oracle, SQL Server and MySQL branches of technologies. This Log Buffer Edition relishes just that. Let’s start this Log Buffer with the exquisite blog post by Dana Pylayeva.
    Oracle:

    EMlight might not be as important now with Oracle 12c coming out and with Oracle’s EM Express, but EMlight is still pretty cool.

    The maximum size for VARCHAR2, NVARCHAR and RAW columns has been extended to 32767 bytes with the


      [Read more...]
    Previous 30 Newer Entries Showing entries 121 to 150 of 1387 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.