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 91 to 120 of 1377 Next 30 Older Entries

Displaying posts with tag: Oracle (reset)

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 +0 Vote Up -0Vote Down

The latest versions of MySQL Workbench starting from version 6 have the capability to integrate with MySQL Enterprise Backup (MEB).

Though all the functionality of MEB is not supported, it is still a great tool to begin your backup and get your backup setup in minutes. Workbench also provides the additional capability to be able to schedule your backups.

The sections below illustrate the setup and usage of the Workbench UI to be able to setup and execute backup using MEB.

This is a quick start guide to setup, make a backup and do a recovery using MySQL Workbench and MEB.

The installation of WB and MEB is not discussed; it should be a simple automated install for both packages.

Setup

Workbench now comes with a new MySQL enterprise options in its navigator menu on the left. You need to click the Online

  [Read more...]
Why Oracle won’t kill MySQL
+1 Vote Up -0Vote Down
Join 15,000 others and follow Sean Hull on twitter @hullsean. 1. MySQL does not compete with Oracle It’s a myth that MySQL somehow poses a threat to Oracle. Oracle’s customers tend to be large enterprises running apps like e-business suite. These are certified to run on Oracle, and further they sit close to finance. MySQL […]
MySQL Synonym?
+0 Vote Up -0Vote Down

Somebody asked how to create a SYNONYM in MySQL, which is interesting because MySQL doesn’t support synonyms. I thought the prior entry explained how to do it, but here’s a new post. However, you can create a view in one database that relies on a table in another database.

The following SQL statements create two databases and grant appropriate privileges to the student as the root superuser:

/* Create two databases. */
CREATE DATABASE seussdb;
CREATE DATABASE appdb;
 
/* Grant privileges to a student user. */
GRANT ALL ON seussdb.* TO student;
GRANT ALL ON appdb.* TO student;

Log out from the root superuser and reconnect as the student user. Then, the following code connects to the

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

What do swaying palms, turquoise water, white sandy beaches and absolutely pristine fauna remind you of? Correct! It’s Log Buffer. This Log Buffer brings you beads of blog posts related to data dexterity crafted by leading bloggers across the planet.

Oracle:

When are Exadata’s storage indexes used?

Oracle 12c has increased the maximum length of character-based columns to 32K bytes.

Oracle has extended the maximum length of varchar2, nvarchar and raw columns to 32K, but this comes with some challenges when it comes to indexing such columns.

  [Read more...]
How to: Using Replication & Load balancing with Connector/NET
Employee +1 Vote Up -0Vote Down
Connector/NET 6.7 provides replication & load balancing configuration that allows to connect to master/slaves environments and at the same time balancing the request over all the available server in this scenario. This post will show you how to configure and use these new features on a console application.
Building a geo-distributed database for your global applications
+1 Vote Up -0Vote Down
DBTA roundtable: Building a Geo-Distributed Database for Your Global Applications THURSDAY, DECEMBER 5, 2013 11:00am PT / 2:00pm ET In today's global economy, more and more businesses have employees,
Log Buffer #346, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Economist says that Physics suggest that storms will get worse as the planet warms. Typhoon Haiyan in Philippines, bush-fires in Australia, floods in China, and extreme unpredictable weather across the planet is a sober reminder. Good news is that technology and awareness is rising, and so is the data. Database technologies are playing their part to intelligently store that data and enabling the stakeholders to analyze and get meaningful results to predict and counter the extreme conditions. This Log Buffer Edition appreciates these efforts.

Big Data:

Big Data Tools that You Need to Know About – Hadoop & NoSQL.

  [Read more...]
Hello World
Employee +2 Vote Up -0Vote Down

So here goes …

While there are already some blog postings from me at Oracle’s MySQL Enterprise Backup (MEB) team blog at https://blogs.oracle.com/mysqlenterprisebackup/, this blog is for my personal views and views outside of MEB.

Why the name with 2c.
The first challenge before you think of blogging is to convice yourself that maybe your views will have some value for a reader. The second is to find a name of the blog. Its not that I am fully convinced of the former but there are some things that need to be written and since the need is mine the fulfillment of the need should also come from me.

The name is to ensure to keep my words humble and respect views which may differ from mine; maybe conflicting and still right. Different people have differing views and this blog is just one view as seen


  [Read more...]
MySQL Connector/Net 6.8.1 beta has been released
Employee +1 Vote Up -0Vote Down

Dear MySQL users,

MySQL Connector/Net 6.8.1, a new version of the all-managed .NET driver for MySQL has been released. This is a beta 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.1 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

Log Buffer #345, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

There are a number of technologies, apps, and social media creations out there seeking to displace blogs as the mode of sharing between surfers, but blogging has proved hardy. It has proven its mettle and it’s here to stay. This Log Buffer Edition appreciates this strength of the blogs.

Oracle:

Translating Fusion Apps Customizations: Composers mean Usable Apps in Any Language, Ultan o’Broin has more.

Do you find yourself trying several times to explain a problem in a Service Request? Does the support engineer ask more than once for clarification?

What If I Don’t Get An Exam Results

  [Read more...]
Continuent Tungsten Use Case: How Gittigidiyor (a subsidiary of eBay) Replicates Data In Real Time From MySQL To Oracle
+0 Vote Up -0Vote Down
Learn how Gittigidiyor (a subsidiary of eBay) replicates data in real time from MySQL to Oracle with Continuent Tungsten. Gittigidiyor consolidates reporting data in a single MySQL server. Transactions arriving on this server must be replicated in real time to an Oracle instance. In this webinar, Levent Kurt, Site Operations Manager at Gittigidiyor, describes how Gittigidiyor solved their
Log Buffer #344, A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Every day is a new journey but the path remains the same. Bloggers are advancing on this path to reach new milestones. They sometimes pace high, sometime low, but whatever, they never miss to share what they learn along the way, and present that through Log Buffer.

Oracle:

This post is about installing a Virtualized Oracle 12cR1 RAC Cluster using Oracle Linux 6.4 Virtual Machines on VMware ESXi 5.

Frits Hoogland is compressing sqlplus output using a pipe.

One of the greatest advancements in EM12c from previous Enterprise Manager versions is the auto-deployment.

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

One key success factor in a great leadership is to gather great people around you. Bloggers are people, and this Log Buffer Edition enables you to gather them around you through their blog posts.

Oracle:

The PHP OCI8 2.0.6 extension for Oracle Database is now “production” status.

Oracle GoldenGate 12c released  on October 17th and includes several new cutting edge features that firmly establishes GoldenGate’s leader position in the data replication space.

Best Practices Generating WebService Proxies for Oracle Sales Cloud (Fusion CRM).

  [Read more...]
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...]
    Previous 30 Newer Entries Showing entries 91 to 120 of 1377 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.