Reminder: uc2004.vbmysql.com

2004-04-15 Thread mhillyer
Hello Everyone;

I thought I would take a chance to remind you all of the blog collection and
image gallery available at http://uc2004.vbmysql.com

We have had over 30 blog entries posted since the conference started, written by
several bloggers and encourage more to contribute. If you were not able to make
it to the conference this is shaping up to be a great resource for getting
session notes from the attendees.

Regards,
Mike Hillyer
www.vbmysql.com



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Ann: New Article on SSH Port Forwarding of MyODBC

2003-10-27 Thread mhillyer
Hi Everyone;

I have published a new article covering SSH port forwarding of MySQL sessions, 
which can be viewed at http://www.vbmysql.com/articles/sshtunnel.html

The article covers connecting a Windows client to a *NIX based server.

Anyone with previous experience will probably find the article redundant 
(although I would not mind feedback), but it should be useful for those without 
experience in port forwarding. In any case I hope you find it useful.

Regards,
Mike Hillyer
www.vbmysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



RE: New Article on SSH Port Forwarding of MyODBC

2003-10-27 Thread mhillyer
That is a pretty fair take on network traffic. SSH has strong enough encryption 
to make the decryption effort not worth it to all but those with 
supercomputers. As for the internal mail, I think we can agree that some mail 
would be critical enough to warrant encryption even on an internal network.

Mike

Quoting Adam Trimeloni [EMAIL PROTECTED]:

 
 Think of your information like a letter in the mail. Well, for this
 example,
 think of it even more as a post-card. Your message is written on the
 outside
 where the anyone that touches it can read it.
 
 This post-card is going through the post office. It is going through mail
 centers, hubs, etc. Whatever path it needs to take to get from point A to
 Point
 B. 
 
 At anyone of these post offices, if someone wants to read it, they just look
 at
 it, read it, then pass it along like normal. How would you ever know
 someone
 read it?
 
 Regular internet traffic is not encrypted, when you send a request, you send
 a
 written request like a post-card. Anyone in the middle could decide to read
 it. 
 If you encrypt it, then they may have a harder time reading it, they would
 have
 to decrypt it. Of course, with the encrypted message, they could say,
 photocopy
 your post card, pass the post-card along, then work on figuring out how to
 read
 it in their spare time. The better your encryption, the longer it would
 take
 them to figure out what it says. 
 
 But, say your mail system is all internal. You are sending mail from inside
 your
 building to inside your building. In this case, if the system is set up
 right,
 your mail will go from your office, to another office with-out ever leaving
 your
 building, which makes it much more secure. Someone in your own building
 would
 have to be devious enough to read your post-cards.(hopefully, your internal
 mail
 system would know not to send this message out to the normal post-office,
 just
 so the post-office will send it back to you)
 
 Anyway, that's my take on it.
 
 
 
 
 
 -- 
 MySQL ODBC Mailing List
 For list archives: http://lists.mysql.com/myodbc
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 
 
 





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Solaris Replication and IP Addresses - Known Issue?

2003-10-17 Thread mhillyer
Hi All,

I have been trying to assist in a replication problem with Solaris. Seems the 
problem came down to using an IP address in the CHANGE MASTER command. The 
Slave would not connect properly to a master defined by IP address, but when 
the IP was out in a hosts file and the hostname specified everything was fine.

See: http://www.experts-exchange.com/Databases/Mysql/Q_20767370.html

In addition, this issue is mentioned in a comment at 

http://www.mysql.com/doc/en/Replication_HOWTO.html

Posted by Juha Palomaki on Thursday September 18 2003, @11:18am 
I couldn't get the replication working on Solaris (SunOS 5.8) with MySQL MAX 
4.0.15 precompiled binary with IP addresses. When I tried to start the 
replication it was always complaining about not being able to login as 
[EMAIL PROTECTED] Everything started working after I put the IP address 
to /etc/hosts and put the name of the machine instead of IP address 
to /etc/my.cnf.

I do not use Solaris and cannot replicate this myself, but is this a known 
issue or should it go to bugs.mysql.com?

Regards,
Mike Hillyer
www.vbmysql.com








-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



New list mirror

2003-09-17 Thread mhillyer
Hi Everyone;

I have been experimenting with a new add-on for my VB/MySQL forums, and as a 
result I now have a new mirror for the general list. The mirror is available at 
http://www.vbmysql.com/forums/viewforum.php?f=17 but only took effect today, so 
there is not too much to search through yet. The add-on is still pretty rough 
around the edges but should soon allow posting to the list and replying to list 
messages, and I will add mirrors of more of the MySQL lists soon.

Does anyone know a way to get a dump of list messages to allow the mirror to 
search further back?

Regards,
Mike Hillyer
www.vbmysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Re: Question about InnoDB and external locking

2003-09-11 Thread mhillyer
Ok, here's another question. Given effective external locking by the OS, could 
MyISAM tables achieve this? If so, do you know any operating systems that would 
have reliable external locking?

Mike

Quoting Jeremy Zawodny [EMAIL PROTECTED]:

 On Wed, Sep 10, 2003 at 06:00:55PM -0600, Mike Hillyer wrote:
  Hi All;
  
  First of all, I think this will probably be a question for Heikki.
  
  If I remember correctly, InnoDB and the MySQL external locking flag are
  unrelated as InnoDB tables are unaffected by external locks.
  
  Now the question: is it possible for two MySQL servers to access the same
  tablespace in a shared disk cluster?
 
 I'm not Heikki, but I'm also pretty sure you can't do that today with
 InnoDB tables.  Not only would performance suffer, I don't believe
 there's a mechanism in place for a shared transaction log...
 
 Jeremy
 -- 
 Jeremy D. Zawodny |  Perl, Web, MySQL, Linux Magazine, Yahoo!
 [EMAIL PROTECTED]  |  http://jeremy.zawodny.com/
 
 MySQL 4.0.15-Yahoo-SMP: up 4 days, processed 165,040,351 queries (451/sec.
 avg)
 





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



Mini PC Server Hardware Review

2003-07-29 Thread mhillyer
Hi All;

These might be of interest to some on this list:

http://www.vbmysql.com/articles/microserverhp.html

I recently got my hands on a MicroServer HP by NorhTec in Calgary. It is an 
interesting box and could be useful for certain MySQL related applications.

http://www.vbmysql.com/articles/mysqlproexam.html

I have recently taken the Pro Exam, and my comments and observations can be 
found at the above link (approved by Carsten Pedersen of MySQL as NDA 
compliant ;-) ).

Regards,
Mike Hillyer
www.vbmysql.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]