Planet MySQL

MySQL University: Speakers for 2010 wanted!

+0

-0

posted by Stefan Hinz on Tue 24 Nov 2009 10:08 UTC (Add To MySQL Librarian)
Tags:

(edit) sun, mysql, sessions, speakers, university

We'll soon have our last MySQL University session for this year, followed by a winter break until the end of January 2010. So far there's only one session scheduled next year, but we'd like to have one session per week, so we need lots more speakers!

Anyone who has something technical to say about MySQL qualifies as a speaker. MySQL University sessions take place on Thursday afternoons European time, and normally have between 20 and 30 attendees, but quite a lot of people listen to the recordings when the live session time isn't convenient for them. We're using Dimdim as our conferencing system, so the setup for speakers is very simple: Just grab a headset,

[Read more...]

Windows XP -> Cloud -> Windows 7

+0

-0

posted by Zmanda Team Blog on Tue 24 Nov 2009 07:36 UTC (Add To MySQL Librarian)
Tags:

(edit) Chander Kant, Cloud Backup, Network Backup and Recovery, Paddy Sreenivasan

We recently added support for Windows 7 to both Zmanda Cloud Backup and Amanda Enterprise. Zmanda Cloud Backup stores its backup archives on the Amazon S3 Storage Cloud. Amanda Enterprise has the option to do so. Users can backup both the Windows file systems and system state, as well as various Microsoft applications, Oracle and MySQL databases. Now we support all Windows versions supported by Microsoft, including Windows 7.

To upgrade from Windows XP to Windows 7, Microsoft recommends users to backup their Windows XP to external hard disk and then install Windows 7. Backup to (and Restore from) Cloud offers another

+0

-0

posted by Lachlan Mulcahy of team blog MySQL Support Team on Tue 24 Nov 2009 02:30 UTC (Add To MySQL Librarian)
Tags:

(edit) sun, balance, load, mysql, proxy

A customer had come to us this week asking about some of the functionality in the ro-balance.lua script that ships with MySQL Proxy. As I investigated things further, I came to realise that due to some changes in the 0.7.x series, the script was broken.

Being the helpful fellow I am, I updated the ro-balance.lua script so that it works again. I also ended up making some nifty improvements...

For those of you unfamiliar with the ro-balance.lua script, it is designed to do the following:

proxy new connections to a pool of slaves
periodically check that slave IO thread is running and slave has not fallen too far behind
take slaves determined to be offline or otherwise unfit for use (see above) out of the pool
fall back to the master server if no slaves are available at all

+0

-0

posted by Everything MySQL on Tue 24 Nov 2009 00:30 UTC (Add To MySQL Librarian)
Tags:

(edit)

A lot of the time I have found that the only available backup taken from mysqldump contains all databases. This is ok but can be a head ache if you only need to restore one or some of the tables in one database. Below is a good way to restore only that which needs to be restored. I have created three tables in the test database, truncated the third table and now need to restore just that table.

-- Example:

mysql> select database();
+------------+
| database() |
+------------+
| test |
+------------+
1 row in set (0.00 sec)

mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| tbl1 |
| tbl2 |
| tbl3 |
+----------------+
3 rows in set (0.00 sec)

mysql> select min(anum), max(anum) from

[Read more...]

Pluggable Database Client Tool

+0

-0

posted by Eric Day on Mon 23 Nov 2009 22:11 UTC (Add To MySQL Librarian)
Tags:

(edit) drizzle, Main, mysql

A few weeks ago I wrote about a student group who will be working with the Drizzle community to build a new database client tool. While the tool will be the primary replacement for the Drizzle client tool, we hope it will be generic (using the Python DB API) so it will work with others like MySQL and PostgreSQL. We’ve had a number of great discussions, including a session at OpenSQL camp last weekend. I wanted to toss out a few ideas of how such a tool could be structured to allow for maximum extensibility.

One possibility is to borrow from typical Unix shells and DSP processing systems where you have a number of modules with I/O interfaces and data exchange formats between each module. Each module provides a specific signature so you know what other modules it can plug into. Here is a simple example:

[Read more...]

NoSQL vs MySQL

+0

-0

posted by Kris Buytaert on Mon 23 Nov 2009 20:17 UTC (Add To MySQL Librarian)
Tags:

(edit) dns, dnsproblem, mysql, NoSQL

No I did NOT post the following comment

This is ridiculous. You didn't test MySQL, you tested a failing DNS lookup on authentication.

resulting in the follow up post :

My previous post Redis, Memcache, Tokyp Tyrant, MySQL comparison had a flaw as pointed out by this comment. The MySQL was taking a huge time for doing a reverse DNS lookup.

But as always ... Everything is just a Freaking dns problem :)

Technorati Tags: dns dnsproblem

[Read more...]

Fast UNION support now in InfiniDB

+3

-0

posted by Robin Schumacher of team blog Calpont & InfiniDB Project Team on Mon 23 Nov 2009 18:23 UTC (Add To MySQL Librarian)
Tags:

(edit)

While at MySQL, one of the complaints I used to receive every now and then had to do with MySQL’s performance in the area of UNION’s. I distinctly remember one user group meeting where folks from one government agency told me they couldn’t use UNION at all in their application because the performance was so slow.

Now this isn’t always the case with MySQL, but I’ll admit I have seen bad speed on some UNION queries. And that’s one of the reasons I&rsquRead More...

MySQL University: The Spider Storage Engine

+0

-0

posted by Stefan Hinz on Mon 23 Nov 2009 16:56 UTC (Add To MySQL Librarian)
Tags:

(edit) sun, engine, mysql, plugins, sharding, spider, storage, university

This Thursday (November 26th, 14:00 UTC), Giuseppe Maxia will present the Spider Storage Engine. This session was originally scheduled for October 15th but had to be postponed for technical reasons.

Here's from the abstract: Everybody needs sharding. Which is not easy to maintain. Being tied to the application layer, sharding is hard to export and to interact with. The Spider storage engine, a plugin for MySQL 5.1 and later, solves the problem in a transparent way. It is an extension of partitioning. Using this engine,

+1

-0

posted by The 451 Group on Mon 23 Nov 2009 13:18 UTC (Add To MySQL Librarian)
Tags:

(edit) Business models, Licensing, 451 group, 451caostheory, 451group, affero, Affero GPL, Azure, caostheory, Google, gpl, Linux, matt aslett, mattaslett, matthew aslett, matthewaslett, mysql, open-source, opensource, The 451 Group, the451group

A number of people have recently raised the issue of the threat that cloud computing poses to the monetization of open source by specialist vendors, including Savio Rodrigues, Matt Asay, and Mike Hogan.

I believe that cloud computing provides an opportunity for open source specialists, but agree that cloud services based on open source code could potentially eat into the business opportunities for open source specialists since the cloud providers have no requirements

+0

-0

posted by Ruturaj Vartak on Mon 23 Nov 2009 12:32 UTC (Add To MySQL Librarian)
Tags:

(edit) innodb, myisam, mysql

My previous post Redis, Memcache, Tokyp Tyrant, MySQL comparison had a flaw as pointed out by this comment. The MySQL was taking a huge time for doing a reverse DNS lookup.

I turned on the skip-name-resolve parameter in the my.cnf and the Throughput of MySQL grew considerably, almost more than double.

My swap space on an SSD?

+0

-0

posted by Thierry Manfé on Mon 23 Nov 2009 09:44 UTC (Add To MySQL Librarian)
Tags:

(edit) Technology Tid Bits, ssd, swap, zfs

I had an interesting discussion with 2 colleagues about the possible interest of putting the swap space of a system on a SSD.

If I consider the gain in latency that an SSD brings versus a capacity disk - in the region of 100x - the solution seems obvious. Swapping - or more precisely paging - must be much faster/ with an SSD. Since RAM is expensive versus SSD, I could even be tempted to design a system with a small amount of RAM and a large amount of swap space on SSDs. In other words, I can ask myself if trying to prevent my system to page is still a good fight?

Let's try to shed some light on these questions.

Paging takes place when my system runs out of RAM because more processes are created or because existing processes requires more memory (check this

+1

-0

posted by Philip Tellis on Mon 23 Nov 2009 08:39 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql, Internet, ip address, database

For a lot of log processing, I need to store IP addresses in a database table. The standard process was always to convert it to an unsigned int in perl or php and then insert it. Today I discovered an easier way. MySQL's INET_ATON function. It takes an address in dotted quad format and converts it into an INT. So, all you have to do is this:

INSERT INTO table (ip) VALUES (INET_ATON('$ip_address'));

And done.

Connector/MXJ 5.0 (GA 5.0.11, published on Monday, 23 Nov 2009)

+0

-0

posted by MySQL on Mon 23 Nov 2009 00:00 UTC (Add To MySQL Librarian)
Tags:

(edit)

Connector/MXJ 5.0 (GA 5.0.11, published on Monday, 23 Nov 2009)

FORUM PHP 2009 PARIS

+1

-0

posted by Serge Frezefond on Sun 22 Nov 2009 21:30 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql

rance FORUM PHP 2009 was held last week in Paris (12th and 13th nov) at Cite des sciences et de l'industrie Thanks to LeMuG (the french MySQL User Group) MySQL has had a nice set of presentations : Michael Widenius aka Monty ( Monty Program Ab ) presented "MariaDB, the future of MySQL". Johannes Schluter (MySQL connectors dev team + release manager of PHP 5.3) has presented "PHP and MySQL - A good match" This was the closing presentation for the 2 days but audience stayed to hear about the nice functionalities of the mysqlnd driver. A lot of interest for the new features (some experimental) : persistent connections, performance statistics, asynchronous request, client side cache, streams + filter, statistics collection, PDO + mysqlnd good match.

Watching the Retweeted Get Retweeted-er: Power User Secret Retweetist Love

+0

-3

posted by Tim O'Reilly on Sun 22 Nov 2009 16:14 UTC (Add To MySQL Librarian)
Tags:

(edit)

When Twitter decided to slowly roll out a new, official retweeting feature, people waited in anticipation. When they let their users know what it might look like, people debated whether that was the right way to deploy it. When it actually became available, people almost universally disliked it.

But my post is about why I love the new Twitter retweet feature, without ever having to think about it. The reason is that official retweeting represents the new-new arms race for authority among power users. The new-new arms race, you

+4

-0

posted by Geert Vanderkelen of team blog MySQL Support Team on Sun 22 Nov 2009 09:25 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql, macos

What you do when you're fed up with a script? Right, you write your own.

You'll have to excuse me for the long shell script you'll find here below, but I'm not going to bother putting it on some download website.

It's a shell script which starts and stops the MySQL server. Indeed, a replacement for the init.d script found in the MySQL distributions. I'm using it personally on my Macs and it's not supported in any way.

But why? Well, I'm playing with MySQL Workbench, Server Administration. The MySQL init.d script didn't work right away (oh, various reasons for that), so I used mine. So I figured it might be useful for others and it's not complicated or shocking-new-stuff.

If you want to use it,

[Read more...]

MySQL Performance Blog was down today

+1

-2

posted by MySQL Performance Blog on Sun 22 Nov 2009 06:16 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql

MySQL Performance Blog (and percona.com too) were down today because the switch in our rack died completely. It took a while to fix it using secondary switch we had. Provider was not willing to do it as remote hands so I had to drive to the data center to fix it.

We got number of calls and messages from the customers and friends about web site going down so we probably have to invest into getting infrastructure more redundant – currently we were quite cheap and a lot of servers have single network card (so you can’t use trunking to eliminate switch as single point of failure).

The customer case management systems were not affected by this outage.

Entry posted by peter |

+1

-0

posted by The Aquarium on Sun 22 Nov 2009 02:36 UTC (Add To MySQL Librarian)
Tags:

(edit) Weekly, adoption, devoxx, EU, glassfish, godot, hudson, Oracle, v3

Today is Nov 21th, 2009.

News shorts of interest to our communities, including:
New date for EU review of Oracle/Sun acquisition, getting closer to v3 fcs, new OpenESB and OpenDS releases, Devoxx whiteboards, new customers and japanese event, and more.

Waiting for Godot
I read Waiting for Godot for HS, but I didn't expect to live it...

+1

-0

posted by Luca Olivari on Sat 21 Nov 2009 14:42 UTC (Add To MySQL Librarian)
Tags:

(edit) mysql, Events, opensource, business intelligence

On the 18th of November we've hold in Milan an event focused on Open Source Data Warehousing.

For many organizations, data warehouses are simply too costly to buy, too costly to implement and too costly to maintain. Data warehousing is still a luxury of deep-pocketed organizations, although the resulting benefits can be virtually reaped by companies of all sizes.
Open Source Software is changing the rules again, lowering the economic barriers to undertake Business Intelligence and Data Warehousing projects.

During the event we proved that MySQL can help organizations to achieve higher ROI on their projects. With the support of our partners, Infobright and Talend, we showed how to design, deploy and manage a multi-terabyte Data

[Read more...]

Josh Berkus helps clarify clustering

+1

-1

posted by Baron Schwartz (xaprb) on Sat 21 Nov 2009 13:57 UTC (Add To MySQL Librarian)
Tags:

(edit) postgresql, sql, Clustering, josh berkus, mysql-cluster

If you haven’t seen it, Josh Berkus has a very concise way to look at the confusing mess that is database “clustering” from the point of view of three distinct types of users: transactional, analytic, and online. I think that using this kind of distinction could help keep discussions clear — I’ve seen a lot of conversations around clustering run off the rails due to disagreements about what clustering means. MySQL Cluster, for example, is a huge red herring for a lot of people, but it seems to be a difficult process to learn it well enough to decide. If we called it a clustering solution for transactional users, but not for analytic or online users, it might help a lot.

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

Top 20 Most Active Authors

Top 10 Most Active Team Blogs

MySQL Links

Other Links

Planetarium