Today we will use the MariaDB Cluster cluster we created in the previous two blog entries, and tie it all together with an HA Proxy virtual machine setup with separate read and write pools. This assumes your application is already using different connections for reads and writes, or you're using MaxScale, MySQL Proxy, etc to splits reads and writes.
Profiling & Debugging is an argument that would require an entire book, the aim of this(and the others) posts of this series is to give you the basic knowledge on how to work with these tools and techniques withing Eclipse. For instance if you want to learn to profile with OProfile you should study on the abundant and separate resources, you may start from: http://OProfile.sourceforge.net
One of my favorite new features of MariaDB 10 is parallel slave replication ( https://mariadb.com/kb/en/parallel-replication/ ). With earlier versions of MariaDB and MySQL, the slave runs in a single thread, and applies replication events serially. This was a performance bottleneck in highly concurrent environments, as transactions are able to utilize separate CPU cores on the master, while the slave could only use one CPU core to execute the replication events.
Metadata locking has been an exciting adventure for the last couple years in MySQL and MariaDB. Users and applications using only MyISAM tables are learning the joys of locking conflicts between transactions/connections.
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.