Even though I used a dedicated Kubernetes cluster to host my test database, I had this belief that by not explicitly allocating (or requesting, in Kubernetes vocabulary) CPU resources to my Percona XtraDB Cluster (PXC) pods or yet making just a small request, Kubernetes could be delaying access to the free CPU cycles available on […]

The latest update to MySQL Enterprise edition, version 9.1, introduces significant enhancements focused on replication monitoring. This update includes improvements to Group Replication Flow Control and the replication applier, providing users with better visibility and control over their replication performance, leading to potential long-term cost savings by ensuring efficient usage of their machine resources.

Different ways to get the status:

mysqlsh --login-path=icadmin -h$MYROUTER1 -- cluster status

mysqlsh --login-path=icadmin -h${HOSTNAME} --redirect-primary -- cluster status

mysqlsh icadmin:'P4ssw0rD'@db01:3306 -- cluster status --extended=0

mysqlsh icadmin@$MYROUTER1:3306 -- cluster status --extended=1

watch -n 5 “mysqlsh --login-path=icadmin -h$MYROUTER1 -- cluster status”

Set the Primary Instance (switching):

mysqlsh --login-path=icadmin -h${HOSTNAME} --redirect-primary -- cluster set_primary_instance "db01"

Obtaining MySQL InnoDB Cluster basics:

select cluster_id, cluster_name, description, cluster_type, primary_mode, clusterset_id from mysql_innodb_cluster_metadata.clusters;

Members of our cluster:

select * from performance_schema.replication_group_members order by MEMBER_ROLE;

Local & Remote Trans Q’s:

 …

For years, MySQL has been a cornerstone for businesses worldwide. Its ease of use and built-in data replication features have made it a perfect fit for creating high available databases. Moreover, it has made it possible to design and implement simple business continuity solutions based on live snapshots trough replication. As setups become more complex […]

BSE Limited (previously Bombay Stock Exchange) is Asia’s oldest stock exchange with a rich history of 150 years. It is the largest securities market with over 5,300 companies listed. BSE enables investors to trade equities, currencies, debt instruments, derivatives, and mutual funds. BSE Sensex represents 30 of India’s largest and most well-capitalized stocks and is […]

BSE leverages MySQL Enterprise Edition for processing 150 million trades and 5 billion orders per day.

So, we’ve heard that jemalloc is better than malloc for MySQL usage, and in fact, certain versions / forks of mysql already include this, eg. Percona Server (https://github.com/percona/jemalloc).

But, how can I install and configure my system to use it?

Here’s a quick push in the, hopefully, right direction.

First things first, what is “jemalloc” and how does it affect my system? I think it’s quite well explained here: https://www.percona.com/blog/impact-of-memory-allocators-on-mysql-performance/ albeit an old article.

The right place to get the latest …

In today’s fast-evolving financial services landscape, companies face mounting pressure to innovate while maintaining stringent data security and regulatory compliance. As fintech disruptors redefine customer expectations, traditional financial institutions must leverage modern technology to enhance profitability and operational efficiency. MySQL Enterprise Edition emerges as a powerful tool in this endeavor, offering significant cost savings and […]

MySQL not only helps financial institutions bolster their profitability but also equips them to thrive in a rapidly changing market. Embracing MySQL is a strategic move for any financial services organization looking to secure its future in a digital-first world. Read the full blog.

I love my job. One of the best feelings is when I find an interesting paper and use it to solve a real problem. It feels like I found a cheat code. Instead of having to do a lot of hard thinking, I can just stand on the shoulders of really big people and take a shortcut. Here, I want to share a recent project that I could solve using a public paper.