PlanetMysql.ru — информация о СУБД MySQL

I will present on "Testing LAMP Applications" at the O'Reilly MySQL Conference & Expo 2011:

Proper interaction with relational databases is incredibly important in most pieces of software. The importance of this interaction is underscored by the fact that many software architectures have at least one entire layer or system devoted to data persistence and data loading. When dealing with critical data in enterprise level applications it becomes even more important to make sure your data is being stored and retrieved correctly.

As responsible developers, one of our goals should be to test database interaction and test it well. To help achieve this goal, we will take a close look at tools and techniques that can be used with projects of any size to help create reliable tests capable of validating your database interaction.

The discussion will begin with various techniques for testing your database layer. The focus will then move toward the functionality in the database extension for PHPUnit. Then, utilizing the tools provided in the database extension, examples will be given of how to create basic tests validating that the database is correctly manipulated and data from your database is successfully retrieved. This will be followed by an in depth discussion of "best practices" that can be utilized when you are developing "database aware" fixtures and tests.

Once the ground work is laid, we will look at how all of these tools and techniques can be utilized in both your unit tests and functional tests.

And in case you're wondering: I reused the abstract text from the description of Michael Lively's case study for Real-World Solutions for Developing High-Quality PHP Frameworks and Applications which should be out by the time of the conference.

See you in Santa Clara, CA in April!

PlanetMySQL Voting: Vote UP / Vote DOWN

I’ll be going to foss.in this year, and am totally excited (the last time I spoke there was in 2007 – Paying it Forward: Harnessing the MySQL Contributory Resources – where I talked about moving from BitKeeper to Bazaar, using Launchpad, the MySQL Forge, and more). This time around, I will be giving a talk titled: MariaDB: The new M in LAMP. I feel a little nostalgia, because the MySQL ecosystem has evolved a lot since December 2007.

The database crew is going to be strong there, as we also have Gary Pendergast, my friend from MySQL (now Oracle) giving a talk titled: Tuning MySQL for Performance, Stability and Fail Safety.

We figured we’d have some kind of meetup, either over chai or if we can find space to have a little database BoF. If you have any questions, queries, etc. about MariaDB or MySQL, don’t hesitate to find either one of us. If you would like to meetup, shoot me an email: colin[at]montyprogram[dot]com.

foss.in is happening December 15-17 2010 in Bangalore, India. Register now, if you haven’t already. See you there next week!

P/S: I will be there with some Salmiakkikossu to keep the tradition alive!

Related posts:

1. foss.in 2007
2. Opportunities to talk MariaDB/MySQL in Manila, Philippines
3. Using MariaDB in production?

PlanetMySQL Voting: Vote UP / Vote DOWN

As a follow up of this post I'd like to inform all the readers that the What's New event will be replicated in Rome on Oct, 7.

Join us at this live event to better understand what’s new with MySQL. You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle’s investment in MySQL aiming to make it even a better MySQL.

In particular the following topics will be discussed:

• Oracle’s MySQL Strategy
• What’s New for:
• The MySQL Server
• MySQL Cluster
• MySQL Enterprise
• MySQL Workbench

• October 7, 2010: 9:30am in Rome - Register here.

PlanetMySQL Voting: Vote UP / Vote DOWN

As a follow up of this post I'd like to inform all the readers that the What's New event will be replicated in Rome on Oct, 7.

Join us at this live event to better understand what’s new with MySQL. You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle’s investment in MySQL aiming to make it even a better MySQL.

In particular the following topics will be discussed:

• Oracle’s MySQL Strategy
• What’s New for:
• The MySQL Server
• MySQL Cluster
• MySQL Enterprise
• MySQL Workbench

• October 7, 2010: 9:30am in Rome - Register here.

PlanetMySQL Voting: Vote UP / Vote DOWN

Join us at this live event in Milan to better understand what’s new with MySQL. You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle’s investment in MySQL aiming to make it even a better MySQL.

In particular the following topics will be discussed:

• Oracle’s MySQL Strategy
• What’s New for:
• The MySQL Server
• MySQL Cluster
• MySQL Enterprise
• MySQL Workbench

• September 28, 2010: 9:30am in Milan - Register here.

PlanetMySQL Voting: Vote UP / Vote DOWN

If you like to keep your ddl backed up in some source management tool like svn or cvs and want to do it individually for stored procedures, events, triggers, tables and such rather than having a single file you can easily do so using the below. You could even include the –skip-dump-date or –skip-comments and use the below to compare ddl daily checking for alterations thus making sure you are aware of any ddl changes done on the database.

user=backup_user
password=`cat ~/.backup_password`
hostname=127.0.0.1
port=3306
dbname=test_db
path=/home/mysql/ddl
date=`date +%Y%m%d`

mysqldump -u$user -p$password -h$hostname -P$port --no-create-info --no-data --no-create-db --skip-opt $dbname > "$path"/"$dbname"_triggers_"$date".sql
mysqldump -u$user -p$password -h$hostname -P$port --routines --skip-triggers --no-create-info --no-data --no-create-db --skip-opt $dbname > "$path"/"$dbname"_routines_"$date".sql
mysqldump -u$user -p$password -h$hostname -P$port --events --skip-triggers --no-create-info --no-data --no-create-db --skip-opt $dbname > "$path"/"$dbname"_events_"$date".sql
mysqldump -u$user -p$password -h$hostname -P$port --skip-triggers --no-data --no-create-db --skip-opt $dbname > "$path"/"$dbname"_tables_"$date".sql

PlanetMySQL Voting: Vote UP / Vote DOWN

1. Common MySQL Queries -- a useful reference.
2. MySociety's Next 12 Months -- two new projects, FixMyTransport and "Project Fosbury". The latter is a more general tool to help people organise their own campaigns for change.
3. riak -- scalable key-value store with JSON interface. (via joshua on Delicious)
4. Notes from NoSQL Live Boston -- full of juicy nuggets of info from the NoSQL conference.

PlanetMySQL Voting: Vote UP / Vote DOWN

On Feb 10, 2010 we've held an event in Milan, explaining why MySQL and Java are the most popular development platforms.

Our annual MySQL User Survey conducted in early 2009 showed that 57%  of those surveyed use Java to develop their MySQL applications.

My speech was all about MySQL and its usage from Java applications with various connectors. I explained the capabilities of Connector/J and Connector/MXJ, you can see relevant on demand webinars here.

After that, I moved to the usage of MySQL Cluster from Java applications, elucidating the three types of connectivity available. If you want to see for yourself then take a look at the blog post by my colleague Bernhard or hurry up and register for the upcoming webinars.

If you are a Java developer, don't forget to look at the Java page on our website alongside the developer portal.

PlanetMySQL Voting: Vote UP / Vote DOWN

Am kommenden Donnerstag, den 11.02.2010 findet wieder ein öffentlicher Vortrag im Mayflower Büro in Würzburg statt (Pleichertorstrasse 2, 97070 Würzburg, Straßenbahn und die Haltestelle Congress Centrum).
Beginn ist um 18:00 Uhr, Thema des Vortrags ist "Praktische Anwendung von MySQLDumper".

Intelligentes Backup-Management bei MySQL-Datenbanken? Kein Problem, denn mit dem MySQLDumper kann jeder Sicherungskopien seiner wichtiger Datenbestände erstellen - und bei Bedarf auch kinderleicht wieder herstellen. Daniel Schlichtholz zeigt wie MySQLDumper einem das Leben erleichtert. Frei nach dem Motto: back it up the easy way...

Die "Donnerstags-Vorträge" werden sowohl in Würzburg als auch in München gehalten. Bei Interesse einfach das Blog beobachten, um auf dem Laufenden zu bleiben!
Wir freuen uns auf viele Teilnehmer!


Größere Kartenansicht
PlanetMySQL Voting: Vote UP / Vote DOWN

LinuxTag is the most important place for Linux and open source software in Europe. Last year, LinuxTag had over ten thousand attendees, and over 300 speakers. This year, the 16th LinuxTag will be June 9-12, 2010 at the Berlin Fairgrounds in Germany.

LinuxTag seeks exciting and suitable proposals for presentations in the conference tracks. The Call for Papers ends today.

I am proud to be a member of the LinuxTag Program Committee. Although a lot of proposals have already been submitted, there are some topics missing that I’d personally like to see covered. So, if you’re up for a last minute submission, get your inspiration from the following list:

• Is/was the recent economic crisis an opportunity for Open Source?
• More real-life case studies on how OSS is being used in mission-critical scenarios.
• A European or global perspective on Open Source in Public Administration.
• How to make use of Amazon EC2 or Google AppEngine with Open Source apps?
• Technical tutorials for beginners, especially for building Web apps (e.g. PHP/Ruby/Java/etc. for beginners).
• High performance Web environments with Open Source tools
• Security in the Cloud
• What’s the status of some of the regional Linux distributions?

I can’t promise that your talk will be accepted if it covered one of the above topics. The review process is of course a joint effort of the whole Program Committee. Anyway, it’s definitely worth a try. Of course, any other topic I did not think of is also highly welcome.

Go here to submit your LinuxTag proposal.

PlanetMySQL Voting: Vote UP / Vote DOWN