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

Displaying posts with tag: Oracle (reset)

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_Team +0 Vote Up -0Vote Down
This blog talks about MySQL Enterprise Backup integration with Workbench and how the Workbench UI can be used to configure and operate MEB.
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...]
    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_Team +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_Team +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_Team +0 Vote Up -0Vote Down

    Here are the slides for my talk at MySQL connect, 

    Backing up the MySQL Database.


    Previous 30 Newer Entries Showing entries 61 to 90 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.