<?xml version="1.0" encoding="UTF-8"?><!-- generator="WordPress/2.9.2" -->
<rss version="0.92">
<channel>
	<title>Yuriy Zisin</title>
	<link>http://www.yzisin.com/blog</link>
	<description>Development as a lifestyle</description>
	<lastBuildDate>Sun, 28 Mar 2010 15:38:36 +0000</lastBuildDate>
	<docs>http://backend.userland.com/rss092</docs>
	<language>en</language>
	
	<item>
		<title>MySQL over SSH tunnel</title>
		<description><![CDATA[Sometimes we face a problem when we have SSH access to the server, but not to MySQL.
Here is a simple workaround - SSH tunnel:
ssh -f -N -L LOCAL_PORT:127.0.0.1:3306 USER@HOST
This command allows you to map remote port to the local one via SSH tunnel.

LOCAL_PORT - local port to map to
USER - SSH username
HOST - remote host

Surely, [...]]]></description>
		<link>http://www.yzisin.com/blog/?p=10</link>
			</item>
	<item>
		<title>Application semaphores using MySQL</title>
		<description><![CDATA[Many tasks require some application part to run in one instance per time, such as mail delivery cron job. And each time developers should invent some mechanism to determine if another copy is running. Usually no of these mechanisms are 100% reliable.
The solution is already found by MySQL development team. It is "named locks".
Application can [...]]]></description>
		<link>http://www.yzisin.com/blog/?p=9</link>
			</item>
	<item>
		<title>Broadcast messaging</title>
		<description><![CDATA[I've never tried to send and receive broadcast messages before, so I faced one fun problem. It's easy to open UDP socket and send broadcast message and there are lot examples you can find. It's also easy to find out how to catch the broadcast message. But what I did - I run sender and [...]]]></description>
		<link>http://www.yzisin.com/blog/?p=8</link>
			</item>
	<item>
		<title>PHP DOMDocument class and HTML entities</title>
		<description><![CDATA[DOMDocument class behaves strange sometimes. It could omit some entities like &#38;ldquo; and some valid UTF-8 characters (it also may do so for other encodings). This probably could be fixed by using own DTD, but there is a simple way too. Each HTML entity has its binary code, so DOMDocument will export your entities correctly [...]]]></description>
		<link>http://www.yzisin.com/blog/?p=7</link>
			</item>
	<item>
		<title>array_merge_recursive problem in PHP 5.2.5</title>
		<description><![CDATA[I faced a problem with Plugin Everywhere project some time ago. During the deep debugging I found that the code doesn't have any problem, but PHP had.
PHP 5.2.5 has a problem with array_merge_recursive function. It was grouping NULL values into the one. I even found this bug here. Plugin Manager uses that function for queues [...]]]></description>
		<link>http://www.yzisin.com/blog/?p=6</link>
			</item>
	<item>
		<title>Hello World!</title>
		<description><![CDATA[It’s a tradition. When someone starts studying programming discipline the first program usually outputs ‘Hello world’.
Keeping the tradition I start my blog by ‘Hello world!’ post  
Everything about me you can see at http://www.yzisin.com/, so just blog is here.
]]></description>
		<link>http://www.yzisin.com/blog/?p=5</link>
			</item>
</channel>
</rss>
