RE: possible to select from multiple databases?

Hello, Have you taken a look at the FEDERATED storage engine? http://dev.mysql.com/doc/refman/5.0/en/federated-storage-engine.html It is a storage engine that accesses data in tables of remote databases rather than in local tables. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc

RE: MySQL Clustering

t for it's availability. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Ben Clewett [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 30, 2006 6:48 AM > To: mysql@lists.mysql.com > Subject: MySQL Clustering > > Dear MySQL, > &

RE: MySQL documentor - not MySQL Workbench

Hello, Although not open-source, our partner Embarcadero Technologies offers one of the best ER tools out there for design, diagraming, documentation and reverse/forward engineering. ERStudio www.embarcadero.com/products/erstudio/index.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc

RE: Passwords in Mysql5.x

Hello, Have you taken a look at the following sections in the manual? http://dev.mysql.com/doc/refman/5.0/en/user-names.html http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html Thanks, Jimmy Guerrero Sr Product Manager

RE: MySQL Server

Hello, Is there a particular reason you need to be working with version 3.23 (besides it being part of the RHL distro?) You might want to start with version 5.0 or 4.1. http://dev.mysql.com/downloads/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- >

RE: MySQL (GPL License)

Hello, If you are still unsure about the licensing, this may help... http://www.mysql.com/company/legal/licensing/ http://www.mysql.com/company/legal/licensing/faq.html There are also related links off to the right concerning the Open Source License and Commercial License. Thanks, Jimmy

RE: How To Pronounce MySQL

Hello, I'll take the easy way out and quote http://dev.mysql.com/doc/refman/5.0/en/what-is.html "The official way to pronounce "MySQL" is "My Ess Que Ell" (not "my sequel"), but we don't mind if you pronounce it as "my sequel" or in some ot

RE: Books on MySQL 5

Hello, You might want to check out Guy Harrison's book on SP's. http://www.amazon.com/gp/product/0596100892/102-8915813-3282553?v=glance&n=2 83155 Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Chris White [mailto:[EMAIL PROTEC

RE: udf configuration

Hello, If you have not already done so, you may also try the MySQL forum for UDFs at: http://forums.mysql.com/list.php?118 Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Yong Lee [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 19, 200

RE: Anyone interested in a 4gl compiler ?

Hello, Have you taken a look at MySQL Forge? http://forge.mysql.com/ Great place check out other projects or users working on projects who may be interested in what your working on. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Mike Aubury [

RE: Synro MySQL databases

/sqlyog/index.php Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Brian E Boothe [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 10:16 AM > To: MySQL List > Subject: Synro MySQL databases > > HI all i have a question,

RE: mysql + LVS

nks, Jimmy Guerrero MySQL, Inc > -Original Message- > From: Winn Johnston [mailto:[EMAIL PROTECTED] > Sent: Monday, July 24, 2006 3:26 PM > To: mysql@lists.mysql.com > Subject: mysql + LVS > > How stable has it become to run an instance of mysql ontop of >

RE: MySQL Cluster

Hello, MySQL Cluster has been available since version 4.1. For production purposes we recommend the GA version of 5.0. For the testing of new features (Disk-Data, Replication, etc) take a look at the latest 5.1 version. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Origi

RE: Replication vs. Clustering

http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-faq.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Jesse [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 7:23 AM > To: MySQL List > Subject: Replication vs. Clustering

RE: Moving Databases from v4.0.23 to v5.0.24

Hello, REPEAT is indeed a reserved word in MySQL in 5.0 http://dev.mysql.com/doc/refman/5.0/en/reserved-words.html Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Kurt Cypher [mailto:[EMAIL PROTECTED] > Sent: Wednesday, August 09, 2006 3:13 PM &g

RE: Web Seminar Events

hem happen. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Jesse [mailto:[EMAIL PROTECTED] > Sent: Friday, August 25, 2006 12:13 PM > To: MySQL List > Subject: Web Seminar Events > > Why is it that the Newsletter goes out after th

RE: How to draw data model diagrams from existing schema?

Hello, Check out MySQL Workbench (Part of the MySQL GUI Tools Bundle) if you haven't already done so: http://dev.mysql.com/downloads/gui-tools/5.0.html Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: news [mailto:[EMAIL PROTECTED] On Behalf

RE: where are the .MYI and .MYD files?

/dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 07, 2006 4:32 PM > To: mysql@lists.mysql.com > Subject: where are the .

RE: Encryption

Hello, Have you taken a look at: http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html That might give you a good start. Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED] > Sen

RE: MyISAM vs InnoDB

/storage-engines.html Thanks, Jimmy Guerrero MySQL, Inc > -Original Message- > From: Francis [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 31, 2006 2:25 PM > To: mysql@lists.mysql.com > Subject: MyISAM vs InnoDB > > Hi list, > > Question about MyI

RE: Now what's that called?

Hello, Are you think of Eventum? http://dev.mysql.com/downloads/other/eventum/ Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 Are you MySQL Certified? www.mysql.com/training//certification -Original Message- From

RE: copying data!!!

Hello, We expect to offer native support for LDAP and PAM authentication, late next year. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com -Original Message- From: Sachin Bhugra [mailto:[EMAIL PROTECTED] Sent: Friday, December 09, 2005 1:38 PM To: mysql

RE: to track the changes in database mySQL

ta to suit your needs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Logan, David (SST - Adelaide) [mailto:[EMAIL PROTECTED] Sent: Monday, December 12, 2005 11:14 PM To: Satyanarayana_Kesani; mysql@lists.mysql.com Su

RE: to track the changes in database mySQL

ROTECTED] Sent: Tuesday, December 13, 2005 7:28 AM To: Jimmy Guerrero; Logan, David (SST - Adelaide); mysql@lists.mysql.com Subject: RE: to track the changes in database mySQL Thanks Jimmy, I would like to get one thing clarified from you is: Am I able to create a binary log (may be some other log) to k

RE: how to create binary logging for a database

Hello, The reference manual is great place to start for this type of information. http://dev.mysql.com/doc/refman/5.0/en/binary-log.html --log-bin[=file_name] is the mysqld startup command. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713

RE: Store Procedures

Hola, Una introducción basica y ejemplos se pueden encontrar aquí: http://www.quest-pipelines.com/newsletter-v6/0105_D.htm http://www.quest-pipelines.com/newsletter-v6/0205_D.htm Tambien aqui: http://www.databasejournal.com/features/mysql/article.php/3525581 Jimmy Guerrero, Senior Product

RE: MySQL5

ons] command [command-options] 3. If you are interestd in the graphical tools we offer, you can find the links at: http://dev.mysql.com/downloads/ The Administrator, Query Browser and Migration Toolkit are available for download on that page. Thanks, Jimmy Guerrero, Senior Product Manager MySQL

RE: Report tool - Mysql

. If it's reports/documentation about your DB you are after you might want to check out Embarcadero's ERStudio, which is imho the best ERD tool on the market. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- Fr

RE: MySQL database design documentation

for remote admin depending on your setup and security needs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -Original Message- From: Maurice van Peursem [mailto:[EMAIL PROTECTED] Sent: Thursday, January 05, 2006 3:37 PM

RE: Collect SQL Statements

seconds to execute or didn't use indexes See http://dev.mysql.com/doc/refman/5.0/en/log-files.html for more info on setting up and analyzing these logs. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Mo

RE: Performance of MEMORY/HEAP-tables compared to mysql-cluster?

API to access data.) As, Sherri suggests another storage engine might be a better play here. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Friday, January 27, 2006 11:11 AM To: Jan

RE: 4 GIG Limitation

Hello, Check out http://dev.mysql.com/doc/refman/5.0/en/table-size.html Also, not sure if it's a typo but MySQL 11.8 is a ways off. Did you mean 4.1 or 5.0? Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA Phone: (713) 636-9239 -Original Me

RE: Visual database design system

Hello, Might want to check out ERStudio from Embarcadero Technologies. http://www.embarcadero.com/products/erstudio/ Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA -Original Message- From: Adi [mailto:[EMAIL PROTECTED] Sent: Friday, February 03

RE: ~Mysql cluster info~

still reside in memory. Might be worth checking out, however 55 GB is def. on the large size for a MySQL Cluster configuration. Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com > -Original Message- > From: Mohammed Abdul Azeem [mailto:[EMAIL PROTECTED] > Sen

RE: ~Mysql cluster info~

Hello, Not at this time, currently 5.1 is in Beta. We should see a release candidate soon, but I can't commit to a specific date at this time. Thanks, Jimmy Guerrero, Senior Product Manager MySQL Inc, www.mysql.com Houston, TX USA > -Original Message- > From: Moh

Re: MySQL Guru Needed!!

Hello, Depending on your budget and SLA needs, check out the support offerings available directly from MySQL/Sun. http://www.mysql.com/products/enterprise/features.html -- Jimmy bruce wrote: Hi. I've got a situation where I need to reach out/talk to a mysql guru every now and then. For the

Re: if there're a tool which can replace mysql-proxy?

Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers... Check out the "Simulating Workload with MySQL Proxy" webinar on April 2, with Giuseppe Maxia, MySQL Community Lead and Diego Medina, Quality Assurance Engineer

Re: if there're a tool which can replace mysql-proxy?

Forgot to post the URL in the event you are interested: http://www.mysql.com/news-and-events/web-seminars/display-306.html -- Jimmy Jimmy Guerrero wrote: Hello, One additional note in regards to learning more about the current state of MySQL Proxy and connecting with Proxy developers

Re: Circular replication

Hello, EDS and MySQL are having a webinar on the subject of circular replication today. Check out: http://www.mysql.com/news-and-events/web-seminars/index.html If you can't make it today, it will be archived in the "On-Demand" section. -- Jimmy Alex Arul Lurthu wrote: Chain replication is f

Re: Securing the Data

Hello, http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html discusses some available encrypt and decrypt functions native to MySQL. -- Jimmy Sujatha S wrote: Thanks for the update. Is there any method to encrypt the data on mysql? Regards, Suja On 1/11/08, [EMAIL PROTECTED] <[EM

Re: recommended high availability setups

Hello, It isn't without its pros and cons (just like any other HA solution), but you might want to check out DRBD. http://dev.mysql.com/doc/refman/5.1/en/faqs-mysql-drbd-heartbeat.html -- Jimmy Bryan Irvine wrote: What's the recommended method for high-availability setups? I've currently go

Re: Question on replication

Hello, Check out: --replicate-do-db=db_name http://dev.mysql.com/doc/refman/5.0/en/replication-options.html -- Jimmy Kandy Wong wrote: Hi, Is there a replication setup method just to replicate a specific database not all the databases or exclude a specific database not to be replicated?

RE: MySQL on a ram disk?

looking for, with the added benefit of high availability. More info at: http://www.mysql.com/products/database/cluster/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: Ryan Stille [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 08, 2006 8:2

RE: MySQL Licensing

Hello, I would recommend posting your question in the Licensing Fourm: http://forums.mysql.com/list.php?4 Also, please refer to our FAQ: http://www.mysql.com/company/legal/licensing/ Thanks, Jimmy Guerrero Sr Product Manager MySQL, Inc > -Original Message- > From: I have a qu

Re: MYSQL data replication

Hello, Hmmm, I just reread your post and noticed the requirement of 50-60 slaves hanging off a single master. DRBD would NOT be the right solution here. -- Jimmy Jimmy Guerrero wrote: Hello, Although you state that there is no requirement for near real time synchronization, an

Re: MYSQL data replication

also gives you failover capabilities. Mohd posted a blog on his experience yesterday. See: http://blog.irwan.name/?p=118 Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX sol beach wrote: I have limited experience with MYSQL replication; which is why I am hoping others with more

Re: Master-Slave System Using Different Versions of MySQL

Hello, Did you already check: http://dev.mysql.com/doc/refman/5.0/en/replication-compatibility.html "You cannot replicate from a master that uses a newer binary log format to a slave that uses an older format (for example, from MySQL 5.0 to MySQL 4.1.)" Thanks, Jimmy Guerrero

Re: Getting list of queries run against a database

Hello, To get started, have you tried enabling the slow query log? http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html "The slow query log can be used to find queries that take a long time to execute and are therefore candidates for optimization." Jimmy Guerrero Sr Produ

Re: MySQL cluster for windows

Hello, MySQL Cluster on Windows will not be available in version 5.1. Older versions of the product used to run on Windows, but the interest was low and the code has suffered from bit rot as a result. We are really waiting and seeing for the interest to pick up before allocating resources to

Re: MySQL cluster for windows

on Mac- Linux - Unix platforms. (Just not Windows) Hope that helps, Jimmy Rolando Edwards wrote: What was the last release of MySQL 5.0.x that supported Cluster ??? - Original Message - From: "Jimmy Guerrero" <[EMAIL PROTECTED]> To: "C K" <[EMAIL PROTECTE

Re: MySQL cluster for windows

EMAIL PROTECTED] Sent: Thursday, June 21, 2007 9:42 AM To: Jimmy Guerrero Cc: mysql@lists.mysql.com; C K Subject: Re: MySQL cluster for windows What was the last release of MySQL 5.0.x that supported Cluster ??? - Original Message - From: "Jimmy Guerrero" <[EMAIL PROTECTED]&

Re: 64 bit build for Windows?

Hello, http://dev.mysql.com/downloads/mysql/5.0.html#winx64 Let me know if that helps. -- Jimmy James Eaton wrote: Is there a 64 bit build of MySQL 5.0 available for Windows Server 2003 64 bit edition? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: hardware & clusters

Also, there is a cluster specific list: [EMAIL PROTECTED] Jimmy Guerrero Sr Product Manager MySQL, Inc Houston, TX Ricardo Oliveira wrote: Hi, As usual, everything is heavilly dependant on your specific scenario. Anyway, as a rule of thumb, databases benefit a LOT from RAM, and storage nodes