Tag Info

New answers tagged

0

It can be that sometime the iSCSI connection use some more time to go up, and the MySQL service "race ahead" of the iSCSI mounting. After boot, try to restart MySQL: if during boot it did not start properly, but from the shell it starts without problem, than you confirm that we have a timing issue. Another possibility: did you reach the iSCSI mount using ...


0

This depends on what type of NAS you have (brand and model, please). If you had something that wasn't particularly tuned to Windows integration (e.g. Isilon or a Linux-based NAS), I would recommend against using it as a file share directly. Also, storage isn't always about throughput... It rarely is. Again, the specific type of device you have will dictate ...


4

This is the kind of question I don't understand the logic behind. Regarding this statement about option 1: Issue I see with this is I wont be able to utilize the extra network capacity of the linked lan ports on the nas as all the sharing is going through the one file server which will create a bottle neck with its own single lan port - That's an ...


0

Unfortunately, I think that nothing is wrong with your setup. You simply can not use more than 1 Gb/s for a single VM. The point here is that you don't want simply to use two (or more) NICs, you want to use them concurrently, in a RAID-0 like configuration. 802.3ad, the standard about link-level aggregation and that I think you configured on your switchs, ...


1

Create a SATP rule for storage vendor named EMC, set the path policy as Round Robine and IOPS from default 1000 to 1. This will be persistence across reboots and anytime a new EMC iSCSI LUNs is presented, this rule will be picked up. For this to apply to existing EMC iSCSI LUNs, reboot the host. esxcli storage nmp satp rule add --satp="VMW_SATP_DEFAULT_AA" ...


0

[Moderators please feel free to downgrade this to a comment if you feel that is appropriate.] Set it up with CHAP authentication: http://opentodo.net/2012/10/setup-iscsi-target-initiator-on-centos-6/ https://technet.microsoft.com/en-us/library/ee338480(v=ws.10).aspx http://blog.migrationking.com/2011/04/how-to-setup-iscsi-on-windows-2008-r2.html


1

I strongly suggest to give a look at rsnapshot: it basically is a perl wrapper around rsync with the added benefits of integrated snapshot rotation and much more.


5

First and foremost, before to mangle with storage, you should be 100% sure that your bottleneck is really related to disk/IO configuration. It this is the case, an iSCSI share can be faster than a NFS one, but in specific scenario only (small random read/write packets). SQL servers can be one of these scenarios, so if you are sure that your problem is ...


4

First things first: If you want to improve the performance of a VM you have to know where the bottleneck is. Improving storage performance doesn't help you if your environment lacks e.g. CPU performance. I don't think changing your storage protocol from NFS to iSCSI will help you much. There are dozens of other parameters that influence your storage ...


4

I've not heard that iSCSI is better than NFS for SQL VMs, however if you do elect to create them, I would create the datastore on the ESX level, not install an iSCSI initiator on the VM. One thing you need to be careful about is thin provisioning on the Netapp. The way they do block devices is different. You can find yourself with an offline LUN if you ...



Top 50 recent answers are included