Is it possible to do load balancing with 3 servers which also cluster
and fail over (High Availibity) with MySQL? Can somebody give me the how
to or URL to setup?
Willy
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Dear MySQL users,
MySQL Community Server 5.1.35, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.35 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
Ok. I have already gotten the answer.
On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father yueliangdao0...@gmail.comwrote:
Hi.
I want to know which lock method is used within MySQL?
For example, if I query the following statements within MySQL client.
mysql begin;
Query OK, 0 rows affected
Hi.
Here is the introduction.
http://www.oracle.com/technology/oramag/oracle/05-sep/o55security.html
I want to know whether MySQL has the same function as Oracle's?
Any reply is appreciated.
--
David Yeung,
MySQL Senior Support Engineer,
Sun Gold Partner.
My
Mind sharing ? :-) I don't really have the issue, but it sounds like a
useful trick.
On Fri, Jun 5, 2009 at 11:44 AM, Moon's Father yueliangdao0...@gmail.comwrote:
Ok. I have already gotten the answer.
On Wed, Jun 3, 2009 at 4:15 PM, Moon's Father yueliangdao0...@gmail.com
wrote:
Hi.
I'm very new to triggers, so I suspect I've done something naive.
When a row is inserted into a table, I want populate a 'date' column with
the date 45 days hence. I've created a trigger:
CREATE TRIGGER `test`.`setExpiryDate` BEFORE INSERT ON `test`.`mysql_auth`
FOR EACH ROW SET NEW.expires =
Curdate() returns a datetime, which you are pushing into a date field.
It is truncating the time part. Just truncate it and you should be
fine :)
Walter
On Fri, Jun 5, 2009 at 5:56 AM, Keith Edmundsk...@midnighthax.com wrote:
I'm very new to triggers, so I suspect I've done something naive.
I have a query that I build dynamically, here is an example:
select from (table1 as t1 left join table2 as t2 on t1.id = t2.id)
left join table3 as t3 on t1.id = t3.id where t1.id in ('221593',
'221591', 'CC3762', 'CC0059')
So I build the query in the order that I want it displayed. That
Aaron-
to reorder results of a column specify
FIELD(ColumnName,1stPosition,2ndPosition) e.g.
mysqluse information_schema;
mysql select ordinal_position,TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME
from COLUMNS WHERE ORDINAL_POSITION=23 OR ORDINAL_POSITION=18 ORDER BY
On Fri, Jun 5, 2009 at 9:09 AM, Aaron Fischerafisc...@smith.edu wrote:
So I build the query in the order that I want it displayed. That is display
221593, then 221591, then CC3762, etc. However, when the query is executed
it looks like it automatically sorts the codes in ascending order, so I
10 matches
Mail list logo
