You've decided to move from MySQL to MariaDB, but you're a little nervous. The last thing you want is to become mired in a slough of brokenness. Don't worry, because MariaDB is designed to be a drop-in replacement for MySQL. You should be able to install MariaDB over your MySQL server, and then go about your business without drama.
In this part we will prepare Eclipse to profile our recently compiled(see Part 3) MariaDB(or MySQL).
Profiling means basically measuring where the time is spent by the application.
You may be interested in knowing how much time is spent in a specific function execution,
or you may want to know statistics about the dustribution of function calls, that is operating a data aggregation.
It's always a pleasure to attend promotional events on your doorstep. Yesterday the RedHat European Roadshow rolled into my hometown to take over the Mermaid Conference Centre in Blackfriars, EC4. Not a venue I’d been to before, I must admit, but easy enough to reach after a refreshing morning walk down the South Bank from Waterloo station.
WordPress has evolved from a specialized blogging platform into today's most widely used open source content management software (CMS), with thousands of third-party themes and plugins. WordPress was developed with MySQL as a back end, but because MariaDB is designed as a binary drop-in replacement of the original MySQL, you can replace MySQL with MariaDB for your WordPress installation and take advantage of its better performance, along with new features such as the two new database engines: XtraDB, which replaces InnoDB, and Aria, a crash-safe alternative for MyISAM. Read how in this blog.
Four of the Finnish members of Team MariaDB got together this week for the High Tech Run in Espoo, Finland. The five legs of the 25,5 km relay race were run by Juha, Vilho, Robert and Rasmus. As first time attenders we were happy to finish 17th out 40 participating teams, including Accenture, Dell, HP, IBM, Intel, Oracle, SAP, Teradata and Tieto. Until next time!
How do you choose the best Linux filesystem for your MariaDB server? The primary factors to look at are data integrity, performance, and ease of administration. Data integrity tops the list because fixing a corrupted database is even less fun than it sounds, and filesystems play a key role in data integrity. Performance is important because faster is better and time is money, and ease of administration matters for the same reasons as performance.
You've lost the root password for your MariaDB database – now what do you do? You can't recover your existing password, but you can get into your database to create a new root password. You just need root privileges on the Linux server that is running MariaDB. If you're running Debian Linux (and its derivatives, such as Ubuntu and Mint) you can use a back door trick to reset your password.
First, stop your database if it's running. On Red Hat Linux and its various offshoots, such as Fedora, CentOS, and Scientific Linux, use the systemctl command:
I really enjoy using cloud-based virtual servers for testing MariaDB and MySQL deployments. With automation scripts, it's fast and easy to create environments that match what customers are using to solve issues quicker. For example, with just a couple of commands, we can bring up a replication cluster with one master and two slaves, running a specific MySQL version, and run tests to find a memory leak.