The MySQL task WL#4033 Informational Events includes adding information about the original query for row-based replication. This will make it easier to debug failures and user mistakes. It also makes it easier for us to add other information to the binary log. Is there some information missing that you think we should add to the binary log? Please feel free to comment on this blog entry or send me an email at firstname.lastname@oracle.com.
Nov
18
2010
Nov
18
2010
The convergence of telecommunications onto IP (Internet Protocol)
based networks is revolutionizing today's communications
industry. Communications Service Providers (CSPs) are challenged
to deliver compelling new personalized services with greater
agility and lower costs than ever before.
Whether they are looking to deploy new Web/Telco 2.0 applications
to mobile Internet users or consolidating subscriber data within
the network to support greater service personalization and
targeted communications, the database plays a key role in
enabling new services.
We believe MySQL is pretty much unique in the industry by
providing the insight and experience to marry the innovation and
speed of the Web with the proven capabilities of the carrier
network. MySQL is deployed in 9 of the top 10 most trafficked
sites on the web [1] including Google, Facebook and
YouTube. MySQL is also extensively deployed in the network
domain, …
Nov
18
2010
Nagios is a powerful monitoring system and here we will learn how to monitor MySQL through Nagios. We will be installing Nagios, required plugins and configuring it to monitor MySQL…
The post 10 Steps: MySQL Monitoring through Nagios: Install & Configure first appeared on Change Is Inevitable.
Nov
18
2010
Nov
18
2010
Yesterday I presented PBXT: A Transactional Storage Engine for
MySQL at the German Oracle User Group Conference (DOAG) in
Nuremberg. A number of people asked for the slides, so here is
the link.
The talk was scheduled to be in English, but since I had a
German-only audience I presented in German. There was quite a bit
of interest, particularly in the Engine Level replication built
into PBXT 2.0.
As Ronny observed, this feature can be used effectively for many
tasks, including for online backup and maintaining a hot-standby.
This all with the addition of a "small" feature:
The Master could initially stream the entire database over to the
Slave before actual replication begins. This would also make it
extremely easy to setup replication.
A brilliant idea, but a good 3 months work...
Nov
18
2010
This is the 150th tip published on this blog so decided to make it a collection of all the previous ones. Here is a tag cloud (created from wordle.net/create) from title of all the tips:
As expected GlassFish is the most prominent topic. And then there are several entries on NetBeans, JRuby/Rails, several Java EE 6 technologies like JPA, JAX-WS, JAX-RS, EJB, and JSF, and more entries on Eclipse, OSGi and some other tecnhologies too. Here is a complete collection of all the tips published so far:
[Read more]
Nov
18
2010
This is the 150th tip published on this blog so decided to make it a collection of all the previous ones. Here is a tag cloud (created from wordle.net/create) from title of all the tips:
As expected GlassFish is the most prominent topic. And then there are several entries on NetBeans, JRuby/Rails, several Java EE 6 technologies like JPA, JAX-WS, JAX-RS, EJB, and JSF, and more entries on Eclipse, OSGi and some other tecnhologies too. Here is a complete collection of all the tips published so far:
[Read more]
Nov
17
2010
Summary
B-trees suffer from fragmentation. Fragmentation causes headaches — in query performance and space used. Solutions, like dump and reload or OPTIMIZE TABLE are a pain and not always effective. Fractal trees don’t fragment. So if fragmentation is a problem, check out Tokutek
What is fragmentation?
What do I mean when I say “fragmentation”? People complain about two things when they talk about index fragmentation. They either find that the disk spaced used is much larger than the data, or they complain about query performance. In particular, they complain of range query performance, since point queries aren’t really affected by fragmentation. I’m going to focus on this second symptom, which is due to lack of locality of reference amongst the rows.
B-trees fragment
In the following, I’ll be talking about the limits of B-trees. Not InnoDB …
[Read more]
Nov
17
2010
Here's what's new for the trendy developer this week:
Java's future on Apple: Slightly less in doubt
Last week, it looked like Apple was all "You're not welcome here, Java." In the changeable world that is Jobsland, this week Apple was offering to marry the language, reiterating their support for Java in OS X, and indicating that they would be supplying code and resources to the OpenJDK project.
As I've noted before, this makes sense for Apple, because it gets them out of the JVM business, and makes Oracle the one-stop shopping solution for all your JDK and JRE needs. It also means that the Mac can be added as a regression-tested target for a new version of Java, hopefully avoiding the kind of Java versioning snafus that rendered IBM's SPSS (or is it PAWS this week?) statistics …
[Read more]
Nov
17
2010
The binary version for MySQL Cluster 7.1.9 has now been made available at http://www.mysql.com/downloads/cluster/
A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.9 (compared to 7.1.8) can be found in the official MySQL Cluster documentation. In addition, there is a great BLOG posting from Johan Anderson explaining how to use the new table added to ndbinfo to tune DiskPageBufferMemory when storing tables on disk.