Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Rob Young has posted a few blog entries lately on the MySQL Enterprise monitoring software. His latest post claims that agent-based monitoring is equivalent to extensibility (MySQL Enterprise Monitor: Agent = Extensibility).
I think this is conflating two completely distinct properties of a monitoring solution. Cacti is extremely extensible, with a plugin-based architecture and [...]
An interesting article on Facebook, Which deals with MySQL's replication system, Memcache and the replication delay.
... by setting a cookie in your browser with the current time whenever you write something to our databases. The load balancer also looks for that cookie and, if it notices that you wrote something within 20 seconds, will unconditionally send you to California. Then when 20 seconds have passed and we're certain the data has replicated to Virginia, we'll allow you to go back for safe pages.
An interesting article on Facebook, Which deals with MySQL's replication system, Memcache and the replication delay.
... by setting a cookie in your browser with the current time whenever you write something to our databases. The load balancer also looks for that cookie and, if it notices that you wrote something within 20 seconds, will unconditionally send you to California. Then when 20 seconds have passed and we're certain the data has replicated to Virginia, we'll allow you to go back for safe pages.
Computer World has an article about Telecommuting . So, I thought I’d chip in my inflated $0.02. Telecommuting, doesn’t mean working from home. This is one of the biggest myths, and truths people will realize over time. What makes me such an expert? I’ve been telecommuting for the past 3 years, straight, full time. I’m not talking about moonlighting, and doing part time work for companies who post on craigslist. I’m talking multi million dollar projects. I haven’t been fired, I haven’t left the company, and I’ve been rewarded with a raise, and more importantly, I haven’t missed deadlines.
You still have a job, act like it. (The
Ugly)
Telecommuting, is not that hard. But, it’s not the holy grail for
workers either. You’re not going to …
Baron posted something interesting about agent vs agent-less monitoring in response to Rob.
While reading it, I couldn’t help thinking that the distinction is somewhat misleading, if not wrong.
I’d go so far as to say that agent-less doesn’t exist as such. Why do I say such heresy?
Trivially, you need some piece of software to collect data. With munin you configure a server that triggers scripts on the monitored servers. The set of data sources is governed by what you install in the correct directory on the monitored server. Cacti relies on SNMP heavily and also …
[Read more]Baron posted something interesting about agent vs agent-less monitoring in response to Rob.
While reading it, I couldn’t help thinking that the distinction is somewhat misleading, if not wrong.
I’d go so far as to say that agent-less doesn’t exist as such. Why do I say such heresy?
Trivially, you need some piece of software to collect data. With munin you configure a server that triggers scripts on the monitored servers. The set of data sources is governed by what you install in the correct directory on the monitored server. Cacti relies on SNMP heavily and also …
[Read more]|
Back in Sept'07 Arun wrote about Using GlassFish's JDBC connection Pooling in a Rails App; now Ikai@LinkedIn has an updated note that includes changes since then and presents the instructions from the perspective of a Rails developer. Ikai's note covers warbler, the MySQL Connection Adaptor and … |
It may be tested again! Reason for the new version are two new releases of the main components of XAMPP: PHP and MySQL.
New in both XAMPP versions: MySQL (5.0.67), PHP (4.4.9), and phpMyAdmin (2.11.8.1). .
Go to XAMPP BETA download area
XAMPP BETA versions are always for testing purposes only. There will be no upgrade packages from and to beta versions. To all testers: Many thanks in advance!!
We are hiring! dealnews is looking for a full time systems administrator. The developers have been sharing the sys admin load for over 10 years now. But, we really need a dedicated person now. If you are interested, see our jobs page.
Today I achieved something which is a first in the MySQL
server as far as I'm aware of. I managed to run a query
with multiple threads. The query was:
ALTER TABLE t1 ADD COLUMN b int;
and the table had 4 partitions in it. So it used 4 threads
that each thread handled the copying of data from old
table to new table of one partition.
Currently it's designed for use by partitioned tables but
it should be very straightforward to do minor
parallelisation
also of non-partitioned tables by e.g. breaking up in a
scan
thread and a write thread.
It's nice to get started on this track and see how one can
make use of modern computers with a great deal of CPU power
if one can parallelise the applications. As an example a
dual socket box T5220 (2 Niagara II CPU's) can handle 128
threads in parallel.