Yes, there is a simple way to do this. Although it might not be
so simple unless you know how to do it, so let me show you how
this can be done. It's actually pretty cool. But I'll do this
over a number of blog posts, and this is just an introductory
blog, covering some of the core concepts and components.
But getting this to work wasn't easy, I had to try several things
before I got it right, and it's not really obvious how you make
it work at first, so this is a story along the lines of "If at
first you don't succeed mr Kidd" "Try and try again, mr
Wint" from my favorite villains in the Bond movie "Diamonds
are forever":
So, I had an idea of how to achieve replication from Oracle to
MySQL and I had an idea on how to implement it, and it was rather
simple, so why not try it.
So, part 1 then. Oracle has the ability to let you add a
UDF (User Defined Procedure) just like MariaDB (and
MySQL), …
In this blog post we are going to talk about one of the features included since MySQL for Excel 1.3.0.
Importing MySQL data into Excel is a common and important operation in MySQL for Excel. There may be times when you need to analyze the data stored in several MySQL tables or views, (possibly in an ExcelPivotTable which will be the subject of a future blog post), and to do it you need to dump the data into Excel as the first step. Starting with MySQL for Excel 1.3.0 we introduced a feature that allows you to import the data from multiple MySQL tables or views in a single operation.
Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the …
[Read more]It's been almost a year now since the initial release of MySQL Fabric. It is maturing and reached a GA state earlier this year as part of MySQL Utilities 1.4. Developers and architects are evaluating it for their applications, learning the capabilities of the system, and providing feedback for future features and usability enhancements. Connector/J has supported Fabric from the very beginning and continues to support the latest features. This blog post is an introductory level guide to using Fabric for high-availability from Java applications. Sharding features and Java APIs will be covered in a later post. The commands shown and feature descriptions are current for Fabric 1.5.1. In addition, Connector/J 5.1.32 and later support only Fabric 1.5 due to communication protocol differences from Fabric 1.4.
High-availability is a core concept in Fabric and is implemented by HA groups. An HA group is a set of servers configured with MySQL …
[Read more]
With MySQL Enterprise Backup(MEB) 3.9.0 we had introduced
full instance backup feature for cloning the
MySQL server. Now with MEB 3.11.0 we have enhanced the feature by
copying all the master-slave setup files like MySQL server binary
logs(will be referred as 'binlogs'), binary log index files,
relay logs of slave, relay log index files, master info of slave,
slave info files. As part of full instance backup, copying of
binlog files is default behavior MEB-3.11.0 onwards. DBA should
be aware of the fact that current full instance backup is bigger
than the backups with old MEB's.
As every event on MySQL production database goes as a entry to
binlog files in particular format, binlog files could be huge.
Backing of huge binlog and/or relaylog files should not impact
the performance of MySQL server. Hence, all the binlog files, …
Earlier this week I blogged about the MySQL Central @ OpenWorld tutorials. Let's focus today on the Hands-On Labs (HOLs), giving you the opportunity to get hands-on experience across a number of MySQL areas.
All HOLs will be held at the Nikko hotel. Here is the schedule:
Tuesday, September 30
DevOps Made Easy with MySQL Utilities
Charles Bell, Software Development Manager, Oracle - 10:15 AM - 11:15 AM Hotel Nikko - Bay View
Practical Introduction to MySQL Monitoring for Oracle Enterprise Manager Users
…
[Read more]If you want to install Oracle 12c on EL6 Linux Systems there are many pre-install steps that you should do before actually begin the database installation.
For ease Oracle provide as name states RPM package:
oracle-rdbms-server-12cR1-preinstall
But it is only for Oracle Linux from Oracle Public YUM
Repo.
Ofcourse you can activate this repo without trouble but in fact
problem of this RPM is dependency of Oracle Linux Kernel exactly
UEK. Output:
Installing: oracle-rdbms-server-12cR1-preinstall x86_64 1.0-8.el6 /oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64 37 k Installing for dependencies: compat-libcap1 x86_64 1.10-1 base 17 k compat-libstdc++-33 x86_64 3.2.3-69.el6 base 183 k kernel-uek …[Read more]
Are you using or interested in learning more about MySQL? Are you attending Oracle OpenWorld and looking for an opportunity to meet and exchange ideas or experiences with MySQL users?
Join us on Tuesday, September 30, 2014 to celebrate the dynamics and growth of the MySQL community. Whether you are attending MySQL Central @ OpenWorld, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in MySQL technology, you're all invited to Oracle's MySQL Community Reception.
- Mingle with your peers and learn from real-world experiences.
- Talk to MySQL engineers face-to-face and get the first-hand information on the latest product development.
Time: Tuesday, September 30, 2014 @ 7:00 p.m. - 9:00 p.m.
Location: Jillian's at Metreon …
[Read more]
Dear MySQL users,
MySQL Connector/Net 6.9.3 is the first GA release for the 6.9.x
series of the .NET driver for MySQL. It can be used for
production environments.
It is appropriate for use with MySQL server versions
5.5-5.7.
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites
(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.)
Enjoy and thanks for the support!
On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE
Team.
Introduction
Sometimes the best way to repair data issues and problems within a MySQL database is to restore only some of the tables from a backup. For example, suppose that some data was accidentally deleted from one table due to a software error, then the easiest way to recover the lost data might be to restore only one table from a backup. Previously this kind of partial restore was not supported by MySQL Enterprise Backup (MEB). However, MEB 3.11 introduces support for selective restore from backups created with the --use-tts option (or TTS backups).
TTS backups are backups that are created with the transportable tablespaces feature of InnoDB. These backups consist of InnoDB tables that …
[Read more]Continuent is delighted to announce an exciting Continuent Tungsten feature addition for MySQL users: replication in real-time from MySQL into Amazon RedShift.
In this webinar-on-demand we survey Continuent Tungsten capabilities for data warehouse loading, then zero in on practical details of setting up replication from MySQL into RedShift. We cover:
Introduction to real-time movement