About MySQL and Related Technologies
Recently, I was working on one of the support ticket where customer was complaining that when he change datadir location by copying datadir from C: to F:, set mysql permissions and changing location in my.ini, he could not able to start mysql. Even no error msg in MySQL error log OR application log that why…
If you are going to be using InnoDB tables and if you plan to have innodb_file_per_table enabled, then your best option would probably be to use the CREATE TABLE statement’s “DATA DIRECTORY” option, so that you can place a table outside the data directory. From the MySQL documentation: DATA DIRECTORY, INDEX DIRECTORY For InnoDB, the…
Recently, I was working with one of our customer and this is what their requirement as they want to automate this process for converting galera node to async slave and make async slave to galera node without shutting down any server. ———- Here are the steps for how to do that. I assumes that you…
“Address family not supported by protocol” means your MaxScale instance is attempting to bind to IPv6 addresses, but your system doesn’t support that for some reason. IPv6 support was added in MaxScale 2.1: . IPv6 Support MaxScale 2.1.2 added support for IPv6 addresses. The default interface that listeners bind to was changed from the IPv4…
Recently, I had to do this as 10GB was not sufficient for Centos6.7 VM. I would just like to mention simple steps for how to do it. Shutdown VM and quit from VirtualBox. Open the terminal and go to the below path (default location). From here you can run the command to resize the VDI…
What is the solution if I don’t want to give password in command line (i.e mysql -uroot -p ) OR don’t want to store password in files(in .my.cnf) and still can login into MySQL/MariaDB without password ? I was also bit curious to know but finally I found very easy solution called “unix_socket plugin” provided by MariaDB.…
This post is just following up my previous blog post which describes how to setup 3-nodes MariaDB Galera Cluster with MySQL-Sandbox on single server. Today, I’ll try to explain how we can setup MariaDB MaxScale over the Galera Cluster. Before I move ahead, I would like to explain about MaxScale little bit. MariaDB MaxScale is…
For the production environment, it’s recommended that we should use separate server for each Galera Cluster node but sometimes, for the testing purpose we have to setup it on one server with different ports. Here are the steps for how to do that with CentOS 6.8, MariaDB Galera Cluster 10.1.21 and MySQL Sandbox Download MariaDB 10.1.21 from this location…
Recently, I was discussing with one of my colleagues about how insert statement performs for MySQL partitioned tables. General prediction is that it should be slower than for non-partitioned tables, but how much that we didn’t know. So, I thought let’s test with different types of partitions (i.e range, list and hash) and also with different…
Normally, when we want to start PXC (Percona XtraDB Cluster) on RHEL/CentOS 6 or older then that, we can simply start with init.d script or service command. i.e shell> /etc/init.d/mysql start OR shell> /etc/init.d/mysql bootstrap-pxc shell> service mysql start. But, the way is changed from CentOS 7. Because systemd integration with RHEL/CentOS 7 is now…