How To Run Your Own Web SMS Portal With PointSMS

This tutorial will show you how you can set up an SMS web site on CentOS using PointSMS.

Database sharding, used by Facebook, Tumblr and Mozilla, is an incredibly powerful way to ensure MySQL systems scale-out and drive consistent, fast app performance to handle more users, more data, and more workloads. But home-grown sharding is hard, full of caveats, and very often ends up as non-cost effective.

    ScaleBase provides an easy to use platform [...] Read More

<< Previous Post: Advanced use of Global Transaction Identifiers

As we saw in my previous posts, Global Transaction Identifiers in MySQL 5.6 allow you to change the replication topology arbitrarily. You don't even need to specify the positions in the replication stream – when you turn on auto-positioning, the master automatically sends only those transactions that are missing on the slave.

When you do a fail-over, you want to make sure that the new master is up-to-date. For instance, consider the following scenario:
Server A is a master; B, C and …

I wanted to do some experimentation with Percona XtraDB Cluster (Galera) and I didn't want to use virtual machines. I'm already using MySQL Sandbox for many other projects so that's the natural choice.

I've downloaded the tarball for Percona XtraDB Cluster 5.5.29 and I've extracted it to ~/opt/mysql/5.5.29-pxc.

Then I've installed 3 nodes:
make_sandbox 5.5.29-pxc -- --sandbox_port 4551 \
--sandbox_directory msb_5_5_29-pxc01 

make_sandbox 5.5.29-pxc -- --sandbox_port 4552 \
--sandbox_directory msb_5_5_29-pxc02 

make_sandbox 5.5.29-pxc -- --sandbox_port 4553 \
--sandbox_directory msb_5_5_29-pxc03 

But when I try to start a node this error happens:
130327 14:21:03 [Note] WSREP: wsrep_load(): loading provider library '/home/dvee
den/mysql/5.5.29-pxc/lib/libgalera_smm.so'
130327 14:21:03 [ERROR] WSREP: wsrep_load(): …

A few weeks ago I wrote about “MySQL Performance at High Concurrency” and why it is important, which was followed up by Vadim’s post on ThreadPool in Percona Server providing some great illustration on the topic. This time I want to target an opposite question: why MySQL performance at low concurrency is important for you.

I decided to write about this topic as a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, …

MariaDB has had pluggable authentication since MariaDB 5.2. Our most popular authentication plugin that we ship in MariaDB is the PAM authentication plugin. Naturally one is curious to see if users would like to see more authentication plugins being made available, so we’ve posted a poll on Facebook. Please feel free to add your vote to the poll so we have a better idea of where to focus our future pluggable authentication development.

The MySQL for Beginners course is your first step towards mastering the MySQL database. This 4-day class gives you a solid understanding and practical experience of using relational databases, SQL and the MySQL Server and tools.

You can take this instructor-led class as following:

• Training-on-Demand: Start training within 24 hours of registration and follow the class at your own pace through streaming video and booking time to do lab exercises at your convenience.
• Live-Virtual Class: Attend a live event from your own desk - no travel required. Choose from the many events already on the schedule, suiting different timezones. Delivery is currently scheduled in English and German.
• In-Class: Travel to an education center. Below is a selection of the events already on the schedule. …

In the first part of this article we examined the types of conflicts and their causes. In this part, we will analyse some of the methods available to deal with conflicts.

Pessimistic locking (or: conflicts won't happen)

Applicability: synchronous clusters with 2pc

We've covered this topic in the previous article, but it's worth repeating. If you use a synchronous cluster, you don't have conflicts. For example, MySQL Cluster ensures consistent data with updates coming from different nodes. However, MySQL Cluster is not a replacement for a MySQL server, and it has severe limitations.

Optimistic locking

Applicability: synchronous clusters without 2pc (Galera)

Conflicting transactions proceed on different nodes with local locking. The last one then …

I just wanted to share my steps for building MariaDB 10.0 on Windows (10.0.1 in this case):

cd maria-10.0.1
mkdir bld
cd bld
cmake .. -G "Visual Studio 10"
cmake --build . --config relwithdebinfo --target package

That’s it! The zip file is created right there in bld/.

Hope this helps.

Over in the MySQL Manual section on Event Scheduler Status you get to find out that in MySQL 5.1.11 you got to find out the status of the event scheduler by using the SHOW SCHEDULER STATUS query. Any version since then you need SUPER and have to use mysqladmin debug to get any information on the status of the event scheduler itself.