Category Archives: Database
Dimension rrdtool databases with years worth of values
To create an rrd datbase file needs a certain amount of understanding of what you monitor, and for how long the data needs to be kept, and of course, storage space is also a consideration when creating a new rrd … Continue reading
MySQL Could not find first log file name
When MySQL shows the error “Could not find first log file name in binary log index file” it means that mysql is looking for a bin-log file that is not shown in the bin-log index file. This does not necessary mean the replication is completely broken. Continue reading
Restore MySQL replication after error
When you have a replication error that does not allow you to fix it as described in Fix MySQL replication error you need to repair it by restoring the replication completely. Continue reading
Fix MySQL replication error
When you setup replication you need to make sure that no other data is available in the slave that can cause the data to be inconsistent. But if you run into problems like I had, you might notice that the … Continue reading
Setup mysql master slave replication
MySQL server provides replication functionality to replicate data from a master server to multiple slave servers. The concept behind it is that there is one master server that allows read and write access and one or more slave servers that … Continue reading
Is MongoDB always faster then MySQL?
This is another classic question you might have come across, but can this question simply be answered with a YES or NO? Well, I would not write about it if the answer was that easy! Continue reading
From what size of data MySQL is not performant any more?
Is this the right Question? Somebody asked me this question and I told myself to write about that topic. This questions are always lacking of of context, but there might be a correct answer. Usually you don’t reach the performance limit of MySQL very easily. Its the wrong questions you ask…
Continue reading
