Best hosting for global availability

So, I've been with a lot of hosts in last 6 years. Currently I'm with Cloudways with a DO droplet.

The only problem is that the people near to my datacenter have good load times due to low TTFB. But on the other places away from my datacenter, TTFB is pretty high which makes the load time miserable.

Now, I know CDN should help here to make the site contents load from their nearest server. But the issue is that CDN only caches the static contents of a site like CSS, JS, and images. While…

Best hosting for global availability

How to show the Availability group listener instead of the nodes?

I have just installed a sql server availability group, always on, with 2 servers,

SQLPROD1_TS and SQLPROD2_TS as you can see on the picture below:

select distinct rcs.database_name, ar.replica_server_name, drs.synchronization_state_desc, drs.synchronization_health_desc, CASE rcs.is_failover_ready WHEN 0 THEN 'Data Loss' WHEN 1 THEN 'No Data Loss' ELSE '' END as FailoverReady  from sys.dm_hadr_database_replica_states drs  inner join sys.availability_replicas ar         on drs.replica_id = ar.replica_id       and drs.group_id = ar.group_id  inner join sys.dm_hadr_database_replica_cluster_states rcs          on drs.replica_id = rcs.replica_id  order by replica_server_name 

enter image description here

the listener for the availability group is calle SQLPROD_TS as you can see on the picture below

select * from  sys.availability_group_listener_ip_addresses  select * from  sys.availability_group_listeners  select * from  sys.dm_tcp_listener_states 

enter image description here

all is good, however, when I ask people to connect to SQLPROD_TS when they browse the network they can only see the nodes of the cluster.

enter image description here

Is there a way I could make sqlProd_ts to show up on the picture above, instead of the nodes?

Understanding Disk Array Availability

I’m new to this thus I’m trying to understand about calculating Disk Array Availability (DAA).

What I have understood so far is that availability is always 1, and Failure = 1÷MTBF, and that is all I could understand since morning.

Assume I have 1TB and the time is 5 years, and the disk’s MTBF is 1.6 millions hours (got this from Dell’s website for a 15K RPM disk), I need to know the availability of this disk in 5 years, how do I calculate, what is the formula, I’m seeing MTTR, and MTTDL and some other MTTs and getting confused.

Another confusion is, is disk array availability associated only with RAID.

Could someone explain in simple English how to calculate DAA.

Appreciate the assistance.

Currently I’m using this as reference : http://www.ecs.umass.edu/ece/koren/architecture/Raid/reliability.html (this reference has only formula with minimal or no explanation)

If anyone knows of any other good reference that explains in simple English.

Thank You

configurable products availability message

At magento 1.9.4 i use configurable products,

I would like to set custom stock message for configurable products and change when a options (color) is selected

for simple products i have the configuration for availability message at template/catalog/product/view/type/availability/default.phtml

    $  _product = $  this->getProduct(); ?> <?php $  _associatedProducts = $  this->getAssociatedProducts(); ?> <?php $  _hasAssociatedProducts = count($  _associatedProducts) > 0; ?> <?php if ($  this->displayProductStockStatus()): ?>     <?php if ($  _product->isAvailable()): ?> <?php if ($  _product->getAttributeText('katopin_paraggelias') == 'Ναι'): ?>         <p class="availability in-stock">             <i class="fa fa-ban"></i><span class="label"><?php echo $  this->helper('catalog')->__('Availability:') ?></span>             <span class="value"><?php echo $  this->helper('catalog')->__('Κατόπιν παραγγελίας') ?></span>         </p>     <?php elseif ( intval($  _quantity) <= 0 ): ?>         <p class="availability in-stock">             <i class="fa fa-truck"></i> <span class="label"><?php echo $  this->helper('catalog')->__('Availability:') ?></span>             <span class="value"><?php echo $  this->helper('catalog')->__('Παράδοση 2 - 7 εργάσιμες, επικοινωνήστε μαζί μας για διαθεσιμότητα.') ?></span>         </p> <?php else : ?> <p class="availability in-stock"> <i class="fa fa-truck"></i> <span class="label"><?php echo $  this->helper('catalog')->__('Availability:') ?></span>             <span class="value"><?php echo $  this->helper('catalog')->__('In stock') ?></span>         </p>   <?php endif; ?>     <?php else: ?>         <p class="availability out-of-stock">             <i class="fa fa-ban"></i> <span class="label"><?php echo $  this->helper('catalog')->__('Availability:') ?></span>             <span class="value"><?php echo $  this->helper('catalog')->__('Εκτός αποθέματος, επικοινωνήστε μαζί μας για διαθεσιμότητα.') ?></span>         </p>     <?php endif; ?> <?php endif; ?> 

Can this be done?