Showing entries 601 to 610 of 1627
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: Oracle (reset)
Verifying a Socket w/Perl

Using a lowercase hostname is typical but I got sloppy on a Windows 7 installation, after all Windows is case insensitive, and I used a mixed case hostname. It raised an interesting error when installing Oracle Database 11g Release 2.

Enterprise manager configuration failed due to the following error -

Failed to allocate port(s) in the specified range(s) for the following process(es): JMS
[5540-5559], RMI [5520-5539], Database Control [5500-5519], EM Agent [3938] | [1830-1849]

Refer to the log file at C:\app\McLaughlinM\cfgtoollogs\dbca\orcl\emConfig.log for more details.

You can retry configuring this database with Enterprise Manager later by manually running C:\app\McLaughlinM\product\11.2.0\dbhome_1\bin\emca script.

After verifying the ports …

[Read more]
MySQL 5.6 replication gotchas (and bugs)

There has been a lot of talk about MySQL 5.6 replication improvements. With few exceptions, what I have seen was either marketing messages or hearsay. This means that few people have really tried out the new features to see whether they meet the users needs.

As usual, I did try the new version in my environment. I like to form my own opinion based on experiments, and so I have been trying out these features since they have appeared in early milestones.

What follows is a list of (potentially) surprising results that you may get when using MySQL 5.6.
All the examples are made using MySQL 5.6.6.

Gotcha #1 : too much noise

I have already mentioned that MySQL 5.6 is too verbose when creating data directory. This also means that your error log may have way more information than you'd like to get. …

[Read more]
Parallel backup in MySQL Enterprise Backup v3.8.0

MySQL Enterprise Backup (MEB) supports backup and copyback of mysql database objects into/from different disks or tape drives. On backup, MEB reads the data from the disk, processes it in form of validation or compression(if requested by user) and writes to disk. These operations were performed in a serial fashion till 3.7.1, wherein the reading of data is completed, followed by processing, and then writing. The performance of this can be increased by pipelining the read, process and write operations to be run in parallel, and this is what exactly is done in the latest release MEB 3.8.0 so as to reduce the time taken for all kinds of backups and restore operations.

How does this pipeline parallelism work?

This pipelined parallel execution of read, process(if any) and write operations is achieved by invoking multiple threads for different operations and usage of buffers. Each operation is split into segments and threads …

[Read more]
The Data Charmer: Is Oracle really killing MySQL?

http://datacharmer.blogspot.it/2012/08/is-oracle-really-killing-mysql.html

An insightful post for my former  (MySQL AB) colleague Giuseppe Maxia about how Oracle’s actions affect the MySQL landscape.

My own comment exploring why it’s happening (from Upstarta perspective) is on his blog post rather than here. From Open Query’s business perspective, we generally deploy MariaDB unless client prefers distro stock. We get the features we need in MariaDB, see the bugfixing and have an open dialog with the developers and see the development process.

While the current new code coming from Oracle definitely has interesting components, MariaDB has solved some real problems (such as subqueries), and integrated useful engines such as Sphinx, FederatedX, and our on …

[Read more]
Is Oracle really killing MySQL?

There are plenty of "Oracle-is-killing-MySQL" headlines in the tech world:

Is Oracle really consciously and willingly killing MySQL?

I don't think so.

Is Oracle damaging MySQL by taking the wrong steps? Probably so.

This is my personal opinion, and AFAIK there is no official statement from Oracle on this matter, but I think I can summarize the Oracle standpoint as follows:

  • There is a strong and …
[Read more]
Log Buffer #282, A Carnival of the Vanities for DBAs

Blogging is the way to express an idea in an informal way by a person, who has either worked with it, or planning to work with it, or has seen it at work. In databases, ideas are the foundations of everything, and these Log Buffer Edition is presenting ideas from bloggers in Log Buffer #282. [...]

Interview with Giuseppe Maxia "the datacharmer" about MySQL Connect

Keith Larson: Thank you for allowing me to do this interview with you. What have you and Continuent been up to lately?

Giuseppe Maxia:  Hi Keith. It's my pleasure.  I (and the whole team at Continuent) have been quite busy releasing version 1.5.1 of our flagship clustering and HA product, Tungsten Enterprise. Apart from the pleasure of the growing business that makes us all very happy, we enjoy the rare geeky joy of working at a product at the highest levels of innovation and technical effectiveness.


 I am also happy, at a personal level, because my current job keeps me in touch with the MySQL community. The products that we develop, both the open source and the commercial solutions, depend heavily on the ubiquity of MySQL. When I dedicate some time to the MySQL community, I am doing at the same time something that I like and that is ultimately beneficial for my company's business. For this reason, my …

[Read more]
Log Buffer #281, A Carnival of the Vanities for DBAs

The Log Buffer Edition is one-stop joint to know about the latest blog entries regarding the database technologies like Oracle, MySQL, and SQL Server. Enjoy this Log Buffer #281. Oracle: Whilst working with Oracle BPM Process Composer, Andrew began to receive the following error when opening projects. Christian Screen is moving ODBC DSNs from source [...]

MySQL Connector/Net 6.6.1 Alpha 2 has been released

 MySQL Connector/Net 6.6.1, a new version of the all-managed .NET driver for MySQL has been released.  This is the second of two alpha releases intended to introduce users to the new features in the release.  This release is not feature complete and there are limitations but it should be stable enough for users to understand the new features and how we expect them to work.  As is the case with all non-GA releases, it should not be used in any production environment.  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.)

[Read more]
MySQL Connector/Python 1.0.5 beta available through PyPI

Yesterday we announced the availability of MySQL Connector/Python v1.0.5 beta. Today I’ve made it available on PyPI so it can be easily installed. Note that I did remove the old development release and when you upgrade or try v1.0.5, you should check the ChangeLog.

shell> pip install mysql-connector-python

For those wondering why the name includes ‘python’: it’s just to align it with other MySQL connectors and to keep the name consistent with other distribution types.

We welcome and appreciate feedback and comments for this first beta release through the forum and the …

[Read more]
Showing entries 601 to 610 of 1627
« 10 Newer Entries | 10 Older Entries »