It kind of depends on your application. If you have an application
like most web applications, it is okay to skip a beat and a half when
a failover occurs. Usually you can lose a very small number of
transactions (the ones that are ongoing when the failure occurs), but
your failover happens sub-sec
Are there any known issues or challenges implementing MMM?
We're currently focused on MMM but just kinda wanted to keep our eyes open.
Kyong
On Thu, Jul 22, 2010 at 11:19 PM, Rob Wultsch wrote:
> On Thu, Jul 22, 2010 at 8:42 PM, Kyong Kim wrote:
>>
>> Has anyone used this in production?
>> We're
No.
If it is for security reasons: did you think about a view on slave db?
(removing rights from source table)
In case you dont want those columns to reach the slave you could use
triggers to reflect changes from source table (or a view) on master to a
table(with missing columns) that will be rep
I know that you can ignore certain databases and tables in mysql
replication, but is it possible to replicate all but a certain column or
two from a table? This is 5.1.48 on linux.
Thanks,
Bryancan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hello,
I have a server which has been booted in rescue mode, i have copied
the /mnt/var/lib/mysql/blog folder to another server running MySQL and
copied this folder to /var/lib/mysql
when i connect to the mysql cli, i get this:
http://pastie.org/1057117
but my source server is 64bit where as the
Hi!
a.sm...@ukgrid.net schrieb:
> According to this you must install OpenSSL then compile MySQL from
> source
>
> http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html
You cannot (in general) assume that some hint you find somewhere for
MySQL 5.0 still applies to MySQL 5.1.
Specifically
I have a very large table (over 2 billion rows) which is partitioned by
day. I'd like to archive all the data in the oldest partition to another
table before I drop that partition. Is there some way other than a
simple select statement that has parameters that match those of the
partition whic will
Dear MySQL users,
MySQL Community Server 5.1.49, a new version of the popular Open
Source Database Management System, has been released. MySQL 5.1.49 is
recommended for use on production systems.
For an overview of what's new in MySQL 5.1, please see
http://dev.mysql.com/doc/refman/5.1/en/mysq
Hi,
I want to check daily a large database. If I execute a "mysqlcheck", its
execution is longer the 8 minutes.
What is the best practice to check tables daily ? medium option? Fast
option?
Regards,
David
