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 32656 to 32665 of 45463 « Previous | Next »
Aug
19
2008
The key to accessing your data: MySQL Connectors and bindings for various languages
Posted by Lenz Grimmer on Tue 19 Aug 2008 16:31 UTC
Tags:

Being able to use an Open Source DBMS to manage your data is nice, but what good would it be if you can't easily access it from your applications? One key factor to the popularity of MySQL is probably its wide range of available language bindings, which started with support for C, PHP and Perl from early on.

I've tried to gather a list of languages and their respective MySQL drivers/modules below. It's by no means complete or exhaustive, but I think I covered quite a lot of popular as well as exotic programming languages.

There is a number of connectors which are actually developed by the Sun Database Group (aka MySQL) itself and that are ready to use:

  • Connector/ODBC - Standardized database driver Windows, Linux, Mac OS X, and Unix platforms.
  • …
[Read more]
Aug
19
2008
Last Week For Database Survey
Posted by Lewis Cunningham on Tue 19 Aug 2008 14:15 UTC
Tags:

This is the last week to participate in a database usage survey. If you haven't already done so, please take a few minutes to answer 25 questions.

LewisC

Technorati : database, mysql, survey

Aug
19
2008
PHP to Javascript | Hyperlink Navigation
Posted by Varun Nischal on Tue 19 Aug 2008 09:56 UTC
Tags:

Wow, another surprise, did I miss something in release notes! I hunted again and again, I think I got the treasure first Actually, today I was again looking into PHP support, so thought of opening my first ever PHP application, I created using Dreamweaver 8, WAMPServer (which was actually my semester project) last December.

I was going through application’s index.php, which had embedded php scripts, and links to javascripts using following tags- 

<script type="text/javascript" src="styles/some_script.js"></script>

where styles/some_script.js is the script used, along with 2 more scripts. So, in body tag, there was a call to one of the functions belonging to one of the three .js files, like- 

<body onload="javascript:call_func();">

So, today I was thinking, it would be nice if I click on this function, and get directed …

[Read more]
Aug
19
2008
Using protobuf for designing and implementing replication in Drizzle
Posted by Mats Kindahl on Tue 19 Aug 2008 08:14 UTC
Tags:

So, following the lead of Brian, I spent a few hours of the weekend to create a very simple replication scheme for Drizzle using protobuf for specifying the binary log events.

Since we are developing a replication for a cloud, there are a few things we have to consider:

  • Servers are unreliable. We shall not trust server, but we shall expect them to crash at the worst possible time (Murphy is a very good friend of mine, you know. He must be, since he visits me very often.) This means that we need to have support to allow statements to be sent to the slaves before the transaction is complete, which means that we need to support …
[Read more]
Aug
19
2008
Worse than DDOS
Posted by MySQL Performance Blog on Tue 19 Aug 2008 06:55 UTC

Today I worked on rather interesting customer problem. Site was subject what was considered DDOS and solution was implemented to protect from it. However in addition to banning the intruders IPs it banned IPs of web services which were very actively used by the application which caused even worse problems by consuming all apache slots which were allocated to the problem. Here are couple of interesting lessons one can learn from it.

Implement proper error control In reality it took some time to find what was the issue because there was no error reporting for situation of unavailable web services. If log would be flooded with messages about web services being unavailable it would be much easier to find.

User Curl PHP Has a lot of functions which can accept URL as parameter and just fetch the data transparently for you. They however do not give you good error control and timeout management compared to …

[Read more]
Aug
19
2008
Week 12 - A Test Scheduler for the MySQL Build Farm Initiative
Posted by Charles Song on Tue 19 Aug 2008 03:04 UTC

KEY ACCOMPLISHMENTS LAST WEEK

  • Refactored and cleaned up source code.
  • Updated JavaDoc.
  • Uploaded source code to code.google.com.

KEY TASKS THAT STALLED LAST WEEK

  • Tried to upload source code to launchpad, but code.google.com was easier to use.

KEY CONCERNS

  • None

TASKS IN THE UPCOMING WEEK

  • Keep working on the project until the semester starts (Sept 2nd), at least.
  • Integrate all server side processing scripts and tools (Java, Perl, R, HTML).
  • Collect and analyze MySQL runtime information.
Aug
18
2008
first pass at a domain driven architecture
Posted by Si Chen on Mon 18 Aug 2008 23:12 UTC

We've completed the first pass of the new domain driven architecture, so I wanted to give you an update about how it works and tell you about some of the interesting things we found out along the way.

How It Works

The basic idea of the domain driven architecture is to separate your application's business logic from the underlying nuts and bolts, so that you can use several different applications interchangeably or migrate from one platform to another while preserving the essential core of your application. Another related goal is for you to be able to write business logic code in business terms, so instead of working with tables in a database or their equivalents, you can work with business concepts such as customers, orders, and invoices. Later, when someone else comes in to read your code, it will be easier for them to understand what you've done and help maintain it going forward.

To do this, we …

[Read more]
Aug
18
2008
mysqlbinlog Tips and Tricks
Posted by Nicklas Westerlund on Mon 18 Aug 2008 22:48 UTC
Tags:

So, you have a binlog. You want to find out something specific that happened inside of it. What to do? mysqlbinlog has some neat features, which I thought we would look at here.

I should first explain what mysqlbinlog really is. It is a tool that lets you analyze and view the binlogs/relaylogs from mysql, which are stored in binary format. This tool converts them to plaintext, so that they’re human-readable.

For the first tip, let’s start with the --read-from-remote-server option, which allows you to examine a binlog on a master server in order, perhaps, to dump it onto your slave and compare master/slave logs for potential problems*. 

$ mysqlbinlog --read-from-remote-server -uwesterlund -p mysql-bin.000001 -h 127.0.0.1 -P 3306 | head -5
Enter password:
/*!40019 SET …
[Read more]
Aug
18
2008
Running with Alexander Stubb
Posted by Kaj Arnö on Mon 18 Aug 2008 22:22 UTC
Tags:

On Saturday, I spent a couple of hours running with Alexander Stubb. No, Alex is not our newest recruit to the MySQL Support Team, he’s the Foreign Minister of Finland (the guy in the yellow T-shirt below).

But let me rewind to the beginning. I have been increasing my running to over 1200 km a year, and when I heard that the Münchner Stadtlauf half-marathon doesn’t crash with Finnish midsummer (something never to be missed), I registered for it and finished it in 1:45:58. And I calculated I would have a chance at going below four hours at a …

[Read more]
Aug
18
2008
GSoC Weekly Report - Week 10-12
Posted by Robert Vandermast on Mon 18 Aug 2008 21:42 UTC

Project: MySQL Forge RSS/Atom feeds

Note: I was on vacation for the last 2 weeks (10+11) and didn't have internet access, so this report is a little later than it should be.

KEY ACCOMPLISHMENTS LAST WEEKS

* Installing SeleniumRC.
* Writing basic SeleniumRC test script for the Forge.
* Writing PHPUnit tests for all HiPPo classes.

KEY TASKS THAT STALLED LAST WEEK

* None

KEY CONCERNS
* None

TASKS IN THE UPCOMING WEEK

* Prepare for extending the SeleniumRC test script to cover a larger part of the Forge.
* Submitting the Final Student Survey.

I would like to thank Google, MySQL and specially my mentor Jay for the opportunity to collaborate in the open source community and let me contribute something which will be useful in the future to many other open source hackers I hope.

« Previous | Next »