Community journal

The latest from the MySQL community

Ideas, releases, practical guides, and perspectives from the people building with MySQL.

Follow the feed
Showing entries 32291 to 32300 of 45498 « Previous | Next »
Developing Kenai - Agility on an OpenSource Enterprise Foundation

Last week Kenai went beta, with the usual services in a development hub site plus an additional "connected" angle. Our GF CORBA project is already using its Hg repository but another very interesting angle is the technology mix.

Kenai acheived development agility with reliability by using a combination of our scripting (JRuby/Rails) and enterprise (GlassFish v2, MySQL, OpenSolaris) technologies. These combinations are beginning to pop all over and are one of the key targets of …

[Read more]
Every DBA's Nightmare -- Got backups?

Here's a wakeup call to all the good folks on planet MySQL :

Denver Post: Gone: Comments...


Today's a great day to:

1) Review your backup logs.
2) Perform a recovery drill on a development server.
3) Validate the backed up data by running checksums, comparing tables or file sizes, etc.

Every DBA's Nightmare -- Got backups?

Here's a wakeup call to all the good folks on planet MySQL :

Denver Post: Gone: Comments...


Today's a great day to:

1) Review your backup logs.
2) Perform a recovery drill on a development server.
3) Validate the backed up data by running checksums, comparing tables or file sizes, etc.

Migrating from MySQL 4.1 to 5.x

Suppose I have around 30 servers with MySQL 4.1 each with up to 1Tb of MyISAM tables. We need to upgrade their OS to support new hardware. We want to upgrade to 64-bit architecture to use the hardware efficiently.

Upgrading to 5.x seems like a good idea, as the additional validation work will be the same as would have to be done anyway - so we could effectively upgrade our MySQL version "for free", i.e. no additional QA work would be required than would be needed anyway.

Upgrading at any other time would involve a repetition of the validation exercise, which is not trivial as we must test at least:

  • All features of the complex application which use these databases still work without errors
  • The behaviour of the new version is consistent with the old one (e.g. results returned)
  • Performance needs to be measured to ensure that performance regressions haven't happened (or …
[Read more]
Preisausschreiben: 10 mal »XAMPP kompakt«

»XAMPP kompakt« aus dem Bomots-Verlag war das erste Buch, das sich ausschließlich mit XAMPP beschäftigt und Einsteigern einen ersten umfassenden Blick in die Webserver-Welt geboten hat.

Jetzt ist es in einer aktualisierten und erweiterten Neuauflage erschienen und der Autor Holger Reibold war so freundlich uns ein paar Belegexemplare zur Verfügung zu stellen.

Diese wollen wir natürlich nicht nur für uns behalten und verlosen daher 10 dieser Exemplare unter allen interessierten XAMPP-Nutzern.

Als kleines Bonbon gibt es für die ersten drei Plätze auch noch jeweils eines unserer überaus begehrten XAMPP-T-Shirts mit dem AMPP-Motiv auf der Rückseite.

Zum »XAMPP kompakt«-Preisausschreiben

learn2scale - what’s up with Malaysian news sites? Will the cloud work for them?

Seriously kids, what’s with the lack of scalability? I’ve never seen CNN or the NYTimes go down on “trimmed” versions.

Is it a question of bandwidth? Is it lack of hardware?



Take for example, Malaysiakini (the first alternative news source in Malaysia, with a subscription model built around it). It runs FreeBSD, uses PostgreSQL, and has a CMS on top of it (so almost a LAMP stack right there). There’s even use of Squid for caching. Yet there’s lacking load balancing? This is where the cloud can come into play, when there’s high traffic.



Next up, …

[Read more]
Advanced Bazaar for MySQL developers

The MySQL project switched from Bitkeeper to another revision control system, Bazaar, in June 2008. My colleague Daniel Fischer wrote an excellent article describing how to get MySQL's code by using Bazaar, and how to compile a MySQL server binary from this. Here I am going to build on this knowledge and take it further, to show you how to modify MySQL's code for your needs, and share your modifications.

Bringing Open Source Replication to the Oracle World

Replication is one of the most useful but also also one of the most arcane database technologies. Every real database has it in some form. Despite ubiquity, replication is complex to use and in the case of commercial databases quite expensive to boot.

We aim to change that. On Tuesday we will be announcing replication support for Oracle. Oracle replication will be based on our open source Tungsten Replicator, which is currently available in an alpha version for MySQL. Our goal is to provide replication that is accessible and usable by a wide range of users, especially those running lower-cost Oracle editions.

It's not a coincidence that we chose to implement MySQL and Oracle …

[Read more]
Growth and change at SpringSource

While revenue doubled year-on-year, did growth come from professional services or products/support? And where is Neelan heading off to? READ MORE

Appcelerator switches from GPL to Apache to boost adoption

We've seen a groundswell of support for the GNU General Public License (GPL) and its variants among commercial open-source companies, including MySQL, Funambol, Alfresco, SugarCRM, and others. But Appcelerator is bucking the trend and changing from the GPL to the Apache Public License for its Rich Internet Application developer ...